Revisions to A wounded Zombie finder, or: how to find the almost dead undead?

edited tags

Link

edited Mar 26, 2018 at 0:34

Jamal

34.9k
13
133
237

Tweeted twitter.com/StackCodeReview/status/975965805258166272

occurred Mar 20, 2018 at 5:22

fix other mistake found by yuri

Source Link

edited Mar 19, 2018 at 18:25

Zeta

19.3k
2
55
89

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?

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 checked for fast Zombie removal.

Is there something that is utterly wrong? Or can this weapon help us in our fight against the undead?

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?