---

SELECT
    j.id AS journal_id,
    j.contract_number,
    j.smevregisterid AS register_id,
    j.model_file_to_verification_id AS file_id,
    mf.register_id AS file_register_id,
    coalesce(
        mf.register_id = j.smevregisterid,
        false
    ) AS link_matches
FROM report.fns_reference_request_journal j
LEFT JOIN dev.model_file_to_verification mf
    ON mf.id = j.model_file_to_verification_id
WHERE j.request_date >= DATE '2026-10-31'
  AND j.smevregisterid <= 14695210
  AND j.contract_id IN (
      13577704, 13591643, 13616389, 13644952,
      13661723, 13670074, 13687399, 13687807
  )
ORDER BY j.id DESC;