your communities

When I run the following query on the Stack Exchange Data Explorer the first record is empty - it's like a blank name. Can someone please explain how the top bounty answerer is nothing?

SELECT Top 139
       OwnerUserId As [User Link], 
       COUNT(*)    As BountiesWon
FROM 
    Votes v
    INNER JOIN Posts p ON v.PostId = p.Id
WHERE
  VoteTypeId=9
GROUP BY
  p.OwnerUserId
ORDER BY
  BountiesWon DESC

enter image description here

share|improve this question
add comment

1 Answer

up vote 5 down vote accepted

Reasons:

Here are the reasons why the owner user id is displayed as blank:

  • Bounties expired on those posts and no one was awarded the bounty.
  • Bounty was awarded to a post without an owner (such as one by a since-deleted user)

Thanks to @TimStone for the second point.

Example:

For example, take a look at this question and the comment under that question. However, the bounty was not awarded to any of the answers.

Jython Development on Google App Engine

Comment states the following:

Added bounty on 24 Jan 2011. If someone has newer info on Jython, 
examples in use on appengine,source code, tutorials etc. 
please post – abel Jan 24 '11 at 9:58
share|improve this answer
2  
Yep. The other scenario is that the bounty was awarded to a post without an owner (such as one by a since-deleted user) –  Tim Stone Feb 19 '13 at 1:55
add comment

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .