How can i find the 1.000.000th post on my forum?

[PhoneiX]

Hello,

I had a contest on my forum but i couldn't find the winner. I want to find who has the owner of 1.000.000th post on my forum. Post id is greater than 1 million because of deleted posts.

I used this sql code but i get me wrong result.

SELECT * FROM post ORDER BY postid LIMIT 1000000 , 1

This code gets me a message that posted 12 days ago(ID is 1.063.664). But on my forumhome statistics, today i passed 1 million.

So, i'm confused, how can i solve this and give the winner's prize?

[Wayne Luke]

There is no way to determine what post it is exactly.