Help me with a query pls

[neverstop]

HI everyone.

I am trying to make a list of users that have received the most reputation comments. That is not the most points (or least points) but how many total comments ocmbined they have received.

I dont need help with the php just the query has stumped me.

The table 'reputation' has the following fields:

reputationid postid userid reputation whoadded reason dateline



The field in question is 'userid'

Thanks in advance

[Adrian Schneider]

Try this... untested, as I have no data to test this on.

SELECT user.userid
, user.username
, counts.comments
FROM ( SELECT userid
, COUNT(*) AS comments
FROM reputation
WHERE reason IS NOT NULL
GROUP
BY userid ) AS counts
INNER
JOIN user
ON user.userid = counts.userid
ORDER
BY counts.comments DESC
LIMIT 10;

[neverstop]

Awesome, you even added the username for me!

Seems to work flawlessly Adrian, thank you so much man!