Comments from Posts Created on YYYY and with >=10 comments

0

Please login or register to vote for this query.

(click on this box to dismiss)

Webmasters

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, 
    Users.DisplayName as username, Comments.UserId as user_id, 
    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
  LEFT OUTER JOIN Users
    ON Comments.UserId = Users.Id
WHERE 
  Answers.CommentCount >= 10 
    ANd Questions.ViewCount >= 1000
    AND YEAR(Answers.CreationDate) = 2022
ORDER BY 
  Comments.PostId, Comments.CreationDate;

Enter Parameters

Options:
Switch to meta site
loading Hold tight while we fetch your results