XF 2.1 Query to rebuild the global/total postcount

[ssj2_ssbm]

Hi,
someone accidentally soft-deleted a large thread. I can't restore it using the inline moderation because the whole site crashes when I do. We changed the state in the database from deleted to visible, but the global counter is still messed up.

This is the thread that was soft deleted


and this is our statistics widget


according to the database we should have near to 485k posts in total

Can someone give me a query that rebuilds the global counter?

 

[021]

.admin.php?cron/ Rebuild forum statistics

 

[ssj2_ssbm]

.admin.php?cron/ Rebuild forum statistics

I've ran that cron multiple times but the globals counter did not change at all.