I focused on the order of comments in SO, but I can't figure out a specific rule. If you look carefully, you see a interesting order for comments. The order depends on both comment's votes and comment's ids. Now I want to know, what is that combination? Does anybody know?
Maybe it is something like this:
ORDER BY (timestamp)+(total_vote*100)
Columns:
timestamp
: Stores the time which comment has been entered.total_vote
: Stores the number of total votes for each comment.