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