How long until I get the pundit badge?

19

Please login or register to vote for this query.

(click on this box to dismiss)

List comments in order of score

Motor Vehicle Maintenance and Repair Meta

Q&A about the site for mechanics and DIY enthusiast owners of cars, trucks, and motorcycles

-- How long until I get the pundit badge?
-- List comments in order of score

DECLARE @UserId int = ##UserId##

SELECT TOP 20 
    Posts.Title, Comments.Text, Comments.Score, Posts.Id, Posts.ParentId
FROM Comments
     INNER JOIN Posts ON Comments.PostId = Posts.Id
WHERE 
    UserId = @UserId
ORDER BY Score DESC

Enter Parameters

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