[Resolved] Sort by most entries?

[Dolemite50]

Hi,
I have a site that allows people to write reviews. I am trying to come up with a query to list the top 10 reviewers judged on total number of reviews written.
Can anybody please give me a sample of how this is done?

I am currently entering them into a table called reviews with a column for date, userid, and review. I need to tally up all of the reviews and sort them by who has the most "userid" entries in the table.

I am storing date because I will also be tallying top daily reviewers.

Thanks alot.

[devinemke]

SELECT COUNT(*) AS count, userid FROM reviews GROUP BY userid ORDER BY count DESC LIMIT 10

[Dolemite50]

Thank you very much 🙂