0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for professional and enthusiast programmers

-- 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,p.Tags 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)
    )
  )
ORDER BY p.Score ASC

fork query

edited mar 7 18 anonymous

created may 9 12 GregB