diff options
| author | Greg Roach <greg@subaqua.co.uk> | 2026-03-02 21:40:59 +0000 |
|---|---|---|
| committer | Greg Roach <greg@subaqua.co.uk> | 2026-03-02 21:40:59 +0000 |
| commit | 2b56cf1b5f2a1ffc5f733808d2e039b6e51c05db (patch) | |
| tree | 370078ecff57ae44fa11ab70ee23b5dae86dd8dd | |
| parent | 14abb1c66656b3e105d68b06cc6cfbc757f93b39 (diff) | |
| download | webtrees-2b56cf1b5f2a1ffc5f733808d2e039b6e51c05db.tar.gz webtrees-2b56cf1b5f2a1ffc5f733808d2e039b6e51c05db.tar.bz2 webtrees-2b56cf1b5f2a1ffc5f733808d2e039b6e51c05db.zip | |
#5325 - Specify all grouped columns in GROUP BY clause
| -rw-r--r-- | app/Services/MapDataService.php | 8 |
1 files 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'), ]) |