All answers to the given question

1

Please login or register to vote for this query.

(click on this box to dismiss)

GIS

Q&A for cartographers, geographers and GIS professionals

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

Enter Parameters

Options:
Switch to meta site
loading Hold tight while we fetch your results