---

SELECT *
FROM report.unv_annual_setting
WHERE client_id = 5512
  AND contract_id = 13029594;




SELECT
    "year",
    COUNT(*) AS registry_count
FROM report.smev_register
WHERE smev_register_type_code = 'УНВ'
  AND sample_status IS DISTINCT FROM 'Удалён'
GROUP BY "year"
ORDER BY "year";



SELECT *
FROM report.unv_registry_item
WHERE client_id = 5512
  AND contract_id = 13029594
  AND tax_period_year = 2025;