---

SELECT
    pppp.pens_product_id AS product_id,
    pp.id AS param_id,
    pp."name" AS param_name,
    hppm.id AS value_id,
    hppm."name" AS contract_form
FROM prod_line.pens_product_param_pl_hb_param_pl_multiselect pppphppm
JOIN prod_line.hb_param_pl_multiselect hppm
    ON hppm.id = pppphppm.hb_param_pl_multiselect_id
JOIN prod_line.pens_product_param_pl pppp
    ON pppp.id = pppphppm.pens_product_param_pl_id
JOIN prod_line.param_pl pp
    ON pp.id = pppp.param_pl_id
WHERE pp."name" ILIKE '%Форма договора%'
ORDER BY pppp.pens_product_id, hppm.id
LIMIT 30;