---

SELECT
    'dev' AS source_schema,
    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%form_id%'
   OR qmq.query ILIKE '%landscape_form%'
   OR qmq.query ILIKE '%form_id%landscape_form%'

UNION ALL

SELECT
    'dev_local' AS source_schema,
    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%form_id%'
    OR qmq.query ILIKE '%landscape_form%'
    OR qmq.query ILIKE '%form_id%landscape_form%'
  )
ORDER BY source_schema, query_model_name, query_name;