Query for public threads


Active member
Is there an easy way to query for recent threads which are publicly viewable (aka, posted in a forum on which the guest user-group has access). All the solutions I've seen so far query for all recent posts, then prune out threads for which you do not have access.

I'm really trying my best to avoid specifying which specific forums are included in the query -- I'd love some sql magic that merges with the permissions table instead. I just don't know enough about the permission system to know if it's possible.

Update -- looks like it'll be pretty difficult to do in one query, because you can't really iterate up the node tree looking for permissions effectively.