0

This question already has an answer here:

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.)

marked as duplicate by Shadow The Dragon Wizard support Jun 16 '16 at 17:45

This question has been asked before and already has an answer. If those answers do not fully address your question, please ask a new question.

4

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 Jun 15 '16 at 7:30

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