Sql query to get all forums

[dabuki]

I need an sql query that will produce all the forums that are publicly readable (including unregistered users). Any idea what query can give me this list?

Where do you need to this? vBulletin has a forumcache that you could probably use. You'd have to do some processing to weed out the private forums.

[dabuki]

Well, there's a maintenance script I'm creating, that has to run on the publicly available forums only.