SELECT
qm.id AS query_model_id,
qm.code AS query_model_code,
qm.name AS query_model_name,
qmq.name AS query_name,
qmq.query
FROM dev.query_model_query qmq
JOIN dev.query_model qm
ON qm.id = qmq.query_model_id
WHERE qmq.query ILIKE '%contract_params%'
AND qmq.query ILIKE '%form_id%'
ORDER BY qm.name, qmq.name;
SELECT
qm.id AS query_model_id,
qm.code AS query_model_code,
qm.name AS query_model_name,
qmq.name AS query_name,
qmq.query
FROM dev_local.query_model_query qmq
JOIN dev_local.query_model qm
ON qm.id = qmq.query_model_id
WHERE (qmq.is_deleted IS NULL OR qmq.is_deleted = false)
AND qmq.query ILIKE '%contract_params%'
AND qmq.query ILIKE '%form_id%'
ORDER BY qm.name, qmq.name;