most_popular_posts
SELECT t.title, t.body, t.topic_id, t.thread_total, t.thread_views, t.author_id,
t.last_post_author_id, t.forum_id, f.forum_status, f.forum_permissions, m.screen_name, m2.screen_name as last_poster, f.forum_name
FROM exp_forum_topics t, exp_forums f, exp_members m, exp_members m2
WHERE t.forum_id = f.forum_id AND t.author_id = m.member_id
AND t.last_post_author_id = m2.member_id
AND f.forum_is_cat = 'n'
AND t.status != 'c'
AND t.board_id = 1
ORDER BY thread_total
DESC LIMIT 30
