Old, seriously unloved questions

0

Please login or register to vote for this query.

(click on this box to dismiss)

Questions with no upvotes, low views (less than 5 views-per-month), no accepted answer, and old.

Stack Overflow

Q&A for programmers

-- Old, seriously unloved questions
-- Questions with no upvotes, low views (less than 5 views-per-month), no accepted answer, and old.

SELECT TOP 1000 p.Score, p.Id AS [Post Link], p.ViewCount, p.Tags, Year(p.CreationDate) AS [Year], Month(p.CreationDate) AS Mo
FROM Posts p
WHERE p.PostTypeId = 1 AND 
 (p.ViewCount/(DateDiff(m, p.CreationDate, GetDate()))) < 5 AND 
 p.Score < 1 AND 
 (p.AnswerCount < 2 OR p.AnswerCount IS NULL) AND 
 p.CreationDate < (DateAdd(d, -180, GetDate())) AND 
 p.ClosedDate IS NULL AND p.AcceptedAnswerId IS NULL 
 AND NOT EXISTS 
   (SELECT c.[Id] FROM [Posts] c WHERE c.[Score] > 0 AND c.[ParentId] = p.[Id])
ORDER BY Year(p.CreationDate), Month(p.CreationDate), p.Score, p.ViewCount

Enter Parameters

Options:
Switch sites:
loading Hold tight while we fetch your results