MySQL Query to get "Top 25 Posters in last 3 months"

[lyndonb]

something like:

select u.username, count(p.id) from
user u,
posts p
where p.postdate > (unix_timestamp()-(3*31*24*60*60)) and p.userid = u.userid
group by p.id, u.username having count(p.id) = max(p.id)

note the (3*31*24*60*60) will give the seconds for 3 * 31 days, so the 3 months is not exact.

That may be something like, but the syntax may need a tweak...