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

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 as [User Link], ViewCount, 
  Posts.Id as [Post Link], Tags
from Posts, Users

  -- joining tables
  Users.Id = Posts.OwnerUserId 
  -- satisfying conditions
  and Posts.PostTypeId = 1 -- is a question
  and Posts.Score <= ##MaxPostScore:int?1##
  and Posts.AnswerCount = 0 -- has no answers
  and Posts.CommentCount < 2  -- has 1 or 0 comments
  and Posts.ViewCount <= DATEDIFF(DAY, Posts.CreationDate, GETDATE()) * 1.5 -- has view count <= the age of the question in days times 1.5
  and DATEDIFF(DAY, Posts.CreationDate, GETDATE()) > (365 - ##WillBedeletedInXDays?10##) -- is old
  and Tags not like '%<' + ##ExcludedTag:string## + '>%'
  -- post is not locked
  and not exists (
        select PostHistory.Id from PostHistory 
        where PostHistory.PostId = Posts.Id
        and PostHistory.PostHistoryTypeId = 14 -- post is locked
order by Posts.CreationDate asc

Schema documentation:   

Enter Parameters

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