---

SELECT
    j.id AS journal_id,
    j.contract_id,
    j.smevregisterid,
    j.model_file_to_verification_id AS file_id,
    f.register_id AS file_register_id,
    j.is_sent_to_fns
FROM report.fns_reference_request_journal j
LEFT JOIN dev.model_file_to_verification f
    ON f.id = j.model_file_to_verification_id
WHERE j.smevregisterid IN (14695214, 14695215, 14695216)
ORDER BY j.smevregisterid;