Q&A about the site for enthusiasts and scholars of mythology and folklore
-- Revival/Necromancer badge candidates -- SELECT TOP 1000 p.Id AS [Post Link], p.* FROM Posts p WHERE AcceptedAnswerId IS NULL AND p.PostTypeId = 1 AND p.CreationDate < GETDATE() - 60 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.AnswerCount ASC