Most amount of posts in a X

[Matthew Sagen]

Is there anyway possible to see who has the most amount of posts in a given week (7 days)? Just wondering.

 

[Jake Bunce]

Run this query on your database:

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:

 

[Matthew Sagen]

Thank you.