From: marc tobias <mtmail@gmx.net>
Date: Sat, 14 Dec 2019 19:36:54 +0000 (+0100)
Subject: wikipedia: create all language pagelinkcount tables before querying them
X-Git-Tag: v3.5.0~120^2
X-Git-Url: https://git.openstreetmap.org./nominatim.git/commitdiff_plain/394f85a96b77f83075a9c62d0ec0ca4932072bbe?ds=sidebyside

wikipedia: create all language pagelinkcount tables before querying them
---

diff --git a/data-sources/wikipedia-wikidata/import_wikipedia.sh b/data-sources/wikipedia-wikidata/import_wikipedia.sh
index 8b8ba52a..9cc9b1df 100755
--- a/data-sources/wikipedia-wikidata/import_wikipedia.sh
+++ b/data-sources/wikipedia-wikidata/import_wikipedia.sh
@@ -52,6 +52,10 @@ do
     echo "insert into wikipedia_redirect select '${i}',page_title,rd_title from ${i}redirect join ${i}page on (rd_from = page_id) where page_namespace = 0 and rd_namespace = 0;" | psqlcmd
     echo "alter table ${i}pagelinkcount add column othercount integer;" | psqlcmd
     echo "update ${i}pagelinkcount set othercount = 0;" | psqlcmd
+done
+
+for i in "${language[@]}"
+do
     for j in "${language[@]}"
     do
         echo "update ${i}pagelinkcount set othercount = ${i}pagelinkcount.othercount + x.count from (select page_title as title,count from ${i}langlinks join ${i}page on (ll_from = page_id) join ${j}pagelinkcount on (ll_lang = '${j}' and ll_title = title)) as x where x.title = ${i}pagelinkcount.title;" | psqlcmd