Загрузка данных


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;