What is meta? ×
Meta Stack Exchange is where users like you discuss bugs, features, and support issues that affect the software powering all 130 Stack Exchange communities.

I was playing with StackQL and asked myself. Are there people who have as much rep as their highest voted question/answer (as in, they've only gotten rep from that one question/answer).

The query isn't that complicated but you have to filter out the people who have answered one question, gotten 1 upvote and have 10 rep. Since thats no fun. So I limited it to >= 100 rep.

SELECT Posts.Id, Posts.Score, Users.Id, Users.Reputation FROM Posts
LEFT JOIN Users ON Users.Id = Posts.OwnerUserId 
WHERE (Posts.Score * 10) = Users.Reputation AND Users.Reputation >= 100 
ORDER BY Users.Reputation DESC

These are the questions / answers.

The questions are often interesting but generic but it's the answers that intrigue me. For example the top one. That user has not done anything but voted a few times and answered that one answer.

The fluke one might be because of CW not being enabled at the start of his answers. He has two, both CW answers.

The third answer is similar to the first one, although he has answered two questions but the other answer has 0 votes.

Even though the list isn't that exciting, it's still a bit interesting.

UPDATE:

I did a query with +100. I was worried that there would be to many cases where people had gotten upvotes from other places.

SELECT Posts.Id, Posts.Score, Users.Id, Users.Reputation FROM Posts
LEFT JOIN Users ON Users.Id = Posts.OwnerUserId
WHERE (Posts.Score * 10) + 100 = Users.Reputation AND Users.Reputation >= 200
ORDER BY Users.Reputation DESC

I did >= 200 because otherwise I got pages and pages of results. This is the breakdown of the query.

So account association has no effect here, we just get bad results.

UPDATE 2

Looks like I had forgotten the initial 1 rep. So I have fixed the query (I'll leave the original stuff intact) But what happened to the starting 1 rep is a good question.

So here is the same list but with a fixed query.

SELECT Posts.Id, Posts.Score, Users.Id, Users.Reputation FROM Posts
LEFT JOIN Users ON Users.Id = Posts.OwnerUserId
WHERE (Posts.Score * 10) + 1 = Users.Reputation AND Users.Reputation >= 300
ORDER BY Users.Reputation DESC

I limited this one to >= 300 since the list was pretty long.

share|improve this question
    
Don't forget to adjust for the +100 bonus for associating accounts. –  Ether Oct 19 '09 at 21:06
    
How would I proceed in doing that? Since association isn't in the datadump and I can't do +100 since people could have gotten 10 upvotes somewhere else. –  Ólafur Waage Oct 19 '09 at 21:08
    
perhaps instead of where (Posts.Score * 10) = Users.Reputation, OR that with (Posts.Score * 10) + 100 = Users.Reputation? It seems odd that the +100 isn't in the DB anywhere: does this mean it would disappear with a rep recalc? –  Ether Oct 19 '09 at 21:12
1  
What's happened to the initial reputation of 1 in all of this? –  Jon Skeet Oct 19 '09 at 21:19
    
Hmm good question. I'll run the query with rep +1. See if i get anything more. –  Ólafur Waage Oct 19 '09 at 21:28
1  
Interestingly, Scott Stanchfield also has a registered account with 2.4k rep (stackoverflow.com/users/12541/scott-stanchfield). Those accounts really should be merged. –  mmyers Oct 19 '09 at 21:46
    
As (nameless) others would say "What's the question?". But seriously, this is interesting stuff. I can't help wondering what happened to stackoverflow.com/users/63787/ruiyiz though. He/she joined 8 months ago, had brilliant success with the first answer, but hasn't been seen since August 27. –  pavium Oct 20 '09 at 0:26
    
@pavium maybe you can ask him: twitter.com/ruiyiz since his webpage doesn't offer much info other than his name (Ruiyi Zhang). He seems to also use linkedIn: linkedin.com/pub/dir/Ruiyi/Zhang –  Cawas Mar 26 '10 at 19:03

You must log in to answer this question.

Browse other questions tagged .