diff options
Diffstat (limited to 'app/Services/MapDataService.php')
| -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'), ]) |