diff options
| -rw-r--r-- | sql/updates/world/master/2022_01_18_07_world_2020_06_26_06_world.sql | 2 |
1 files changed, 1 insertions, 1 deletions
diff --git a/sql/updates/world/master/2022_01_18_07_world_2020_06_26_06_world.sql b/sql/updates/world/master/2022_01_18_07_world_2020_06_26_06_world.sql index 9ad0b083530..b4d7d1aeccd 100644 --- a/sql/updates/world/master/2022_01_18_07_world_2020_06_26_06_world.sql +++ b/sql/updates/world/master/2022_01_18_07_world_2020_06_26_06_world.sql @@ -6,7 +6,7 @@ FROM `creature` c INNER JOIN ( SELECT - ctm.CreatureDisplayID AS CreatureDisplayID, + SUM(ctm.CreatureDisplayID) AS CreatureDisplayID, -- SUM works around GROUP BY requirementof sql_mode=ONLY_FULL_GROUP_BY, we can do this because we are selecting only 1 row ctm.CreatureID AS CreatureID FROM creature_template_model ctm |