---

UPDATE report.smev_register r
SET sample_status = 'Удалён'
WHERE r.id IN (
    7842425, -- 2024
    7842426, -- 2023
    7842427  -- 2025
)
  AND r.smev_register_type_code = 'УНВ'
  AND NOT EXISTS (
      SELECT 1
      FROM report.unv_registry_item ri
      WHERE ri.registry_id = r.id
  )
RETURNING
    r.id,
    r."year",
    r.sample_status;





SELECT
    id,
    number,
    "year",
    "date",
    "type",
    sample_status,
    guid
FROM report.smev_register
WHERE smev_register_type_code = 'УНВ'
  AND sample_status IS DISTINCT FROM 'Удалён'
ORDER BY id DESC;