Abandon Cart example

abandon-cart.sql

SELECT `main_table`.*,
       (main_table.base_subtotal_with_discount*main_table.base_to_global_rate) AS `subtotal`,
       `cust_email`.`email`,
       `cust_fname`.`value` AS `firstname`,
       `cust_lname`.`value` AS `lastname`,
       CONCAT_WS(' ', cust_fname.value, cust_lname.value) AS `customer_name`
FROM `sales_flat_quote` AS `main_table`
INNER JOIN `customer_entity` AS `cust_email` ON cust_email.entity_id = main_table.customer_id
INNER JOIN `customer_entity_varchar` AS `cust_fname` ON cust_fname.entity_id = main_table.customer_id
AND cust_fname.attribute_id = 5
INNER JOIN `customer_entity_varchar` AS `cust_lname` ON cust_lname.entity_id = main_table.customer_id
AND cust_lname.attribute_id = 7
WHERE (items_count != '0')
  AND (main_table.is_active = '1')
ORDER BY updated_at DESC