1

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for those using, extending or developing Emacs

SELECT TOP 1000
  Posts.Id AS [Post Link],
  Posts.Score,
  PostHistory.CreationDate AS [Roomba Deleted At],
  PostHistory.Comment
FROM PostHistory, Posts
WHERE
  PostHistory.PostId = Posts.Id
  AND
  PostHistoryTypeId = 12
  AND
  --PostHistory.Comment LIKE 'Scheduled: %'
  --PostHistory.Comment = 'Scheduled: RemoveDeadQuestions'
  PostHistory.Comment = 'Scheduled: RemoveAbandonedClosed'
ORDER BY Posts.Score DESC, Posts.Id DESC;

view current version

edited jan 15 21

created jan 15 21 peterh (2)