Qs, As, and Comments by [Deleted Author ID]

1

Please login or register to vote for this query.

(click on this box to dismiss)

Pulls the questions, answers, and comments authored by a deleted OP, pulled by userID. Sorted by recency, with more recent posts first.

Emacs

Q&A for those using, extending or developing Emacs

SELECT -- Questions
  CONCAT('site://q/', p.Id, '|Question') AS [Link],
  p.Title AS [Text],
  Score,
  Tags,
  p.CreationDate
FROM Posts p
WHERE p.PostTypeId = 1
  AND p.OwnerDisplayName = CONCAT('user', ##UserId:int?102937##)
ORDER BY CreationDate DESC

SELECT -- Answers
  CONCAT('site://a/', p.Id, '|Answer') AS [Link],
  p.Body AS [Text],
  Score,
  Tags,
  p.CreationDate
FROM Posts p
WHERE p.PostTypeId = 2
  AND p.OwnerDisplayName = CONCAT('user', ##UserId:int?102937##)
ORDER BY CreationDate DESC

SELECT -- Comments
  CONCAT('site://posts/comments/', c.Id, '|Comment')  AS [Link],
  c.Text,
  Score,
  c.CreationDate
FROM Comments c
WHERE c.UserDisplayName = CONCAT('user', ##UserId:int?102937##)
ORDER BY CreationDate DESC

Enter Parameters

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