---

(
    select sr.number
    from report.fns_reference_request_journal fj
    left join dev.model_file_to_verification mfc
        on mfc.id = fj.model_file_to_verification_id
    left join report.smev_register sr
        on sr.id = mfc.register_id
    where fj.model_file_to_verification_id = :flk_id
    order by fj.request_date desc, fj.id desc
    limit 1
) as req_number,