---

SELECT
    sr.id AS register_id,
    sr.number AS register_number,
    mf.id AS file_id
FROM report.smev_register sr
LEFT JOIN dev.model_file_to_verification mf
    ON mf.register_id = sr.id
   AND mf.service_name = 'SMEF FNS'
WHERE sr.id BETWEEN 14695203 AND 14695210
ORDER BY sr.id;