COALESCE(
cp.minimal_payment_amount,
(
SELECT mp.min_pension_from
FROM prod_line.pens_product_param_pl p_min
JOIN prod_line.param_pl def_min
ON def_min.id = p_min.param_pl_id
JOIN prod_line.table_param_pl_minimum_pension mp
ON mp.pens_product_param_pl_id = p_min.id
WHERE p_min.pens_product_id = pp.id
AND def_min.brief = 'МинРазмерПенсии'
AND mp.min_pension_from IS NOT NULL
ORDER BY mp.id DESC
LIMIT 1
)
) AS min_payment_amount,