订单统计

https://www.magentocommerce.com/magento-connect/delete-orders-6.html

Delete Orders

 SELECT  `item_id` ,  `product_id` ,  `sku` , COUNT( 1 ) FROM  `sales_flat_order_item` WHERE 1 GROUP BY  `product_id` ORDER BY COUNT( 1 ) DESC 

SELECT * FROM  `sales_flat_order_item` WHERE  `created_at` >=  '2016-12-31 00:00:00'LIMIT 0 , 30