Most popular replies to my comments

0

Please login or register to vote for this query.

(click on this box to dismiss)

Shows the highest-scoring comments to include "@yourname". Of course, people can reply to you with only part of your username, and your username can change, and other users can have the same name as you, so it's not 100% accurate.

Server Fault

Q&A for system administrators and IT professionals

-- Most popular replies to my comments
-- Shows the highest-scoring comments to include "@yourname". Of course, people
-- can reply to you with only part of your username, and your username can change,
-- and other users can have the same name as you, so it's not 100% accurate.


SELECT TOP 100 Comments.PostId AS [Post Link], Users.DisplayName, Comments.Score, Comments.Text, Comments.CreationDate
FROM Comments
LEFT JOIN Users on Comments.UserID = Users.ID
WHERE Comments.Text LIKE '%@##UserName##%'
ORDER BY Comments.score DESC

Enter Parameters

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