Special Query 1

Standard
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