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, 
    Posts.ParentId as question_id, Comments.Text as comment_text, 
    Comments.CreationDate as comment_created_at, Posts.Score as answer_score, 
    Posts.CreationDate as answer_created_at
FROM Comments INNER JOIN Posts
ON Posts.PostTypeId = 2
AND Comments.PostId = Posts.Id
WHERE Comments.PostId IN (
  SELECT PostId FROM Comments
  GROUP BY PostId
  HAVING COUNT(*) >= 10) 
AND YEAR(Posts.CreationDate) = 2009
AND MONTH(Posts.CreationDate) > 6
ORDER BY Comments.PostId, Comments.CreationDate;

view current version

edited aug 18

created aug 2 jon.doe39602