All answers to the given question

1

Please login or register to vote for this query.

(click on this box to dismiss)

Writing

Q&A for the craft of professional writing, including fiction, non-fiction, technical, scholarly, and commercial writing

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