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