finds questions that have been inactive for at least 6 months
Q&A for professional and enthusiast programmers
select TOP 1000 Id as [Post Link], Score, LastActivityDate FROM Posts WHERE PostTypeId=1 AND OwnerUserId!=##UserID:int## AND LastActivityDate < DATEADD(mm, -6, GETDATE()) ORDER BY NEWID()