From e998de4db074d3bee690a90f3efa6cbdf41086d3 Mon Sep 17 00:00:00 2001
From: Azcobu <81782124+Azcobu@users.noreply.github.com>
Date: Thu, 26 Aug 2021 07:37:32 +0930
Subject: Improved average wander distance query (#626)

---
 docs/useful-sql.md | 2 +-
 1 file changed, 1 insertion(+), 1 deletion(-)

(limited to 'docs')

diff --git a/docs/useful-sql.md b/docs/useful-sql.md
index 7b7f660..cfcc2ca 100644
--- a/docs/useful-sql.md
+++ b/docs/useful-sql.md
@@ -108,7 +108,7 @@ Handy for fixing static creatures.
 ```sql
 SELECT c.id, AVG(c.wander_distance)
 FROM `creature` c
-WHERE c.id = XXXX;
+WHERE c.id = XXXX AND c.wander_distance > 0;
 ```
 
 ### Find other members of a node pool
-- 
cgit