SELECT t1.shade_sku SKU, t3.catalogue_title Product, t1.shade_name Shade, SUM( t1.order_quantity ) Quantity, SUM( t1.order_quantity * ( `item_promo_id` OR trans_promo_id ) <>0 ) Promo FROM p_shop_order t1, p_shop_transaction t2, p_shop_catalogue_data t3 WHERE `order_product_id` = t3.catalogue_id AND t3.catalogue_lang = 'eng' AND t1.`order_transaction` = t2.trans_id AND t2.trans_status IN ( '3', '4', '5', '6' ) AND t2.trans_date_buy BETWEEN '2013-03-01 00:00:00' AND '2013-04-01 00:00:00' GROUP BY t1.shade_sku ORDER BY Quantity DESC LIMIT 20