[Dismounted]

Originally Posted by Eikinskjaldi

SELECT userid, username, count(*) as 'total' FROM post p join thread t USING(threadid) where forumid in (2,5,10,12,15) group by userid order by total desc

Wow, I can hardly decipher that .
[sql]SELECT userid, username, count(*) AS total
FROM post p
JOIN thread t USING(threadid) WHERE forumid IN (2,5,10,12,15)
GROUP BY userid
ORDER BY total DESC[/sql]