title: Magento abandoned cart for guest/unconfirmed users
body: <p>In Magento abandoned cart only works for verified registered users. Is there a way to capture it for guest and unconfirmed users <strong>programmaticaly</strong>?</p>
  
  <p>Also is there a way to email alert for the same?</p>
  
  <p>Please tell me atleast where should I start on this. I found on a forum that with below SQL you can get all the abandoned carts, but I found some of them missing from there as well.</p>
  
  <pre><code>SELECT entity_id, customer_firstname, customer_email, items_count, grand_total, created_at
  FROM sales_flat_quote
  WHERE entity_id NOT IN (SELECT quote_item_id AS quote_id FROM sales_flat_order_item) 
  AND items_count &gt;0
  AND customer_email IS NOT NULL
  ORDER BY `sales_flat_quote`.`created_at` DESC
  </code></pre>