Skip to content

Instantly share code, notes, and snippets.

@unlocomqx

unlocomqx/query.sql

Last active October 13, 2022 11:06
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/d0228605a89e31c8e04a5387a7ee6364 to your computer and use it in GitHub Desktop.
Save unlocomqx/d0228605a89e31c8e04a5387a7ee6364 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
query.sql
SELECT `price`
FROM `shoppre__attribute_tier_pricing`
WHERE `id_attribute` = 28
AND `id_attribute_group` = 5
AND `min_qty` <= 1
AND `max_qty` >= 1
AND `id_customer` IN (0, 0)
ORDER BY id_customer DESC
LIMIT 1
# result https://scr.prestalife.net/sc2h6r0
# backoffice https://scr.prestalife.net/sc0y8t6
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment