select sku,COUNT(sku) cc from sales_flat_order_item where order_id in(SELECT entity_id from sales_flat_order where state in(‘complete‘,‘processing‘)) GROUP BY sku ORDER BY cc DESC #产品销量
magento mysql,布布扣,bubuko.com
magento mysql
原文：http://my.oschina.net/liufeng815/blog/290506
