Highest voted comments for a user

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.

Biology

Q&A for biology researchers, academics, and students

-- 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],
c.PostId as [Post Link]
FROM Comments c, PostTypes pt, Posts p
WHERE p.Id = c.PostId
AND pt.Id = p.PostTypeId
AND c.UserId = ##UserID:int##

ORDER BY c.Score DESC

Enter Parameters

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