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
-Subproject commit 8d9087f1111f4a062158e8e6b10bfbceed90899b
+Subproject commit 3a045d7f15adc05d34a719da4266418e9663b322
}
},
{
- "keys" : ["country_code", "ISO3166-1", "is_in:country_code", "is_in_country",
- "addr:country", "addr:country", "addr:country_code"],
+ "keys" : ["country_code", "ISO3166-1", "is_in:country_code", "is_in:country",
+ "addr:country", "addr:country_code"],
"values" : {
"" : "country"
}
}
},
{
- "keys" : ["country_code", "ISO3166-1", "is_in:country_code", "is_in_country",
- "addr:country", "addr:country", "addr:country_code"],
+ "keys" : ["country_code", "ISO3166-1", "is_in:country_code", "is_in:country",
+ "addr:country", "addr:country_code"],
"values" : {
"" : "country"
}
}
},
{
- "keys" : ["country_code", "ISO3166-1", "is_in:country_code", "is_in_country",
- "addr:country", "addr:country", "addr:country_code"],
+ "keys" : ["country_code", "ISO3166-1", "is_in:country_code", "is_in:country",
+ "addr:country", "addr:country_code"],
"values" : {
"" : "country"
}
}
},
{
- "keys" : ["country_code", "ISO3166-1", "is_in:country_code", "is_in_country",
- "addr:country", "addr:country", "addr:country_code"],
+ "keys" : ["country_code", "ISO3166-1", "is_in:country_code", "is_in:country",
+ "addr:country", "addr:country_code"],
"values" : {
"" : "country"
}