SELECT a.id, a.username, a.email, a.hits, SUM(oi_euro.amount*oi_euro.price) - SUM(as_euro.amount) AS balance_euro, SUM(as_sek.amount) AS balance_sek FROM %s AS a LEFT JOIN affiliates_slips AS as_euro ON (as_euro.affiliate_id = a.id AND as_euro.currency = "euro") LEFT JOIN affiliates_slips AS as_sek ON (as_sek.affiliate_id = a.id AND as_sek.currency = "sek") LEFT JOIN orders o_sek ON (o_sek.affiliate_id = a.id) LEFT JOIN orders_items oi_sek ON (oi_sek.order_id = o_sek.id) LEFT JOIN orders o_euro ON (o_euro.affiliate_id = a.id) LEFT JOIN orders_items oi_euro ON (oi_euro.order_id = o_euro.id) WHERE a.deleted = 0 AND (%s) GROUP BY a.id %s