SELECT f.forum_id, COUNT(t.topic_id) AS topics FROM phpbb_topics t LEFT JOIN phpbb_forums f ON t.forum_id = f.forum_id LEFT JOIN phpbb_posts p ON p.post_id = t.topic_last_post_id WHERE f.auth_view = 0 AND f.auth_read = 0 AND f.password = '' AND (f.forum_link = '' OR forum_link IS NULL) AND IF(f.forum_moderate, p.post_approve, 1) GROUP BY f.forum_id ORDER BY f.forum_order