SELECT
ppp.id,
pp.name AS param_name,
pp.brief AS param_brief,
ppp.value_int,
ppp.value_decimal,
ppp.value_ref
FROM prod_line.pens_product_param_pl ppp
JOIN prod_line.param_pl pp
ON pp.id = ppp.param_pl_id
WHERE ppp.pens_product_id = 6693
AND (
pp.name ILIKE '%перв%'
OR pp.brief ILIKE '%перв%'
OR pp.name ILIKE '%взнос%'
OR pp.brief ILIKE '%взнос%'
)
ORDER BY pp.name;