Skip to content

Instantly share code, notes, and snippets.

@unlocomqx

unlocomqx/inputs_query.sql

Created November 10, 2017 11:59
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save unlocomqx/20d974241d469d4b05942397da319d23 to your computer and use it in GitHub Desktop.
Save unlocomqx/20d974241d469d4b05942397da319d23 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
inputs_query.sql
SELECT di.inputs FROM ps_dynamicproduct_input di
LEFT JOIN ps_customized_data cd ON di.id_customization = cd.id_customization
LEFT JOIN ps_customization cu ON cu.id_customization = cd.id_customization
LEFT JOIN ps_orders od ON od.id_cart = cu.id_cart
WHERE od.id_order = 8
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment