Which posts for a specified tag are eligible for Archaeologist edits?

1

Please login or register to vote for this query.

(click on this box to dismiss)

Old low quality questions that are edit fodder

Music Fans Meta

Q&A about the site for music historians, critics, and fans

-- which posts are older than 6 months
-- and need editing


SELECT TOP 300
  P.Id AS [Post Link],
  P.CreationDate,
  P.Score,
  P.PostTypeID,
  p.LastEditDate,
  p.LastActivityDate
FROM Posts AS P
WHERE p.LastActivityDate < DATEADD(month, -6, GETDATE())
AND p.LastEditDate < DATEADD(month, -6, p.LastActivityDate) 
AND Score > 0
AND AnswerCount = 0
AND AcceptedAnswerId IS NULL
AND ClosedDate IS NULL
AND Tags like '%##tag##%'
ORDER BY score desc

Enter Parameters

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