Magento SQL导出客户购物车产品信息(客户email,产品ID,产品名称,产品描述,产品价格,产品图片)

更多详细，请在我的网站：http://www.witselzz.com/

SELECT
     P1.`customer_email`,
     P2.`created_at`,
     P2.`product_id`,
     P2.`sku`,
     P2.`name`,
     (
          SELECT
               `description`
          FROM
               `catalog_product_flat_1`
          WHERE
               `sku` = P2.`sku`
     ) AS `description`,
     P2.`price`,
     (
          SELECT
               `request_path`
          FROM
               `core_url_rewrite`
          WHERE
               `product_id` = P2.`product_id`
               and `store_id` = 1
               and `is_system` = 1
     ) as `product url`,
     (
          SELECT
               `value`
          FROM
               `catalog_product_entity` AS a
               INNER JOIN `eav_attribute` AS `attribute` ON `attribute`.attribute_code = ‘image’
               AND `attribute`.frontend_input = ‘media_image’
               LEFT JOIN `catalog_product_entity_varchar` AS b ON a.entity_id = b.entity_id
               AND b.attribute_id = attribute.attribute_id
          WHERE
               `sku` = P2.`sku`
     ) as `product image`
FROM
     `sales_flat_quote` AS P1,
     `sales_flat_quote_item` AS P2
WHERE
     P1.`customer_email` IS NOT NULL
     AND P2.`quote_id` = P1.`entity_id`
     AND P2.`created_at` > ‘2015-04-04’

     AND P2.`created_at` < ‘2015-04-11’