SELECT SUM(

CASE
    WHEN `app_orders`.`payment` = 'cash' AND `app_orders`.`money` IS NOT NULL
        THEN (`app_orders_items`.`quantity` * `app_orders_items`.`price`) - `app_orders`.`money`
    WHEN `app_orders`.`payment` = 'card' AND `app_acquiring`.`status` = 'successful'
        THEN 0
    ELSE
        `app_orders_items`.`quantity` * `app_orders_items`.`price`
END


) AS `amount`
FROM     `app_orders`
JOIN `app_orders_items` ON (`app_orders`.`id` = `app_orders_items`.`order`)
LEFT JOIN `app_acquiring` ON (`app_orders`.`id` = `app_acquiring`.`order`)
WHERE    `app_orders`.`customer` = 1 AND
        `app_orders`.`status` = 'closed' AND
        `app_orders`.`payment` != 'bank_successful';