0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for pro webmasters

SELECT Comments.Id as comment_id, Comments.PostId as answer_id, 
    Answers.ParentId as question_id, Comments.Text as comment_text, 
    Comments.Score as comment_score, Comments.CreationDate as comment_created_at, 
    Answers.Score as answer_score, Answers.CreationDate as answer_created_at, 
    Questions.Score as question_score, Questions.ViewCount as question_views, 
    Questions.CreationDate as question_created_at
FROM Comments INNER JOIN Posts Answers 
ON Answers.PostTypeId = 2
AND Comments.PostId = Answers.Id
INNER JOIN Posts Questions
ON Answers.ParentId = Questions.Id
WHERE Comments.PostId IN (
  SELECT PostId FROM Comments
  GROUP BY PostId
  HAVING COUNT(*) >= 10)
AND Questions.ViewCount > 1000
AND YEAR(Answers.CreationDate) = 2022
ORDER BY Comments.PostId, Comments.CreationDate;

view current version

edited aug 19

created aug 2 jon.doe39602