0

Please login or register to vote for this query.

(click on this box to dismiss)

Questions asked over a year ago with score <= 0, no answers, low views proportional to age, one or less comments

Q&A about the site for biology researchers, academics, and students

-- 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()) > 30
ORDER BY p.Score, p.ViewCount

fork query

edited jun 24 12 jokerdino

created feb 7 11 Jeff.Atwood