finds questions that have been inactive for at least 6 months
Q&A about the site for Drupal developers and administrators
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()