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;