[Eikinskjaldi]

Originally Posted by imported_rom

I apologize.

One installation of vB, multiple forums (sorry I said boards). No multiple logins per member.

We are a sports community and want to have a poll. But to vote in the poll, members must have over 100 posts on forums where the forum id is in (2,5,10,12,15).

Thanks!

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