Announcement

Collapse
No announcement yet.

Who created most threads?

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • Who created most threads?

    Is there a way to tell which member has created the most new threads in a month?

  • #2
    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...

    Comment


    • #3
      Originally posted by Lats View Post
      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
      Thanks! It works.

      Comment

      widgetinstance 262 (Related Topics) skipped due to lack of content & hide_module_if_empty option.
      Working...
      X