Meta Stack Exchange is where users like you discuss bugs, features, and support issues that affect the software powering all 157 Stack Exchange communities.

What is meta?
Here's how it works:
  1. Any Stack Exchange user can ask a question
  2. The community provides support, votes on ideas, and reports bugs
  3. Your voice helps shape the way Stack Exchange operates

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?

share|improve this question
    
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
up vote 6 down vote accepted

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
);​
share|improve this answer
    
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 .