Ordering by Popularity

[wilhud]

Hello,

I was wondering if someone could help me with this.

I'm trying to write a SQL query that will return the bestselling items from a shop. The items are held in a table called order. What I need to do is query all of the items that have been placed in the order table and then return the top 5 that hold the most rows in that table. Is this possible? Or do I need to do a query and then pull the results after that somehow? Any feedback would be great. Hope this makes sense. Thanks in advance.

Wil

[nnichols]

Yes this is possible. What is the structure of your order tsble?

[wilhud]

table name:
order

fields:
order_id
item_id

I want to sort it by the 5 most popular item_id values.

[nnichols]

Try this -

SELECT COUNT(*) AS count, item_id
FROM order
GROUP BY item_id
ORDER BY count DESC
LIMIT 5

Hope this helps 😉

[wilhud]

Perfect!! You rule nnichols!!! I think that was about as painless as it gets. Thanks for the quick response, I really appreciate it!!! 😃

Wil