1

Please login or register to vote for this query.

(click on this box to dismiss)

Posts eligible for Archaeology that are edit fodder

Q&A about the site for gardeners and landscapers

-- Low qualityQuestions eligible for Archeology, i.e older than 6 months


SELECT TOP 1000 
   p.Id AS [Post Link], 
   u.Id AS [User Link], 
   p.ViewCount,
   CASE 
     WHEN P.PostTypeID = 1 THEN 'Question'
     WHEN P.PostTypeID = 2 THEN 'Answer' 
     ELSE 'Not Eligible' END,
   Year(p.LastActivityDate)AS 'Year', 
   Month(p.LastActivityDate)AS 'Month', 
   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.Score < 5 
   AND U.ID>0
   --AND NOT EXISTS (SELECT c.[Id] FROM [Posts] c WHERE c.[Score] > 0 AND c.[ParentId] = p.[Id])
   AND U.LastAccessDate < DATEADD(month, -6, GETDATE())
   AND U.Reputation < 50
ORDER BY P.PostTypeID, Year(p.LastActivityDate), Month(p.LastActivityDate), p.Score, p.ViewCount

fork query

edited aug 18 12 Pureferret

created jan 26 11 Benjol