0

Please login or register to vote for this query.

(click on this box to dismiss)

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

fork query

edited feb 19 18

created feb 19 18 E.P.