With great power comes great responsibility. See http://stackoverflow.com/help/roomba. The check for reopen votes is usually too conservative, but votes should expire after 14 days at the most. This query excludes questions that are duplicate targets, even though the roomba would be willing to delete them.
Q&A for scientific skepticism
--MaxQScore: Max Question Score declare @qscore INT = ##MaxQScore:INT?1## --MaxAScore: Max Answer Score declare @ascore INT = ##MaxAScore:INT?1## select distinct top ##Top:int?150## p.Id as [Post Link], p.Score, p.CreationDate, p.ViewCount, crt.Name as [Close Type] from posts p left join PostHistory ph on ph.postid = p.id left join CloseReasonTypes crt on ph.Comment = crt.Id left join Votes v on (v.PostId = p.Id and v.VoteTypeId = '10') --inner join PostHistoryTypes phn on phn.Id = ph.PostHistoryTypeId inner join Posts a on p.Id = a.ParentId where ph.comment != 1 and ph.comment != 101 and ph.posthistorytypeid = 10 and p.acceptedanswerid is null and p.closeddate is not null --and p.tags like '%' + ##TagsContain:string?%%## + '%' --and p.tags not like '%' + ##TagsDoNotContain:string?xyzzy## + '%' --and p.viewcount < ##ViewCount:int?20000## and datediff(d, p.closeddate, getdate()) >= 9 --and p.score >= ##MinScore:int?-10## and p.score <= @qscore group by p.id, p.score, p.CreationDate, p.viewcount, crt.Name having count(v.votetypeid) = 0 and max(a.score) <= @ascore order by p.score asc, p.viewcount asc, CreationDate