From: Sarah Hoffmann <lonvia@denofr.de>
Date: Fri, 27 Oct 2017 19:57:35 +0000 (+0200)
Subject: ignore linked places for address details
X-Git-Tag: v3.1.0~24
X-Git-Url: https://git.openstreetmap.org./nominatim.git/commitdiff_plain/c44324fda5ea057dfde87ddee2a749448cf9b146

ignore linked places for address details

Fixes #816.
---

diff --git a/sql/functions.sql b/sql/functions.sql
index 596bf808..1691e235 100644
--- a/sql/functions.sql
+++ b/sql/functions.sql
@@ -2509,7 +2509,7 @@ BEGIN
       from place_addressline join placex on (address_place_id = placex.place_id) 
       where place_addressline.place_id = for_place_id 
       and (cached_rank_address > 0 AND cached_rank_address < searchrankaddress)
-      and address_place_id != for_place_id
+      and address_place_id != for_place_id and linked_place_id is null
       and (placex.country_code IS NULL OR searchcountrycode IS NULL OR placex.country_code = searchcountrycode)
       order by rank_address desc,isaddress desc,fromarea desc,distance asc,rank_search desc
   LOOP