Find Old abandoned Posts

0

Please login or register to vote for this query.

(click on this box to dismiss)

Artificial Intelligence

Q&A for people interested in conceptual questions about life and challenges in a world where "cognitive" functions can be mimicked in purely digital environment

-- 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 or Posts.AnswerCount IS NULL) AND Posts.ClosedDate IS NULL

Enter Parameters

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