0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for anime and manga fans

--SELECT TOP 10* FROM COMMENTS

SELECT TOP 10* FROM COMMENTS COMMENT
  INNER JOIN POSTS ANSWER 
  ON COMMENT.PostId = ANSWER.ID --AND ANSWER.POSTTYPEID = 2
  INNER JOIN (
  SELECT DISTINCT AcceptedAnswerId FROM POSTS WHERE AcceptedAnswerId IS NOT NULL 
  ) ACCEPTANSWER
  ON ANSWER.ID = ACCEPTANSWER.AcceptedAnswerId
  WHERE COMMENT.PostId = 11677861

fork query

edited mar 19 19

created jan 8 19 anonymous