Q&A for Drupal developers and administrators
SELECT TOP 1000 Posts.Id AS [Post Link], Posts.Score, PostHistory.CreationDate AS [Roomba Deleted At] FROM PostHistory, Posts WHERE PostHistory.PostId = Posts.Id AND PostHistoryTypeId = 12 AND Comment LIKE 'Scheduled: %' ORDER BY Posts.Score DESC, Posts.Id DESC;