Open question roomba

3

Please login or register to vote for this query.

(click on this box to dismiss)

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

Stack Overflow

Q&A for professional and enthusiast programmers

-- If the question is more than 365 days old, and ...
select Posts.CreationDate, Posts.OwnerUserId, Users.DisplayName, ViewCount, 
  Posts.Id as [Post Link], Tags
from Posts, Users
where Users.Id = Posts.OwnerUserId 
  and Posts.PostTypeId = 1 -- question
  and Posts.Score <= 0 
  and Posts.AnswerCount = 0
  and Posts.CommentCount < 2  
  and DATEDIFF(DAY, Posts.CreationDate, GETDATE()) > (365 - ##WillBedeletedInXDays?10##)
order by Posts.CreationDate asc

Enter Parameters

Options:
Switch to meta site
loading Hold tight while we fetch your results