bbPress.org

I think, for the front page, where all topics are shown, you should put this:

<?php

$limit = bb_get_option('page_topics');

$offset = ($page-1)*$limit;

$all_topics = $bbdb->get_results("SELECT * FROM $bbdb->topics WHERE topic_status = 0 AND topic_sticky = 0 ORDER BY topic_id DESC LIMIT $limit OFFSET $offset");

$all_topic_posts = get_thread( $topic->topic_id);

$topics = $all_topics;

?>

Haven’t tested it, but should work.