The roomba for these questions runs on Saturdays. Depending on the post score and whether the poster's account has been deleted, these questions could be eligible for the roomba after either 30 or 365 days. See http://stackoverflow.com/help/roomba
Q&A for ebook publishers and readers
-- Schema documentation: http://meta.stackexchange.com/a/2678/178179 select top (##TopN:int?400##) Posts.Id as [Post Link], Score, ViewCount as Views, Posts.CreationDate, Posts.CommentCount as Comments, (case when Users.Id is not null then 'site://users/' + cast(Users.Id as nvarchar) + '|' else '' end) + coalesce(Users.DisplayName, Posts.OwnerDisplayName) as [User Link], Posts.ClosedDate, Users.LastAccessDate from Posts left join Users on Users.Id = Posts.OwnerUserId where --Posts.ClosedDate is null and (-- 365-day rule (RemoveAbandondedQuestions) (##YearRule:int?1## = 1 and (Posts.Score <= ##MaxPostScore:int?1## or (Posts.Score <= ##MaxPostScore##+1 and Posts.OwnerUserId is null) ) -- has view count <= the age of the question in days times 1.5 and Posts.ViewCount <= datediff(day, Posts.CreationDate, getdate())*1.5 -- has 1 or 0 comments and Posts.CommentCount < 2 ) -- 30-day rule (RemoveDeadQuestions) or (##MonthRule:int?1## = 1 and Posts.Score <= ##MaxPostScore##-1) ) -- has no answers and Posts.AnswerCount = 0 -- post is not locked and coalesce((select top 1 PostHistoryTypeId from PostHistory where PostHistory.PostId = Posts.Id and PostHistory.PostHistoryTypeId in (14, 15) -- post locked,unlocked order by Id desc), 0) <> 14 -- post is old and datediff(day, cast(##CutoffDate:string?2016-01-01## as datetime), Posts.CreationDate) < 0 and Posts.Tags like '%' + ##Tags:string?%## + '%' and (Users.LastAccessDate is null or datediff(day, cast(##LastUserAccess:string?2015-01-01## as datetime), Users.LastAccessDate) < 0) order by case when Users.Id is null then 0 else 1 end, Posts.Score desc, Posts.CreationDate asc