Select public forums

query,sql

SELECT f.forum_id
FROM forums f
LEFT JOIN acl_groups ag ON ag.forum_id = f.forum_id
LEFT JOIN acl_options ao ON ag.auth_option_id = ao.auth_option_id
LEFT JOIN acl_roles_data ard ON ag.auth_role_id = ard.role_id
LEFT JOIN acl_options ao2 ON ard.auth_option_id = ao2.auth_option_id
WHERE ag.group_id = 2 AND ((ag.auth_option_id = 20 AND ag.auth_setting = 1) OR (ard.auth_option_id = 20 AND ard.auth_setting = 1))

Select public forums in a phpBB board