Find Old abandoned Posts


Please login or register to vote for this query.

(click on this box to dismiss)


Q&A for people who build and repair bicycles, people who train cycling, or commute on bicycles

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

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