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)

Q&A about the site for students, teachers, and linguists wanting to discuss the finer points of the Italian language

-- 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

fork query

created mar 8 11 mmyers