diff options
Diffstat (limited to 'app/Services/MapDataService.php')
| -rw-r--r-- | app/Services/MapDataService.php | 6 |
1 files changed, 2 insertions, 4 deletions
diff --git a/app/Services/MapDataService.php b/app/Services/MapDataService.php index c94046610a..a664bd31d7 100644 --- a/app/Services/MapDataService.php +++ b/app/Services/MapDataService.php @@ -75,11 +75,9 @@ class MapDataService $children = []; $rows = DB::table('places') - ->join('gedcom', 'gedcom.gedcom_id', '=', 'p_file') - ->join('gedcom_setting', 'gedcom_setting.gedcom_id', '=', 'gedcom.gedcom_id') - ->where('setting_name', '=', 'title') + ->join('gedcom', 'gedcom_id', '=', 'p_file') ->whereIn('p_parent_id', $parents) - ->select(['p_place', 'gedcom_name AS tree_name', 'setting_value AS tree_title', 'p_id']) + ->select(['p_place', 'gedcom_name AS tree_name', 'title AS tree_title', 'p_id']) ->get() ->map(static fn (object $row): object => (object) [ 'p_place' => $row->p_place, |