---

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
FROM dev.query_model_query qmq
JOIN dev.query_model qm
    ON qm.id = qmq.query_model_id
WHERE qmq.query ILIKE '%contract_template_code%'
   OR qmq.query ILIKE '%contract_template_id%'

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
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_template_code%'
    OR qmq.query ILIKE '%contract_template_id%'
  )
ORDER BY source_schema, query_model_name;