Magento 1.9.2 SQL Query to retrive buyers from our customers

SELECT * FROM Customers 
WHERE purchase_date BETWEEN 'start_date' AND 'end_date'

Select allOpen in new window

SELECT `e`.*, MAX(o.created_at) AS `last_order_date` FROM `customer_entity` AS `e` LEFT JOIN `sales_flat_order` AS `o` ON o.customer_id = e.entity_id WHERE (`e`.`entity_type_id` = '1') GROUP BY `e`.`entity_id` HAVING (last_order_date < '2014-03-26') OR (last_order_date IS NOT NULL)

Select allOpen in new window

This will return all customers that made a purchase from the last_order_date (you can set your own date) and the date when you make the query.

Hope it helps.

I tested it myself, it should work and return what you need.

Let me know if it works for you.

Yes it worked fine, thanks !

 ¿could we include number of order per customer?

great thanks!

thks