Old unloved questions possibly eligible for auto-deletion

0

Please login or register to vote for this query.

(click on this box to dismiss)

Questions with score <= 0, low views, no answers

Literature Meta

Q&A about the site for scholars and enthusiasts of literature

-- Old unloved questions possibly eligible for auto-deletion
-- Questions with score <= 0, low views, no answers

SELECT TOP 1000 
p.Score, p.Id AS [Post Link], p.ViewCount, p.Tags, Year(p.LastActivityDate) as [Year], Month(p.LastActivityDate) as [Month]
FROM Posts p
WHERE 
p.PostTypeId = 1 AND 
p.ViewCount < 75 AND 
p.Score < 1 AND 
(p.AnswerCount < 1 OR p.AnswerCount = null) AND
p.LastActivityDate < (DateAdd(d, -165, GetDate()))
ORDER BY p.Score, p.ViewCount, 
Year(p.LastActivityDate), 
Month(p.LastActivityDate)

Enter Parameters

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