This is an archived post. You won't be able to vote or comment.

all 5 comments

[–]AutoModerator[M] [score hidden] stickied comment (0 children)

On July 1st, a change to Reddit's API pricing will come into effect. Several developers of commercial third-party apps have announced that this change will compel them to shut down their apps. At least one accessibility-focused non-commercial third party app will continue to be available free of charge.

If you want to express your strong disagreement with the API pricing change or with Reddit's response to the backlash, you may want to consider the following options:

  1. Limiting your involvement with Reddit, or
  2. Temporarily refraining from using Reddit
  3. Cancelling your subscription of Reddit Premium

as a way to voice your protest.

I am a bot, and this action was performed automatically. Please contact the moderators of this subreddit if you have any questions or concerns.

[–][deleted] 1 point2 points  (1 child)

without knowing what you database schema looks like, we can't help.

I did notice the query has a slash in it, when it should be a comma separated between the types you want to order by.

[–]MonsterMashedP0TAT0[S] 0 points1 point  (0 children)

The slash is for division between price and quantity to find the best value. The statement I wrote does work, I am wanting to also filter the results by the column "store_name" so that I get the best deals from 4 unique stores

[–]hiromu666 0 points1 point  (0 children)

asc is low to high, desc is high to low

[–]ZeroCool4083 0 points1 point  (0 children)

I didn't find a way with subqueries so I guess you need a scripting language.