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


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,