[imported_rom]

Originally Posted by Eikinskjaldi

Ahh, well in that case...

SELECT count(*) as 'total' FROM post p join thread t USING(threadid) where forumid in (2,5,10,12,15) and userid=whatever

or

SELECT count(*) as 'total' FROM post p join thread t USING(threadid) where forumid in (2,5,10,12,15) and username=whatever

Well we have 4K+ members so I wanted to get a list that tells me which members (by member name) qualify with 100 posts and how many total posts.

THANKS!!!!!!