Загрузка данных


SELECT
    pp.name AS param_name,
    string_agg(
        DISTINCT hppm.name,
        ', ' ORDER BY hppm.name
    ) AS payment_type
FROM prod_line.pens_product_param_pl ppp
JOIN prod_line.param_pl pp
    ON pp.id = ppp.param_pl_id
JOIN prod_line.pens_product_param_pl_hb_param_pl_multiselect pm
    ON pm.pens_product_param_pl_id = ppp.id
JOIN prod_line.hb_param_pl_multiselect hppm
    ON hppm.id = pm.hb_param_pl_multiselect_id
WHERE ppp.pens_product_id = 6693
  AND pp.name = 'Тип выплаты'
GROUP BY pp.name;