---

fj_last AS (
  SELECT DISTINCT ON (contract_number)
         contract_number,
         model_file_to_verification_id,
         smevRegisterId
  FROM report.fns_reference_request_journal
  ORDER BY contract_number, request_date DESC
)


LEFT JOIN fj_last fj ON fj.contract_number = contract.number