Q&A for scientists using computers to solve scientific problems
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