Old unloved questions with comments that the OP did not see

0

Please login or register to vote for this query.

(click on this box to dismiss)

Questions with a last activity date over a year ago, score <= 0, low views, no answers, and comments that were posted after the last activity date of the OP

Stack Overflow

Q&A for programmers

-- 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.CommentCount, c.CreationDate, u.LastAccessDate, c.Text, DATEDIFF(day, p.CreationDate, GETUTCDATE()) as DaysOld
FROM Posts p
JOIN Comments c ON c.PostId = p.Id
JOIN Users u ON p.OwnerUserId = u.Id
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
DATEDIFF(day, p.CreationDate, GETUTCDATE()) > 365
AND c.CreationDate > u.LastAccessDate
ORDER BY p.Score, p.ViewCount

Enter Parameters

Options:
Switch sites:
loading Hold tight while we fetch your results
:records returned in :time ms:cached