From ed85388de5215a5fc9a982e7bd2286ba8ba3fef5 Mon Sep 17 00:00:00 2001 From: Sarah Hoffmann Date: Fri, 15 Dec 2017 00:10:05 +0100 Subject: [PATCH] fix address walk-up for reverse Fixes the row for the join and completely drops parts that have a linked_place_id. Fixes #859. --- lib/ReverseGeocode.php | 5 +++-- 1 file changed, 3 insertions(+), 2 deletions(-) diff --git a/lib/ReverseGeocode.php b/lib/ReverseGeocode.php index e538620a..27f8c89c 100644 --- a/lib/ReverseGeocode.php +++ b/lib/ReverseGeocode.php @@ -206,9 +206,10 @@ class ReverseGeocode } else { $iPlaceID = $oResult->iId; } - $sSQL = 'select coalesce(p.linked_place_id, a.address_place_id)'; + $sSQL = 'select a.address_place_id'; $sSQL .= ' FROM place_addressline a, placex p'; - $sSQL .= " WHERE a.place_id = $iPlaceID and a.place_id = p.place_id"; + $sSQL .= " WHERE a.place_id = $iPlaceID and a.address_place_id = p.place_id"; + $sSQL .= ' AND p.linked_place_id is null'; $sSQL .= " ORDER BY abs(cached_rank_address - $iMaxRank) asc,cached_rank_address desc,isaddress desc,distance desc"; $sSQL .= ' LIMIT 1'; $iPlaceID = chksql($this->oDB->getOne($sSQL), 'Could not get parent for place.'); -- 2.39.5