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

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

1 Answer 1

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 .