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 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 Comments.PostId = Posts.Id
WHERE Comments.PostId IN (
  SELECT PostId FROM Comments
  GROUP BY PostId
  HAVING COUNT(*) >= 5) 
AND YEAR(Posts.CreationDate) = 2008
ORDER BY Comments.PostId

Enter Parameters

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