---

select
    pppp.pens_product_id,
    p.name as product_name,
    pppp.param_pl_id,
    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.pens_product p
    on p.id = pppp.pens_product_id
where pppp.param_pl_id = 338
  and (
       pppp.value_int is not null
    or pppp.value_decimal is not null
    or pppp.value_string is not null
    or pppp.value_date is not null
    or pppp.value_bool is not null
    or pppp.value_ref is not null
  )
order by pppp.pens_product_id;