Skip to content

Instantly share code, notes, and snippets.

@hansek
Created January 24, 2014 09:47
Show Gist options
  • Save hansek/8594678 to your computer and use it in GitHub Desktop.
Save hansek/8594678 to your computer and use it in GitHub Desktop.
Presta - cross selling - orders
SELECT o.id_order
FROM ps_orders o
LEFT JOIN ps_order_detail od ON (od.id_order = o.id_order)
WHERE o.valid = 1
AND od.product_id = 991
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment