---

SELECT
    query_model_id,
    name,
    substring(
        query
        FROM greatest(
            position('contribution_ss' IN lower(query)) - 300,
            1
        )
        FOR 1000
    ) AS fragment
FROM dev.query_model_query
WHERE lower(query) LIKE '%contribution_ss%'
ORDER BY query_model_id;




SELECT
    query_model_id,
    name,
    substring(
        query
        FROM greatest(
            position('contribution_sr' IN lower(query)) - 300,
            1
        )
        FOR 1000
    ) AS fragment
FROM dev.query_model_query
WHERE lower(query) LIKE '%contribution_sr%'
ORDER BY query_model_id;