1

Please login or register to vote for this query.

(click on this box to dismiss)

Shows the list of story-identification questions where the OP has posted an answer, but hasn't accepted their own answer. Note: this query will only work on the 'SFF' site. If you're not seeing results, then make sure you've chosen the correct site.

Q&A for professional and enthusiast programmers

SELECT Answer.Id AS [Post Link],
	Answer.OwnerUserId as [User Link]
FROM Posts Question
  INNER JOIN Posts Answer
    ON Question.Id = Answer.ParentId
  INNER JOIN PostTags
    ON Question.Id = PostTags.PostId
  INNER JOIN Tags
    ON PostTags.TagId = Tags.Id
WHERE Question.PostTypeId = 1
	AND Tags.Id = 130 -- Looking only for 'story-ident'
	AND Question.OwnerUserId = Answer.OwnerUserId -- Where answer was posted by the OP
	AND Question.AcceptedAnswerId <> Answer.Id -- OP hasn't accepted own answer

fork query

edited nov 9 17

created nov 7 17 Mooz