0

Please login or register to vote for this query.

(click on this box to dismiss)

http://chat.stackexchange.com/transcript/message/409809#409809

Q&A about the site for gardeners and landscapers

-- Really old, low views, low votes and even unanswered questions.
-- http://chat.stackexchange.com/transcript/message/409809#409809

SELECT TOP 1000 p.Score, p.Id AS [Post Link], p.ViewCount, p.Tags, Year(p.LastActivityDate), Month(p.LastActivityDate), CASE WHEN p.ClosedDate IS NULL THEN 'No' ELSE 'Yes' END AS Closed
FROM Posts p
WHERE p.PostTypeId = 1 AND p.ViewCount < 200 AND p.Score < 4 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.LastActivityDate), Month(p.LastActivityDate), p.Score, p.ViewCount

fork query

created jan 26 11 Benjol