[@_ck_ Participant 14 years, 3 months ago]

I forgot to add the topic_id=12 and group by on my queries sorry.

Well the numbers are coming from post position.

But still something is very wrong, because bbpress is showing 81 as the post count.

You need to run the exact query that the recount function uses.

SELECT topic_id, COUNT(post_status) as topic_posts FROM bb_posts WHERE post_status=0 AND topic_id=12 GROUP BY topic_id

See if that gives 80 or 81