find posts to edit for Excavator and Archaeologist badges

10

Please login or register to vote for this query.

(click on this box to dismiss)

finds questions that have been inactive for at least 6 months

Reverse Engineering Meta

Q&A about the site for researchers and developers who explore the principles of a system through analysis of its structure, function, and operation

select TOP 1000
    Id as [Post Link],
    Score,
    LastActivityDate
FROM Posts
WHERE PostTypeId=1
AND OwnerUserId!=##UserID:int##
AND LastActivityDate < DATEADD(mm, -6, GETDATE())
ORDER BY NEWID()

Enter Parameters

Options:
Switch to main site
loading Hold tight while we fetch your results