Q&A for cartographers, geographers and GIS professionals
select Name "Post Type", p.PostTypeId type_id, p.Id post_id, p.ParentId parent_id, p.AcceptedAnswerId accepted_id, u.Id user_id, u.Id as [User Link], p.Id as [Post Link], p.CreationDate as created from Posts p join PostTypes pt on pt.Id = PostTypeId join Users u on u.Id = OwnerUserId where DisplayName = '##Name##' order by p.PostTypeId, p.ParentId, p.Id