1

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A about the site for artists and crafters

/*

RESULTS:

RemoveDeadQuestions:
 - After 30 days, no answers, not locked, no migration in history
   (if it has migration history, then different rules)
 - Sundays, about at 03:00
 
RemoveAbandonedClosed:
 - After 9 days, not locked, no >0 answers, no accepted answer
     no pending reopen votes, not edited in the last 9 days,
     not migrated, score 0 or less
 - Probably every day, about at 03:00
 
RemoveAbandonedQuestions:
 - After 365 days, unlocked, unanswered, visit/day < 1.5
 - Sundays, about at 03:00
*/

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'
  --PostHistory.Comment = 'Scheduled: RemoveAbandonedQuestions'
ORDER BY PostHistory.Id DESC;

fork query

edited jan 25

created jan 15 peterh - PLEASE DELETE THIS ACCOUNT