Unpopular Meta posts that were deleted and then undeleted

0

Please login or register to vote for this query.

(click on this box to dismiss)

Meta Stack Overflow

Q&A about the site for professional and enthusiast programmers

SELECT DISTINCT CONCAT('http://meta.stackoverflow.com/a/', Posts.Id)
FROM Posts
JOIN PostTypes
  ON Posts.PostTypeId = PostTypes.Id
JOIN PostHistory
  ON Posts.Id = PostHistory.PostId
JOIN PostHistoryTypes
  ON PostHistory.PostHistoryTypeId = PostHistoryTypes.Id
WHERE PostTypes.Name = 'Answer'
  AND PostHistoryTypes.Name = 'Post Undeleted'
  AND PostHistory.UserId <> Posts.OwnerUserId
  AND Posts.Score <= -8

Enter Parameters

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