/*获取 头一天的订单里的产品的qty_ordered*/
SELECT `main_table`.increment_id,`main_table`.`status`, `main_table`.created_at,
item_table.qty_ordered,item_table.product_id,item_table.sku
FROM `sales_flat_order_grid` AS `main_table`
LEFT JOIN sales_flat_order_item AS `item_table` ON item_table.order_id=main_table.entity_id
WHERE main_table.created_at >= date_sub(curdate(),interval 1 day)
AND main_table.created_at < curdate()
AND main_table.`status` = 'processing'
ORDER BY created_at desc;