Originally Posted by
lat9
How are you with phpMyAdmin? Could you post the contents of the query_string field that's in your zen_query_builder table and associated with the Dormant Customers (>3months) (Subscribers)? Remember to post the information in a code-block (#).
Hi lat9
Thanks, Here it is
Code:
select o.date_purchased, c.customers_email_address, c.customers_lastname, c.customers_firstname from TABLE_CUSTOMERS c,
TABLE_ORDERS o WHERE c.customers_id = o.customers_id AND c.customers_newsletter = 1 GROUP BY c.customers_email_address HAVING
max(o.date_purchased) <= subdate(now(),INTERVAL 3 MONTH) ORDER BY c.customers_lastname, c.customers_firstname ASC
Bookmarks