---

SELECT
    qt.id AS query_table_id,
    to_jsonb(qt) ->> 'code' AS table_code,
    to_jsonb(qt) ->> 'name' AS table_name,
    ta.name AS button_name,
    a.id AS query_action_id,
    to_jsonb(a) ->> 'code' AS action_code,
    to_jsonb(a) ->> 'name' AS action_name,
    c.ordinal AS command_order,
    to_jsonb(c) ->> 'name' AS command_name,
    c.command
FROM dev.query_table qt
JOIN dev.query_table_action ta
    ON ta.query_table_id = qt.id
LEFT JOIN dev.query_action a
    ON a.id = ta.query_action_id
LEFT JOIN dev.query_action_command c
    ON c.query_action_id = a.id
WHERE to_jsonb(qt) ->> 'name'
          = 'Реестр решений по переводу из РОПС'
  AND ta.name ILIKE '%провест%'
ORDER BY qt.id, a.id, c.ordinal, c.id;