Query for entity with highest rating within a specific category?

Vote:
 

I want to create a list of the highest ranked Clubs (or any other entity for that matter) within a single Category, which is the best way of achieving that?

Since I cannot sort a query based on AvgRating (see this thread), I´m stuck getting all entities for a Category and then sorting on AvgRating to get what I want. Seems like a lot of overhead to get hundreds/thousands of items and then sorting them to get the two items with the highest rating.

Any ideas?

#33196
Oct 05, 2009 14:25
This thread is locked and should be used for reference only. Please use the Legacy add-ons forum to open new discussions.
* You are NOT allowed to include any hyperlinks in the post because your account hasn't associated to your company. User profile should be updated.