From 2b56cf1b5f2a1ffc5f733808d2e039b6e51c05db Mon Sep 17 00:00:00 2001
From: Greg Roach <greg@subaqua.co.uk>
Date: Mon, 2 Mar 2026 21:40:59 +0000
Subject: #5325 - Specify all grouped columns in GROUP BY clause

---
 app/Services/MapDataService.php | 8 ++++++--
 1 file changed, 6 insertions(+), 2 deletions(-)

diff --git a/app/Services/MapDataService.php b/app/Services/MapDataService.php
index a664bd31d7..29bfd7d424 100644
--- a/app/Services/MapDataService.php
+++ b/app/Services/MapDataService.php
@@ -230,9 +230,13 @@ class MapDataService
         }
 
         return $query
-            ->groupBy(['p0.id'])
+            ->groupBy(['p0.id', 'p0.parent_id', 'p0.place', 'p0.latitude', 'p0.longitude'])
             ->select([
-                'p0.*',
+                'p0.id',
+                'p0.parent_id',
+                'p0.place',
+                'p0.latitude',
+                'p0.longitude',
                 new Expression('COUNT(' . DB::prefix('p1') . '.id) AS child_count'),
                 new Expression('SUM(' . $expression . ') AS no_coord'),
             ])
-- 
cgit v1.3