From c44324fda5ea057dfde87ddee2a749448cf9b146 Mon Sep 17 00:00:00 2001 From: Sarah Hoffmann Date: Fri, 27 Oct 2017 21:57:35 +0200 Subject: [PATCH] ignore linked places for address details Fixes #816. --- sql/functions.sql | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) 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 -- 2.39.5