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 post_id, Comments.Text as text, 
    Comments.CreationDate as comment_created_at, Posts.Score as post_score, 
    Posts.ViewCount as post_views, Posts.CreationDate as post_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) = 2008
ORDER BY Comments.PostId

view current version

edited aug 17

created aug 2 jon.doe39602