Q&A for people looking to improve their interpersonal communication skills
SELECT PostsWithDeleted.Id, PostTypes.Name, PostsWithDeleted.CreationDate, PostsWithDeleted.DeletionDate, PostsWithDeleted.Score, 'site://q/'+cast(PostsWithDeleted.Id as varchar) FROM PostsWithDeleted JOIN PostTypes on PostTypes.Id = PostsWithDeleted.PostTypeId WHERE PostsWithDeleted.DeletionDate IS NOT NULL ORDER BY PostsWithDeleted.Score