Skip to content

Instantly share code, notes, and snippets.

@unlocomqx

unlocomqx/customization.sql

Created November 28, 2017 17:00
Show Gist options
  • Save unlocomqx/37ef6ed93b0d8b49f8c6a1d097d07e22 to your computer and use it in GitHub Desktop.
Save unlocomqx/37ef6ed93b0d8b49f8c6a1d097d07e22 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
customization.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 o ON o.id_cart = cu.id_cart
JOIN ps_order_detail od ON o.id_order = od.id_order
WHERE o.id_order = 12 AND di.id_customization = 57
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment