Posts inactive for over 6 months: Useful for Archaeologist badge progress

0

Please login or register to vote for this query.

(click on this box to dismiss)

Beer, Wine & Spirits Meta Stack Exchange

Q&A for alcoholic beverage aficionados and those interested in beer, wine, or spirits

-- List questions inactive for over 6 months
-- Archaeologist Badge: "Edited 100 posts that were inactive for 6 months"

SELECT TOP(50) 
  --'stackoverflow.com/questions/'+p.Id+'/slug' AS URL,
  p.Id, p.Title, p.Score FROM Posts p
WHERE p.LastEditDate < DATEADD(month, -6, p.LastActivityDate) 
  AND p.ParentId IS NULL 
  AND NOT EXISTS (
    SELECT * FROM Posts c
    WHERE c.ParentId = p.Id AND (
          c.LastEditDate >= DATEADD(month, -6, CURRENT_TIMESTAMP)
       OR c.LastActivityDate >= DATEADD(month, -6, CURRENT_TIMESTAMP)
    )
  )

Enter Parameters

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