---

select
    ms.id as multiselect_id,
    ms.name as multiselect_name,
    pppp.id as product_param_id,
    pppp.pens_product_id,
    pp.id as param_id,
    pp.name as param_name,
    pp.brief as param_brief
from prod_line.hb_param_pl_multiselect ms
join prod_line.pens_product_param_pl_hb_param_pl_multiselect link
    on link.hb_param_pl_multiselect_id = ms.id
join prod_line.pens_product_param_pl pppp
    on pppp.id = link.pens_product_param_pl_id
join prod_line.param_pl pp
    on pp.id = pppp.param_pl_id
where ms.id in (417, 419, 448)
order by ms.id, pppp.pens_product_id;