1

Please login or register to vote for this query.

(click on this box to dismiss)

http://meta.stackoverflow.com/questions/76485/old-unanswered-inactive-questions-with-low-views-votes

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

-- Really old questions, no upvotes, <100 views, low rep OP, not seen in last year
-- http://meta.stackoverflow.com/questions/76485/old-unanswered-inactive-questions-with-low-views-votes

SELECT TOP 1000 
   p.Id AS [Post Link], 
   u.Id AS [User 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
INNER JOIN Users U on P.OwnerUserId = U.Id
WHERE p.PostTypeId = 1 
   AND p.ViewCount < 100 
   AND p.Score < 1 
   AND p.AcceptedAnswerId IS NULL 
   AND NOT EXISTS (SELECT c.[Id] FROM [Posts] c WHERE c.[Score] > 0 AND c.[ParentId] = p.[Id])
   AND U.LastAccessDate < DATEADD(month, -12, GETDATE())
   AND U.Reputation < 10
ORDER BY Year(p.LastActivityDate), Month(p.LastActivityDate), p.Score, p.ViewCount

fork query

created jan 26 11 Benjol