Skip to content

Instantly share code, notes, and snippets.

@thedarsideofit

thedarsideofit/prestashop-customers-orders.sql

Last active October 28, 2018 06:28
Show Gist options
  • Save thedarsideofit/40b5582530aa9c8ce3fc09abbcf03c0d to your computer and use it in GitHub Desktop.
Save thedarsideofit/40b5582530aa9c8ce3fc09abbcf03c0d to your computer and use it in GitHub Desktop.
Download ZIP
prestashop-customers-orders
Raw
prestashop-customers-orders.sql
SELECT `id_customer`,`id_gender`, `birthday`, `newsletter`, `optin`, `date_add`, `date_upd`,
(SELECT count(id_order)
FROM `ps_orders` inner join ps_order_state on ps_orders.current_state = ps_order_state.id_order_state
WHERE ps_orders.id_customer = ps_customer.id_customer and ps_order_state.paid = 1) orders
FROM `ps_customer`
WHERE 1
ORDER BY orders DESC
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment