---

SELECT
    fj.id,
    fj.model_file_to_verification_id AS model_file_id,
    fj.smevRegisterId AS smev_register_id,
    fj.is_sent_to_fns AS is_sent_to_fns,
    sr.number AS request_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 EXISTS (
    SELECT 1
    FROM tools.selection s
    WHERE s.row_id = fj.id
      AND s.username = :username
      AND s.code = :query_table_code
)



#set ( $l = $db.find($params) )
{
  "list": [
    #if ($l)
      #foreach ( $t in $l )
      {
        "id": "$t.id",
        "model_file_id": "$t.model_file_id",
        "smevRegisterId": "$t.smev_register_id",
        "is_sent_to_fns": "$t.is_sent_to_fns",
        "request_number": "$t.request_number"
      }#if($foreach.hasNext),#end
      #end
    #end
  ]
}