---

SELECT
    p.id AS param_pl_id,
    p."name" AS param_name,
    p.brief,
    ppp.id AS pens_product_param_pl_id,
    ppp.pens_product_id,
    m.id AS multiselect_id,
    m."name" AS multiselect_name
FROM prod_line.param_pl p
JOIN prod_line.pens_product_param_pl ppp
    ON ppp.param_pl_id = p.id
LEFT JOIN prod_line.pens_product_param_pl_hb_param_pl_multiselect pm
    ON pm.pens_product_param_pl_id = ppp.id
LEFT JOIN prod_line.hb_param_pl_multiselect m
    ON m.id = pm.hb_param_pl_multiselect_id
WHERE p.brief = 'ПериодичностьВзносов'
ORDER BY ppp.pens_product_id
LIMIT 50;