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


SELECT
    p.name AS param_name,
    p.brief AS param_brief,
    ppp.id AS product_param_id,
    mp.*
FROM prod_line.pens_product_param_pl ppp
JOIN prod_line.param_pl p
    ON p.id = ppp.param_pl_id
LEFT JOIN prod_line.table_param_pl_minimum_pension mp
    ON mp.pens_product_param_pl_id = ppp.id
WHERE ppp.pens_product_id = 6693
  AND (
      p.brief = 'МинРазмерПенсии'
      OR p.name ILIKE '%размер%пенси%'
      OR p.name ILIKE '%размер%выплат%'
  )
ORDER BY ppp.id;