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") 
      		                   * IF(a.type LIKE "Privatperson", 0.100000, 0.200000)
    		                  +
    		                  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") 
      		                   * IF(a.type LIKE "Privatperson", 0.100000, 0.200000)
    		                  +
    		                  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