Re: SQL query - highest rated or least voted items There are several ways I can think of to do this but here's one.
Two queries.
One returns the top 40%, another less than 5 votes.
Union.
Wrap them with another query and use distinct to de-dupe.
Ordering them in any way could of course be tricky as you're comparing
apples n oranges. |