User with highest *genuine* post count?

We hard deleted for years until such a point where the storage and software combination no longer demanded it.

I think it was common practice until '07, and even happened at points after that. If I had less than 30k by then I would be surprised.


Ah, in which case there will be no way to recover the real counts im afraid.

Also, that previous query probably wont work having just opened up a schema of the vb database, you would need to go:


SELECT count(post.postid) AS postcount, user.username
FROM post AS post
LEFT JOIN user AS user ON (user.userid = post.userid)
GROUP BY post.userid
ORDER BY postcount
DESC LIMIT 10;
 
We hard deleted for years until such a point where the storage and software combination no longer demanded it.

I think it was common practice until '07, and even happened at points after that. If I had less than 30k by then I would be surprised.

Aye, we used to delete posts over a certain age every month, it was frequently around 100-200k posts at a time deleted unless they were in the excluded areas (archives etc).
 
Back
Top Bottom