Загрузка данных


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;