1

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for people seeking specific software recommendations

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

view current version

edited mar 29 15

created mar 29 15 Franck Dernoncourt