---

WITH params AS (
    SELECT 12345::integer AS model_file_id
)
SELECT
    m.id AS model_file_id,
    m.register_id AS smev_register_id,
    sr.number AS request_number,

    (
        SELECT count(*)
        FROM report.fns_reference_request_journal fj
        WHERE fj.model_file_to_verification_id = m.id
    ) AS journal_rows_count,

    (
        SELECT count(*)
        FROM dev.model_file_to_verification m2
        WHERE m2.register_id = m.register_id
    ) AS files_for_register_count,

    (
        SELECT bool_or(COALESCE(fj.is_sent_to_fns, false))
        FROM report.fns_reference_request_journal fj
        WHERE fj.model_file_to_verification_id = m.id
    ) AS was_sent_to_fns

FROM dev.model_file_to_verification m
LEFT JOIN report.smev_register sr
    ON sr.id = m.register_id
CROSS JOIN params p
WHERE m.id = p.model_file_id;