I ran the query yesterday night to try to solve the issue as quickly as possible, since many Forum users complained about inconsistencies in the post count.
I tested, studied and refined the query to obtain the exact count of your posts.
I am using your user profile, Nick, to detail out exactly what I did.
The query results are:
member NICK, until Oct 20 2014, 08:59:24 GMT, wrote 19769 posts (source: member table)
member NICK, from Mon, Oct 20 2014, 08:59:24 GMT (last post), wrote 416 posts (Woa, thank you Nick you are a great moderator and the post count shows it :)
The query rules are:
Count all messages for member NICK, written after 20 Oct 2014 08:59:24 GMT, the message shows up in the counting tables, the message is posted in a valid board.
Total number of posts: 19769+416 = 20185.
From my end this issue has been solved, we will never touch the post counters again.
Moving forward we will make it clearer whenever we are going to make changes and improvements to user profiles data, announcing it on the Forum itself. Hopefully this will solve these misalignments in the communication we are experiencing these days. We are doing our best to accomodate and fix all the bugs in the shortest timeframe possible, thank you again for your contribution and patience!