Find Old abandoned Posts

0

Please login or register to vote for this query.

(click on this box to dismiss)

Super User

Q&A for computer enthusiasts and power users

-- Find Old abandoned Posts

select Id
from Posts 
where Posts.Score=0 AND Posts.ViewCount < 500 AND Posts.LastActivityDate < DATEADD(year,-1,GETDATE()) AND Posts.AnswerCount=0 AND Posts.ClosedDate IS NULL

Enter Parameters

Options:
Switch sites:
loading Hold tight while we fetch your results