Skip to content

Instantly share code, notes, and snippets.

@bunnywong

bunnywong/gist:6fc72139a5adb7d3f8f9

Created March 12, 2015 15:50
Show Gist options
  • Save bunnywong/6fc72139a5adb7d3f8f9 to your computer and use it in GitHub Desktop.
Save bunnywong/6fc72139a5adb7d3f8f9 to your computer and use it in GitHub Desktop.
Download ZIP
Query offer products
Raw
gistfile1.sql
SELECT *, (quantity * price - reward) AS rewardDiff
FROM `oc_order_product`
WHERE `name` LIKE '%以上%'
AND (quantity * price - reward) < 0
ORDER BY rewardDiff
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment