instruction: ROOMBA > year old questions that have active close votes. http://meta.stackexchange.com/questions/78048/enable-automatic-deletion-of-old-unanswered-zero-score-questions-after-a-year/92006#92006 No need to vote to close these as 1 downvote should delete them anytime within the next 7 days.
response: SELECT q.Id AS "post_link", COUNT(pf.FlagTypeId) AS CVs, q.ViewCount FROM Posts AS q INNER JOIN Users AS u ON u.Id = q.OwnerUserId INNER JOIN PostHistory AS ph ON ph.Id = q.Id INNER JOIN PendingFlags AS pf ON pf.PostId = q.Id WHERE q.PostTypeId = 1 AND DATEDIFF(DAY, q.CreationDate, GETDATE()) > 365 AND q.Score = 0 AND q.AnswerCount = 0 AND ph.PostHistoryTypeId != 14 AND q.ViewCount < DATEDIFF(DAY, q.CreationDate, GETDATE()) * 1.4 AND q.CommentCount > 1 AND q.ClosedDate IS NULL AND pf.FlagTypeId = 14 AND LEN(q.Body) < '##questionLength?500##' AND DATEDIFF(DAY, u.LastAccessDate, GETDATE()) > 1 AND u.Reputation < '##questionerRep?500##' GROUP BY q.Id, q.ViewCount ORDER BY COUNT(pf.FlagTypeId) DESC