---

SELECT
    p.name AS param_name,
    p.brief AS param_brief,
    ppp.value_int,
    ppp.value_decimal,
    ppp.value_ref,
    ms.name AS multiselect_value
FROM prod_line.pens_product_param_pl ppp
JOIN prod_line.param_pl p
    ON p.id = ppp.param_pl_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 ms
    ON ms.id = pm.hb_param_pl_multiselect_id
WHERE ppp.pens_product_id = 6693
  AND (
      p.name ILIKE '%периодич%'
      OR p.brief ILIKE '%периодич%'
      OR p.name ILIKE '%частот%'
  )
ORDER BY p.name, ms.name;