Most popular commenters

0

Please login or register to vote for this query.

(click on this box to dismiss)

Users ranked by total sum comment score.

Christianity

Q&A for committed Christians, experts in Christianity and those interested in learning more

-- Most popular commenters
-- Users ranked by total sum comment score.

SELECT TOP 500
  UserId AS [User Link],
  sum(Score) As TotalScore,
  Users.Reputation as Rep,
  ROUND(cast(sum(Score) AS FLOAT)/Users.Reputation, 2) as CommentRepRatio
FROM
  Comments
INNER JOIN
  Users ON Users.Id = UserId
WHERE
  UserId > 0
GROUP BY
  UserId, Users.Reputation
ORDER BY 
  TotalScore DESC

Enter Parameters

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