List all customer emails with 3 or more purchases?

[sampsonzak]

Hi all, looking to see if anyone knows how I could easily list all customers email addresses with 3 or more orders?

 

With the customer export, this only shows 'total sales' rather than 'total orders' so I cannot use that.

 

Does anyone have any idea? Any neat SQL code that would do this for me? I have tried looking into the MySQL database, but ps_customers does not have any 'orders' or 'purchases' field/value, so I have no clue how to do this.

 

Would appreciate any help. Thanks alot! To get these email addresses exported into a text file would also be AMAZING if anyone could spare a few minutes and help me out on this.

 

Thanks!!

[tomerg3]

Here's a quick one with the order count (not filtering order by their status in any way)

 

SELECT c.id_customer, c.email, (SELECT COUNT(*) FROM ps_orders o WHERE o.id_customer = c.id_customer) AS order_count FROM ps_customer c WHERE
3 < (SELECT COUNT(*) FROM ps_orders o WHERE o.id_customer = c.id_customer)