Most Comments (upvoted at least once) on given tag by Users

0

Please login or register to vote for this query.

(click on this box to dismiss)

My comments with at least one upvote, in order with most upvoted-comments first.

Mythology Meta

Q&A about the site for enthusiasts and scholars of mythology and folklore

SELECT U.DisplayName AS Name, Count(*) AS NbComments
FROM 
    Comments AS C
INNER JOIN Users AS U ON U.Id = C.UserId
INNER JOIN Posts AS P ON P.Id = C.PostId
WHERE C.Score > 1
AND P.Tags LIKE '%<##tagName?git##>%'
GROUP BY U.DisplayName
--HAVING Count(*) > 100
ORDER BY NbComments DESC

Enter Parameters

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