---

select
    pppp.param_pl_id,
    pp.name,
    pp.brief,
    pppp.value_int,
    pppp.value_decimal,
    pppp.value_string,
    pppp.value_date,
    pppp.value_bool,
    pppp.value_ref
from prod_line.pens_product_param_pl pppp
join prod_line.param_pl pp
    on pp.id = pppp.param_pl_id
where pppp.pens_product_id = 8977
  and pppp.param_pl_id in (306, 307, 308, 309, 5345)
order by pppp.param_pl_id;