Questions with a last activity date over a year ago, score <= 0, low views, no comments, no answers
Q&A about the site for members of the workforce navigating the professional setting
-- Old unloved questions possibly eligible for auto-deletion -- Questions with a last activity date over a year ago, score <= 0, low views, no comments, no answers SELECT TOP 20000 p.Score, p.Id AS [Post Link], p.ViewCount, p.Tags, DATEDIFF(day, p.CreationDate, GETUTCDATE()) as DaysOld FROM Posts p WHERE p.PostTypeId = 1 AND p.ViewCount < DATEDIFF(day, p.CreationDate, GETUTCDATE()) * 1.5 AND p.Score < 1 AND --ISNULL(p.AnswerCount,0) = 0 AND ISNULL(p.CommentCount,0) <= 1 AND --DATEDIFF(day, p.CreationDate, GETUTCDATE()) > 365 AND p.OwnerUserId = 87698 ORDER BY p.Score, p.ViewCount