XF 2.2 Post counts don't match

[ForumExplorer]

So I ran an import from another Xenforo database and deleted some nodes from that one and now post counts don't match. For example it shows someone as having 41 posts when they only actually have 8.

 

[Jay™]

Have you rebuilt your threads and post counters?

​

 

[ForumExplorer]

Have you rebuilt your threads and post counters?

​

Done all the rebuilds and cron jobs.

 

[ForumExplorer]

Fixed it.
I found this: https://xenforo.com/community/resources/rebuild-user-post-counts-query.8620/