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, 
    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.Tags as tags, 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) = 2020
    AND (Questions.Tags LIKE '%<python>%'
      OR Questions.Tags LIKE '%<javascript>%'
      OR Questions.Tags LIKE '%<reactjs>%')
ORDER BY 
  Comments.PostId, Comments.CreationDate;

view current version

edited oct 14 22

created aug 2 22 jon.doe39602