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

Italian Language Meta

Q&A about the site for students, teachers, and linguists wanting to discuss the finer points of the Italian language

-- 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 main site
loading Hold tight while we fetch your results