diff options
| author | Azcobu <81782124+Azcobu@users.noreply.github.com> | 2021-08-26 07:37:32 +0930 |
|---|---|---|
| committer | GitHub <noreply@github.com> | 2021-08-26 00:07:32 +0200 |
| commit | e998de4db074d3bee690a90f3efa6cbdf41086d3 (patch) | |
| tree | 9d441bafdf4797e0cbd912c00bfb665cda8a0b64 /docs/useful-sql.md | |
| parent | fc51d346cda4f834b411592f09a0e25072f058a2 (diff) | |
| download | wiki-e998de4db074d3bee690a90f3efa6cbdf41086d3.tar.gz wiki-e998de4db074d3bee690a90f3efa6cbdf41086d3.tar.bz2 wiki-e998de4db074d3bee690a90f3efa6cbdf41086d3.zip | |
Improved average wander distance query (#626)
Diffstat (limited to 'docs/useful-sql.md')
| -rw-r--r-- | docs/useful-sql.md | 2 |
1 files changed, 1 insertions, 1 deletions
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 |