use wikidata links for importance as well

[nominatim.git] / sql / functions.sql

diff --git a/sql/functions.sql b/sql/functions.sql
index e324277e92b9ec9b42e1ef981332cd58e65e0f76..b2caf0a69c5a49c1d90c41d7ca780d81a68af889 100644 (file)
--- a/sql/functions.sql
+++ b/sql/functions.sql
@@ -2698,13 +2698,15 @@ BEGIN
     RETURN result;
   END LOOP;
 
-  FOR match IN SELECT * FROM wikipedia_article
-                WHERE osm_type = osm_type and osm_id = osm_id
-                ORDER BY importance DESC limit 1 LOOP
-    result.importance := match.importance;
-    result.wikipedia := match.language || ':' || match.title;
-    RETURN result;
-  END LOOP;
+  IF extratags ? 'wikidata' THEN
+    FOR match IN SELECT * FROM wikipedia_article
+                  WHERE wd_page_title = extratags->'wikidata'
+                  ORDER BY importance DESC limit 1 LOOP
+      result.importance := match.importance;
+      result.wikipedia := match.language || ':' || match.title;
+      RETURN result;
+    END LOOP;
+  END IF;
 
   RETURN null;
 END;