---

SELECT
    l.id AS load_snv_id,
    l.contract_number,
    l.request_number AS file_request_number,
    sr.number AS journal_request_number,
    fns.is_sent_to_fns,
    fns.response_received
FROM ourpension.load_snv l
LEFT JOIN report.fns_reference_request_journal fns
    ON fns.contract_number = l.contract_number
LEFT JOIN dev.model_file_to_verification mfc
    ON mfc.id = fns.model_file_to_verification_id
LEFT JOIN report.smev_register sr
    ON sr.id = mfc.register_id
WHERE l.file_id = 161411
ORDER BY l.id, sr.number;