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


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,