omonime interwiki de unit itemii

This query is marked as a draft This query has been published by XXN.
SQL

use frwiki_p;
select page_title#, pp_value
from page
LEFT JOIN langlinks ON ll_from = page_id
#JOIN (SELECT * FROM page_props WHERE pp_propname = 'wikibase_item') AS props ON pp_page = page_id
join categorylinks on page_id=cl_from
#JOIN templatelinks ON tl_from = page_id and tl_namespace = 10
where cl_to #= "Municipalities_of_Croatia"#like "Civil_parishes_in%"#cl_to = "Lakes_of_Finland"#
in ("Ville_et_village_du_comitat_de_Bács-Kiskun",
"Ville_et_village_du_comitat_de_Baranya",
"Ville_et_village_du_comitat_de_Békés",
"Ville_et_village_du_comitat_de_Borsod-Abaúj-Zemplén",
"Ville_et_village_du_comitat_de_Csongrád",
"Ville_et_village_du_comitat_de_Fejér",
"Ville_et_village_du_comitat_de_Győr-Moson-Sopron",
"Ville_et_village_du_comitat_de_Hajdú-Bihar",
"Ville_et_village_du_comitat_de_Heves",
"Ville_et_village_du_comitat_de_Jász-Nagykun-Szolnok",
"Ville_et_village_du_comitat_de_Komárom-Esztergom",
"Ville_et_village_du_comitat_de_Nógrád",
"Ville_et_village_du_comitat_de_Pest",
"Ville_et_village_du_comitat_de_Somogy",
"Ville_et_village_du_comitat_de_Szabolcs-Szatmár-Bereg",
"Ville_et_village_du_comitat_de_Tolna",
"Ville_et_village_du_comitat_de_Vas",
"Ville_et_village_du_comitat_de_Veszprém",
"Ville_et_village_du_comitat_de_Zala")#"Naseljena_mjesta_u_Federaciji_Bosne_i_Hercegovine"
#AND tl_title = "Lang-bg"
#and REPLACE(page_title, ',_Chile', '') in (select REPLACE(page_title, '_(kommun_i_Chile)', '')
and page_title in (select page_title
from svwiki_p.page
#join svwiki_p.categorylinks c1 on page_id=c1.cl_from
join svwiki_p.categorylinks c2 on page_id=c2.cl_from
where /*c1.cl_to like "Orter_i%"
and */c2.cl_to #= "Robotskapade_Kroatienartiklar")
#and page_id in (select pl_from FROM svwiki_p.pagelinks swpl where swpl.pl_title = "Civil_parish"))
               in ("Orter_i_Bács-Kiskun",
"Orter_i_Baranya",
"Orter_i_Békés",
"Orter_i_Békés_(provins)",
"Orter_i_Borsod-Abaúj-Zemplén",
"Orter_i_Budapest",
"Orter_i_Csongrád_(provins)",
"Orter_i_Fejér",
"Orter_i_Győr-Moson-Sopron",
"Orter_i_Hajdú-Bihar",
"Orter_i_Heves_(provins)",
"Orter_i_Jász-Nagykun-Szolnok",
"Orter_i_Komárom-Esztergom",
"Orter_i_Nógrád",
"Orter_i_Pest_(provins)",
"Orter_i_Somogy",
"Orter_i_Szabolcs-Szatmár-Bereg",
"Orter_i_Tolna",
"Orter_i_Tolna_(provins)",
"Orter_i_Vas_(provins)",
"Orter_i_Veszprém_(provins)",
"Orter_i_Zala"))#*/#*/
/*
                  and page_title in (select pl_title FROM svwiki_p.pagelinks swpl
                                              where swpl.pl_from = 6330770)*/
#and page_title like "%(kommun_i_Chile)")
/*
and pp_value not in (select pp_value
from svwiki_p.page
JOIN (SELECT * FROM svwiki_p.page_props WHERE pp_propname = 'wikibase_item') AS props ON pp_page = page_id
join svwiki_p.categorylinks on page_id=cl_from
where cl_to in ("Orter_i_Federationen_Bosnien_och_Hercegovina", "Orter_i_Republika_Srpska") )*/
and ll_from not in (select m.ll_from from langlinks m where m.ll_lang="sv")
group by ll_from
#and ll_title != REPLACE(page_title, '_', ' ')
By running queries you agree to the Cloud Services Terms of Use and you irrevocably agree to release your SQL under CC0 License.
Submit Query Stop Query
All SQL code is licensed under CC0 License.
SQL

Checking query status...
