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