Possible dupes

0

Please login or register to vote for this query.

(click on this box to dismiss)

Stack Overflow

Q&A for professional and enthusiast programmers

SELECT *
FROM Comments
  INNER JOIN Posts Question
    ON Comments.UserId = Question.OwnerUserId
  INNER JOIN PostTags
    ON Question.Id = PostTags.PostId
  INNER JOIN Tags
    ON PostTags.TagId = Tags.Id
  INNER JOIN Posts Answer
    ON Comments.PostId = Answer.Id
WHERE Tags.Id = 130 -- Looking only for 'story-ident'
  AND Question.AcceptedAnswerId <> Answer.Id -- answer not accepted

Enter Parameters

Options:
Switch sites:
loading Hold tight while we fetch your results