Skip to content

Instantly share code, notes, and snippets.

@unlocomqx

unlocomqx/query-test.sql

Created October 4, 2024 08:33
Show Gist options
  • Save unlocomqx/06e1bf99d55a2c5b7792e0d543034219 to your computer and use it in GitHub Desktop.
Save unlocomqx/06e1bf99d55a2c5b7792e0d543034219 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
query-test.sql
SELECT od.* FROM ps_order_detail od
LEFT JOIN ps_dynamicproduct_input di ON di.id_customization = od.id_customization
LEFT JOIN ps_dynamicproduct_input_field dif ON dif.id_input = di.id_input AND dif.type = 8 #dropdown type
LEFT JOIN ps_dynamicproduct_dropdown_option ddo ON ddo.id_field = dif.id_field AND ddo.sku = '10x10'
LEFT JOIN ps_orders o ON o.id_order = od.id_order
WHERE o.date_add BETWEEN '2024-04-24 14:04:49' AND '2024-04-25 14:04:49'
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment