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.

Q&A about the site for people studying math at any level and professionals in related fields

-- 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

fork query

created jun 14 10 Kip