0

Please login or register to vote for this query.

(click on this box to dismiss)

Gets the highest voted comments for a given user.

Q&A about the site for scholars and enthusiasts of literature

-- Comment Leaderboard
-- Gets the highest voted comments and their URLs on the site.

SELECT TOP 10
c.Score as [Comment Score],
pt.Name as [Commented On],
c.Text as [Comment],
u.DisplayName as [Comment By],
c.PostId as [Post Link]
FROM Comments c, PostTypes pt, Posts p, Users u
WHERE p.Id = c.PostId
AND pt.Id = p.PostTypeId
AND u.Id = c.UserId
ORDER BY c.Score DESC

view current version

edited dec 23 11

created dec 23 11 Alex Coplan