[@_ck_ Participant 15 years, 8 months ago]

Thinking out loud here, don’t do anything yet on your own.

This is Sam’s new routine in 1.0.2 based on my alternate recount for bbpress 0.9

$sql = “INSERT INTO $bbdb->topics (topic_id, topic_posts)

(SELECT topic_id, COUNT(post_status) as topic_posts

FROM $bbdb->posts

WHERE post_status = ‘0’ GROUP BY topic_id)

ON DUPLICATE KEY UPDATE topic_posts = VALUES(topic_posts);

“;

I will investigate further…