select order customer email
piaoling 2011-12-20 12:07:18
SELECT DISTINCT `email` , `grid`.status
FROM `customer_entity` AS `e`
INNER JOIN sales_flat_order_grid AS `grid` ON `e`.`entity_id` = `grid`.customer_id
WHERE `grid`.paid_at
BETWEEN '2011-11-1'
AND '2011-11-30'
and `grid`.status!='return_complete'
发表评论（评论将通过邮件发给作者）：