• This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn more.

Most amount of posts in a X

Jake Bunce

XenForo moderator
Staff member
#2
Run this query on your database:

Code:
SELECT user.username AS username, COUNT(*) AS posts
FROM xf_post AS post
LEFT JOIN xf_user AS user ON (user.user_id = post.user_id)
WHERE post.post_date BETWEEN UNIX_TIMESTAMP('2008-01-15 00:00:00') AND UNIX_TIMESTAMP('2010-02-15 00:00:00')
GROUP BY post.user_id
ORDER BY posts
DESC
You will get results like this with the highest poster listed first:

Screen shot 2011-10-12 at 5.08.51 PM.png