How can I display a list of most active users based on the total comments they post?
Thank you for your time
This is an archived forum and the content is probably no longer relevant, but is provided here for posterity.
The active forums are here.
October 14, 2008 1:30am
Subscribe [2]#1 / Oct 14, 2008 1:30am
How can I display a list of most active users based on the total comments they post?
Thank you for your time
#2 / Oct 14, 2008 3:26am
A custom query, I should think:
SELECT name, COUNT(name) AS number FROM `exp_comments`
WHERE status = 'o' GROUP BY name ORDER BY number DESC, name ASCThat should do nicely.