Open question roomba


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

Ask Ubuntu Meta

Q&A about the site for Ubuntu users and developers

-- 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

Switch to main site
loading Hold tight while we fetch your results