Skip to content

Instantly share code, notes, and snippets.

@underdown

underdown/oc-orders-products.sql

Created November 8, 2018 23:26
Show Gist options

  • Select an option

    Learn more about clone URLs
  • Save underdown/b5860218e4ad091f3fa5296aea2624c7 to your computer and use it in GitHub Desktop.

Select an option

Learn more about clone URLs
Save underdown/b5860218e4ad091f3fa5296aea2624c7 to your computer and use it in GitHub Desktop.
Download ZIP
Add product details to orders data in opencart
Raw
oc-orders-products.sql
SELECT
*
FROM
oc_order o
LEFT JOIN
oc_order_product op
ON (o.order_id = op.order_id)
WHERE EXISTS (
SELECT
*
FROM
oc_order_product
WHERE
order_id=o.order_id)
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment