This StackExchange query attempts to get the first 10 unanswered bounty questions:

SELECT TOP 10 Posts.AnswerCount, Posts.AcceptedAnswerId, Posts.Id AS [Post Link]
FROM Posts
    JOIN Votes ON Votes.PostId = Posts.Id
      and Posts.PostTypeId = 1 -- questions
      and Votes.BountyAmount > 0
      and Posts.AnswerCount = 0
      and Posts.AcceptedAnswerId IS NULL
ORDER BY Posts.CreationDate DESC

...but it returns a list of questions that already have accepted answers:

enter image description here

I would've expected AnswerCount and AcceptedAnswerId to be nonzero for those answered questions. Why are these posts showing up in my results? (I think it's a bug, but maybe my query is wrong.)

  • Didn't find that dupe yesterday somehow, sorry about that. Commented Jun 16, 2016 at 17:46

1 Answer 1


There is no bug and nothing is wrong with the query.

SEDE is not using live data. As written in its help page:

The data is updated early every Sunday morning around 3:00 UTC

And SEDE homepage itself contains:

So answers accepted after the last update occured, won't show up.

That said, SEDE isn't ideal for dealing with those things. You better use the built in search, which got advanced search operators. This search appears to return what you want, and using the following:

  • hasnotice:1 to bring only questions with a notice - this add some noise, but quite minor.
  • hasaccepted:0 to omit questions with accepted answer.
  • answers:0 to bring back only questions without any answers.
  • 1
    Thanks for the helpful answer and search tip (which I'll definitely use going forward).
    – tony19
    Commented Jun 15, 2016 at 7:30

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