,(
            SELECT SUM(o.total_payment) FROM '._DB_PREFIX_.'orders o
            WHERE o.id_customer = a.id_customer
            GROUP BY o.id_customer
            LIMIT 1
        ) as customer_sum

(
            SELECT SUM(o.total_paid) FROM '._DB_PREFIX_.'orders o
            WHERE o.id_customer = a.id_customer and o.id_order IN (SELECT oh.id_order FROM '._DB_PREFIX_.'order_history oh WHERE oh.id_order_state = 4)
            GROUP BY o.id_customer
            LIMIT 1
        ) as customer_sum';