Most amount of posts in a X

Jake Bunce

XenForo moderator
Staff member
Run this query on your database:

Rich (BB 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
You will get results like this with the highest poster listed first:

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