SELECT a.id, a.username, a.email, a.hits, (SELECT SUM(oi.amount*oi.price) FROM orders o LEFT JOIN orders_items oi ON (oi.order_id = o.id) WHERE o.affiliate_id = a.id AND o.currency = "euro") - IFNULL((SELECT SUM(amount) FROM affiliates_slips WHERE affiliate_id = a.id AND currency = "euro"), 0) AS balance_euro, (SELECT SUM(oi.amount*oi.price) FROM orders o LEFT JOIN orders_items oi ON (oi.order_id = o.id) WHERE o.affiliate_id = a.id AND o.currency = "sek") - IFNULL((SELECT SUM(amount) FROM affiliates_slips WHERE affiliate_id = a.id AND currency = "sek"), 0) AS balance_sek FROM affiliates AS a WHERE a.deleted = 0 AND (1=1) ORDER BY a.username DESC LIMIT 0,20