Comments with 100+ votes

0

Please login or register to vote for this query.

(click on this box to dismiss)

Ordered by question viewcount (most 100+ comments are on reddited questions, which makes the few sub-10k-view ones all the more impressive)

Stack Overflow

Q&A for professional and enthusiast programmers

-- Comments with 100+ votes
-- Ordered by question viewcount (most 100+ comments are on reddited questions,
-- which makes the few sub-10k-view ones all the more impressive)

SELECT 
    Comments.PostId As [Post Link],
    Comments.Score,
    Question.ViewCount,
    Comments.Text,
    Comments.UserId As [User Link]
FROM 
    Comments
INNER JOIN
    Posts Answer
ON
    Comments.PostId = Answer.Id
INNER JOIN
    Posts Question
ON
    Answer.ParentId = Question.Id
WHERE 
    Comments.Score >= 100
ORDER BY
    Question.ViewCount, Comments.Score desc

Enter Parameters

Options:
Switch sites:
loading Hold tight while we fetch your results