SELECT
e.report,
p.id_etl,
p.id_loader,
p.version_ex,
p.id_process,
p.process_type,
p.load_post_process,
p.process_description,
p.active
FROM smev.smev_report_post_processes p
JOIN smev.smev_report_load_etl e
ON e.id = p.id_etl
AND e.version_ex = p.version_ex
WHERE concat_ws(
' ', e.report, e.version_text, p.process_description
) ~* 'фнс|вычет|справ|днп|уосс|звип'
ORDER BY p.id_etl, p.id_loader, p.version_ex, p.id_process;