I would like to search for questions that had bounties, but no bounty was awarded. Is this possible by data.stackexchange.com queries or the sorts?

  • this is absurd question, if the bounty has expired, then the bounty must have been awarded.
    – Lie Ryan
    Commented Sep 11, 2011 at 4:28
  • 2
    @Lie meta.stackexchange.com/questions/16065/… "If no answers meet these criteria, the bounty ends without it being awarded to any answer, and is not refunded to the bounty starter."
    – phwd
    Commented Sep 11, 2011 at 4:39

1 Answer 1


I think this query works:

SELECT P.Id AS [Post Link]
FROM Posts AS P, Votes AS V
WHERE P.Id = V.PostId
AND V.VoteTypeId = 8
    SELECT *
    FROM Posts, Votes
    WHERE Posts.ParentId = P.ID
    AND Votes.VoteTypeId = 9
  • Thanks Michael I totally forgot about VoteTypeId I was playing with other stuff.
    – phwd
    Commented Sep 11, 2011 at 5:20

You must log in to answer this question.

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