[ganzua]

Superb post!

I followed your guide and a have a last 10 posts query working in my worldwide famous 404 page.

Regarding your last code, if you are quering bbpress database, don’t you want a global $BBdb; instead of global $wpdb; and a $results=$BBdb instead of $results=$wpdb ?

BTW, how do you query all ‘views’ fields that bb topic views plugin adds to bb_meta table? If we sum up the value stored in all those field we have a hit counter.