1

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A about the site for music historians, critics, and fans

SELECT
  Id AS [Post Link],
---[Post Link] does not work for the deleted questions
  url = 'site://q/' + CAST(Id AS varchar),
  DeletionDate, CreationDate, Score,
  OwnerUserId AS [User Link], 
  OwnerDisplayName
--- OwnerUserId is not kept in the database for deleted questions.
FROM PostsWithDeleted
WHERE (ParentId=##questionid##) and (PostTypeId = 2)
ORDER BY DeletionDate DESC

fork query

edited sep 14 23

created sep 14 23 Martin20528