Code
SELECT Count( * ) AS UserPosts, POST_POSTER_NAME
FROM ubbt_POSTS
WHERE POST_POSTED_TIME > UNIX_TIMESTAMP( '2008-04-20 00:00:00' ) -86400 *30
GROUP BY POST_POSTER_NAME
ORDER BY UserPosts DESC
LIMIT 10

(Modifying SD's code) gives you the top 10 posters from the last 30 days smile

- Allen
- ThreadsDev | PraiseCafe