Magento ver. 1.5.1.0—根据系统当天时间，Order导出最近俩天的ERP需求数据SQL语句

SELECT 
DATE_FORMAT(OD.`created_at`,'%Y-%m-%d') as Update_Time,
OAD1.`customer_id` as 客户编号,
CONCAT(OAD1.`firstname`,' ',OAD1.`lastname`) as Shipping_name,
OAD1.`telephone` as 联系电话,
OD.`customer_email` as Email,
OAD1.`postcode` as 邮编,
OAD1.`street` as 街道,
OAD1.`city` as 城市, 
OAD1.`region` as 省,
OAD1.`company` as 公司,
CONCAT(OAD1.`street`,',',OAD1.`city`,',',OAD1.`region`,',',OAD1.`postcode`,',',OAD1.`company`) as 地址2,
CO.`country_name`  as 国家,
OD.`shipping_method` as 付款方式,
PRO.`sku` as 产品,
TRUNCATE(PRO.`base_row_total`/PRO.`base_price`,0) as 数量,
OD.`order_currency_code` as 货币,
TRUNCATE(PRO.`base_price`,2) as 销售单价,
TRUNCATE(PRO.`base_row_total`,2) as Total_Price,
TRUNCATE(OD.`base_shipping_amount`,2) as 运费,
OD.`increment_id` as 平台交易ID,
PRO.`product_id` as ItemNumber,
PRO.`name` as ItemTitle,
OD.`store_id`,
OM.`message` as 备注
FROM  `sales_flat_order` as OD
LEFT JOIN  `sales_flat_order_item` as PRO
ON OD.`entity_id`=PRO.`order_id`
LEFT JOIN `sales_flat_order_address` as OAD1
ON OD.`shipping_address_id`=OAD1.`entity_id`
LEFT JOIN `directory_country` as CO
ON OAD1.`country_id`=CO.`country_id`
LEFT JOIN `gift_message` as OM
ON OD.`gift_message_id`=OM.`gift_message_id`
LEFT JOIN `sales_flat_order_status_history` as OS
ON  OD.`entity_id`= OS.`parent_id` AND  OS.`status` = 'complete'
WHERE DATE_FORMAT(OD.`created_at`,'%Y-%m-%d')=current_date
OR  DATE_FORMAT(OD.`created_at`,'%Y-%m-%d')=DATE_FORMAT(adddate(now(),-1), '%Y-%m-%d')
group by PRO.`item_id`