X-Git-Url: https://git.openstreetmap.org/nominatim.git/blobdiff_plain/c3940466b817a4c10a956f61c43d6bee3214dd40..a8a700e16d286971c43c013b322a1fd4a339de4d:/sql/functions.sql?ds=sidebyside diff --git a/sql/functions.sql b/sql/functions.sql index 97baf52b..e5e189a8 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