6

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?

2
  • this is absurd question, if the bounty has expired, then the bounty must have been awarded. – Lie Ryan Sep 11 '11 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 Sep 11 '11 at 4:39
7

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
AND NOT EXISTS (
    SELECT *
    FROM Posts, Votes
    WHERE Posts.ParentId = P.ID
    AND Votes.VoteTypeId = 9
);​
1
  • Thanks Michael I totally forgot about VoteTypeId I was playing with other stuff. – phwd Sep 11 '11 at 5:20

You must log in to answer this question.

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