COALESCE(
cp.min_initial_payment,
(
SELECT p_init.value_decimal
FROM prod_line.pens_product_param_pl p_init
JOIN prod_line.param_pl def_init
ON def_init.id = p_init.param_pl_id
WHERE p_init.pens_product_id = pp.id
AND def_init.brief = 'МинРазмерПервВзносаС'
AND p_init.value_decimal IS NOT NULL
ORDER BY p_init.id DESC
LIMIT 1
)
) AS initial_payment,