Comments by deleted user

1

Please login or register to vote for this query.

(click on this box to dismiss)

Super User

Q&A for computer enthusiasts and power users

select
  Comment.Id as [Comment Link],
  Comment.Score as [Score],
  Comment.CreationDate as [CreationDate],
  PostType.Name as [Post Type],
  coalesce(PostOwner.DisplayName, Post.OwnerDisplayName) as [Owner],
  coalesce(Post.Tags, Parent.Tags) as [Tags]
from Comments as Comment
  left join Posts as Post on Post.Id = Comment.PostId
  left join Posts as Parent on Parent.Id = Post.ParentId
  left join PostTypes as PostType on PostType.Id = Post.PostTypeId
  left join Users as PostOwner on PostOwner.Id = Post.OwnerUserId
where Comment.UserDisplayName = ##UserName:string##
order by Comment.Id ASC

Enter Parameters

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