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 for students, teachers, polyglots, and anyone interested in the techniques of second-language acquisition
-- Find questions ripe for the Revival and Necromancer badges -- Need to figure out how to filter out merged questions SELECT TOP 1000 p.Id AS [Post Link], p.Score, p.CreationDate as [Asked Date], p.ViewCount FROM Posts p INNER JOIN PostHistory h ON h.PostId = p.Id INNER JOIN PostHistoryTypes t ON t.Id = h.PostHistoryTypeId WHERE 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 ) ORDER BY p.Score DESC