query

[sabret00the]

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

[assassingod]

Untested, but try:


SELECT *
FROM `user`
ORDER BY `posts` AND `lastpost` DESC
LIMIT 0 , 30

[insanctus]

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 :)

[sabret00the]

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