Recently undeleted answers by a specific user - only undeletions by community

1

Please login or register to vote for this query.

(click on this box to dismiss)

Anime and Manga Meta

Q&A about the site for anime and manga fans

SELECT
  p.Id AS [Post Link], p.Score, ph.CreationDate,
  'site://posts/' + CAST(p.Id AS varchar)+'/revisions' AS [Revision History], 
  ph.UserId AS [User Link]
FROM PostHistory ph INNER JOIN Posts p ON ph.PostId=p.Id
WHERE (ph.PostHistoryTypeId=13) AND (p.PostTypeId=2) 
  AND (p.OwnerUserId=##userid##) AND (ph.UserId=-1)
ORDER BY ph.CreationDate DESC
---12 = Post Deleted - post voted to be removed
---13 = Post Undeleted - post voted to be restored

Enter Parameters

Options:
Switch sites:
loading Hold tight while we fetch your results