0

Please login or register to vote for this query.

(click on this box to dismiss)

Questions with score 0 (or lower), one year old with less than 100 views and no answers

Q&A about the site for students, teachers, and linguists wanting to discuss the finer points of the Italian language

-- Old unloved zero-score questions possibly eligible for auto-deletion
-- Questions with score 0 (or lower), one year old with less than 100 views and no answers

SELECT TOP 1000 
p.Score, p.Id AS [Post Link], p.ViewCount, p.Tags, p.LastActivityDate 
FROM Posts p
WHERE 
p.PostTypeId = 1 AND 
p.ViewCount < 100 AND 
p.Score < 1 AND 
p.AnswerCount = 0 AND
p.LastActivityDate < (DateAdd(d, -365, GetDate()))
ORDER BY 
p.Score desc, 
p.ViewCount

fork query

created feb 5 11 Jeff.Atwood