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?

[Guest190829]

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.