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 as [Post Link] 
from Posts 
where PostTypeId = 1 AND (Posts.AnswerCount=0 OR Posts.AnswerCount IS NULL) AND Posts.ClosedDate IS NULL AND Posts.LastActivityDate < DATEADD(year,-1,GETDATE()) AND Posts.ViewCount <500 AND Posts.Score=0

Enter Parameters

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