Q&A for system and network administrators
select q.OwnerUserId as [User Link], q.Id as [Post Link], q.Score as 'Question Score', a.Id as [Post Link], a.Score as 'Answer Score', q.ViewCount as 'View Count' from ( (select Posts.* from (Posts join PostTypes on Posts.PostTypeId = PostTypes.Id) where PostTypes.Name = 'Question') as q join (select Posts.* from (Posts join PostTypes on Posts.PostTypeId = PostTypes.Id) where PostTypes.Name = 'Answer') as a on q.Id = a.ParentId) where q.OwnerUserId = a.OwnerUserId and q.CreationDate = a.CreationDate and q.OwnerUserId = ##UserId##; -- order by q.OwnerUserId asc;