Is there a way to tell which member has created the most new threads in a month?
Announcement
Collapse
No announcement yet.
Who created most threads?
Collapse
X
-
This query will give you the top 5 thread starters for last month...Code:SELECT post.username, count( post.postid ) AS postcount FROM post WHERE post.parentid = 0 AND dateline >= unix_timestamp( '2010-04-01 12:00:00' ) AND dateline <= unix_timestamp( '2010-04-30 23:59:59' ) GROUP BY post.username ORDER BY postcount DESC LIMIT 5
Lats...
-
Originally posted by Lats View PostThis query will give you the top 5 thread starters for last month...Code:SELECT post.username, count( post.postid ) AS postcount FROM post WHERE post.parentid = 0 AND dateline >= unix_timestamp( '2010-04-01 12:00:00' ) AND dateline <= unix_timestamp( '2010-04-30 23:59:59' ) GROUP BY post.username ORDER BY postcount DESC LIMIT 5
Comment
widgetinstance 262 (Related Topics) skipped due to lack of content & hide_module_if_empty option.
Comment