---

SELECT
    r.id,
    r."year",
    r."date",
    r.sample_status,
    r.guid,
    COUNT(ri.id) AS item_count
FROM report.smev_register r
LEFT JOIN report.unv_registry_item ri
       ON ri.registry_id = r.id
WHERE r.smev_register_type_code = 'УНВ'
GROUP BY
    r.id,
    r."year",
    r."date",
    r.sample_status,
    r.guid
ORDER BY r.id DESC;