Who created most threads?

[theezy]

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

[Lats]

This query will give you the top 5 thread starters for last month...

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

[theezy]

This query will give you the top 5 thread starters for last month...

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.