query
 

what query would i need to run to find out the number of members who have posted more than 100 times in the post 30 days but excluding mods, admins and supermods

Untested, but try:

[SQL]
SELECT *
FROM `user`
ORDER BY `posts` AND `lastpost` DESC
LIMIT 0 , 30
[/SQL]

Actually I am thinking the only way to get the right number you would have to do a query on all posts, Have it sort them by members id then date.

Hmmm the only way I can think of is to much work :)

thanks, will test it and let you know how it goes