SELECT sum(su.pay_amount)
From (
SELECT o.id, o.order_status_id, o.payment, oo.hold_active, oo.amount, oo.pay_amount
FROM orders o
INNER JOIN orders_hash oo on o.id = oo.order_id
WHERE o.payment in ('5', '6', '7') and o.order_status_id not in ('4') and o.customer_id != 112435 and oo.active = 1
Order by o.id desc) as su