---

SELECT
    p.id,
    p."name",
    p.brief,
    p.hb_param_pl_table_id,
    t."name" AS table_name,
    t.brief AS table_brief
FROM prod_line.param_pl p
LEFT JOIN prod_line.hb_param_pl_table t
    ON t.id = p.hb_param_pl_table_id
WHERE t."name" = 'table_param_pl_redemption_coeff'
   OR lower(p."name") LIKE '%выкуп%'
ORDER BY p.id;