A CR Zombie finder that takes a tag name to find zombies.
Q&A for professional and enthusiast programmers
SELECT q.Id AS [Post Link], q.Tags FROM Posts q INNER JOIN Posts a ON q.Id = a.ParentId INNER JOIN PostTags ON q.Id = PostTags.PostId INNER JOIN Tags ON PostTags.TagId = Tags.id WHERE q.AnswerCount > 0 AND q.AcceptedAnswerId IS NULL AND Tags.TagName = '##TagName##' GROUP BY q.Id, q.Tags HAVING MAX(a.Score) <= ##MaxScore:int?0## AND MAX(a.Score) >= ##MinScore:int?0## -- TagName: Tag name "as you would use in your post" -- MinScore: Highest answer has at least votes: -- MaxScore: Highest answer has at most votes: