SELECT DISTINCT
fj.model_file_to_verification_id AS model_file_id
FROM report.fns_reference_request_journal fj
WHERE fj.created_at >= NOW() - INTERVAL '1 day'
AND fj.is_sent_to_fns = false
AND fj.model_file_to_verification_id IS NOT NULL
ORDER BY model_file_id;
#set($rows = $db.find($requests))
{
"list": [
#foreach($row in $rows)
{
"end_b": "$row.model_file_id"
}#if($foreach.hasNext),#end
#end
]
}