Top 1000 scored posts once deleted by the Roomba

0

Please login or register to vote for this query.

(click on this box to dismiss)

Arts and Crafts Meta

Q&A about the site for artists and crafters

SELECT TOP 1000
  Posts.Id AS [Post Link],
  Posts.Score,
  PostHistory.CreationDate AS [Roomba Deleted At],
  (select count(*) from votes where votes.postid = postid and votetypeid = 2)  [upvotes],
  (select count(*) from votes where votes.postid = postid and votetypeid = 3)  [downvotes]
  
FROM PostHistory, Posts
WHERE
  PostHistory.PostId = Posts.Id
  AND
  PostHistoryTypeId = 12
  AND
  Comment LIKE 'Scheduled: %'
ORDER BY Posts.Score DESC, Posts.Id DESC;

Enter Parameters

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