---

SELECT
    mf.id AS file_id,
    mf.register_id,
    m.id AS outgoing_id,
    m.record_status,
    fr.requestid
FROM dev.model_file_to_verification mf
LEFT JOIN mtrustgate.moutlist m
    ON m.mftv_id = mf.id
LEFT JOIN mtrustgate.fns_tax_refund_register fr
    ON fr.moutlist_id = m.id
WHERE mf.id BETWEEN 8000 AND 8007
ORDER BY mf.id, m.id;