From 6d764a05b013eb59692760c81630361428597c62 Mon Sep 17 00:00:00 2001
From: Sarah Hoffmann <lonvia@denofr.de>
Date: Sun, 17 Nov 2019 19:53:42 +0100
Subject: [PATCH] prefer English wikipedia for wikidata matches

---
 sql/functions.sql | 2 +-
 1 file changed, 1 insertion(+), 1 deletion(-)

diff --git a/sql/functions.sql b/sql/functions.sql
index 09033567..9a78887b 100644
--- a/sql/functions.sql
+++ b/sql/functions.sql
@@ -2703,7 +2703,7 @@ BEGIN
   IF extratags ? 'wikidata' THEN
     FOR match IN SELECT * FROM wikipedia_article
                   WHERE wd_page_title = extratags->'wikidata'
-                  ORDER BY importance DESC limit 1 LOOP
+                  ORDER BY language = 'en' DESC, langcount DESC LIMIT 1 LOOP
       result.importance := match.importance;
       result.wikipedia := match.language || ':' || match.title;
       RETURN result;
-- 
2.39.5