Top Comments By UserName

1

Please login or register to vote for this query.

(click on this box to dismiss)

Enter a user's display name. Since display names are not always unique, the UserId is shown.

Science Fiction and Fantasy

Q&A for science fiction and fantasy enthusiasts

select top 100
  Comments.Score,
  Comments.CreationDate,
  --Comments.Text,
  Comments.Id As [Comment Link],
  Comments.UserId

from Comments
inner join Users on Users.Id = Comments.UserId

where Users.DisplayName = ##UserName:string##
AND Comments.Score > 0

order by Comments.Score desc

Enter Parameters

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