The Zombies are on their way to eat our statistics. Fortunately, we have a way to get rid of them: our votes. However, we need to find them first. The /unanswered section is too large and contains many strong enemies where we have to write a review first. But the StackExchange Data Explorer can sniff almost dead Zombies from a mile.
For this, we need a fitting query. This is what I've tried:
SELECT q.Id AS [Post Link], MAX(a.Score) AS [Best answer score] FROM Posts q JOIN Posts a ON a.ParentId = q.Id WHERE q.PostTypeId = 1 AND q.AnswerCount > 0 AND q.AcceptedAnswerId IS NULL AND a.PostTypeId = 2 GROUP BY q.Id HAVING MAX(a.Score) = 0
You can run and find the query on SEDE.
It searches for questions (
q.PostTypeId = 1) that have at least one answer, no accepted answer, and the maximum score of all its answers is
0. The resulting list can then be checked for fast Zombie removal.
Is there something that is utterly wrong? Or can this weapon help us in our fight against the undead?