1. 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

Discussion in 'XenForo Questions and Support' started by Matthew Sagen, Oct 13, 2011.

  1. Matthew Sagen

    Matthew Sagen Member

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

    Jake Bunce XenForo Moderator Staff Member

    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
     
  3. Matthew Sagen

    Matthew Sagen Member

    Thank you. :)
     

Share This Page