Skip to content

Instantly share code, notes, and snippets.

@aj-justo

aj-justo/ZenCart_SQL_Get_Completed_Orders

Created May 27, 2011 10:25
Show Gist options
  • Save aj-justo/995004 to your computer and use it in GitHub Desktop.
Save aj-justo/995004 to your computer and use it in GitHub Desktop.
Download ZIP
Zen Cart SQL: Get all completed orders (status=x)
Raw
ZenCart_SQL_Get_Completed_Orders
SELECT * FROM orders o, `orders_total` ot
WHERE o.orders_id=ot.orders_id AND
o.orders_status=3 AND
ot.title='total:'
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment