Searches for open, non-CW posts older than 60 days with no accepted answer and no answer scoring 2 or more. (Now updated so merged questions do not appear.)
Q&A about the site for information security professionals
-- Find questions ripe for the Revival and Necromancer badges -- (Now updated so merged questions do not appear.) SELECT TOP 1000 p.Id AS [Post Link], p.Score, p.CreationDate as [Asked Date], p.ViewCount FROM Posts p WHERE p.AcceptedAnswerId IS NULL AND p.PostTypeId = 1 AND p.CreationDate < GETDATE() - 60 AND p.CommunityOwnedDate IS NULL AND p.ClosedDate IS NULL AND NOT EXISTS ( SELECT * FROM Posts p2 WHERE p2.ParentId = p.Id AND p2.Score >= 2 AND p2.PostTypeId = 2 ) AND NOT EXISTS ( SELECT * FROM PostHistory ph WHERE ph.PostId = p.Id AND ph.PostHistoryTypeId = 14 ) ORDER BY p.Score DESC