How can I figure out which user on my forums was the most active in 2008?
Top Poster in 2008...How do i??
Collapse
X
-
-
This query will show your top 5 posters for 2008...Code:SELECT post.username, count( post.postid ) AS postcount FROM post LEFT JOIN thread ON thread.threadid = post.threadid WHERE post.dateline > 1199145600 AND post.dateline < 1230768000 GROUP BY post.username ORDER BY postcount DESC LIMIT 5
Lats... -
Lats,
I appreciate your help...
I ran that querey and it didn't show anything..
"Results: 5 (0.0008s), Page 1 of 1"
That's all that it showed...Comment
-
I am not sure how to run it in phpMyadmin...
I removed the vertical spacing and ran it like this and got the same rults with 5 results and nothing on the page;
Code:SELECT post.username, count( post.postid ) AS postcount FROM post LEFT JOIN thread ON thread.threadid = post.threadid WHERE post.dateline > 1199145600 AND post.dateline < 1230768000 GROUP BY post.username ORDER BY postcount DESC LIMIT 5
Comment
-
Your hosting control panel normally has a link to phpmyadmin however, run this version of the query in the ACP...Code:SELECT post.username, count( post.postid ) AS postcount FROM post LEFT JOIN thread ON thread.threadid = post.threadid WHERE post.dateline > 1199145600 AND post.dateline < 1230768000 GROUP BY post.username ORDER BY postcount DESC LIMIT 5
Lats...Comment
-
widgetinstance 262 (Related Topics) skipped due to lack of content & hide_module_if_empty option.
Comment