$result = dbquery("
SELECT tf.forum_id, tt.thread_id, tt.thread_subject, tt.thread_postcount
FROM ".DB_FORUMS." tf
INNER JOIN ".DB_THREADS." tt USING(forum_id)
WHERE ".groupaccess('tf.forum_access')." AND
tt.thread_postcount >= '".$min_posts."'".$timeframe." AND tt.thread_hidden='0' AND tf.forum_id='X'
ORDER BY thread_postcount DESC, thread_lastpost DESC LIMIT 5
");