comune/sate RO in ceb.wiki de conectat in WD

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

use cebwiki_p;
select cl_to, page_title
from page
#LEFT JOIN langlinks ON ll_from = page_id
	LEFT JOIN (SELECT * FROM page_props WHERE pp_propname = 'wikibase_item') AS props
		ON pp_page = 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 in ("Mga_subdibisyon_sa_Suceava_(lalawigan)",
"Mga_subdibisyon_sa_Județul_Caraș-Severin",
"Mga_subdibisyon_sa_Vaslui_(lalawigan)",
"Mga_subdibisyon_sa_Județul_Alba",
"Mga_subdibisyon_sa_Teleorman_(lalawigan)",
"Mga_subdibisyon_sa_Județul_Sălaj",
"Mga_subdibisyon_sa_Arad_(lalawigan)",
"Mga_subdibisyon_sa_Județul_Buzău",
"Mga_subdibisyon_sa_Harghita_(lalawigan_sa_Rumanya)",
"Mga_subdibisyon_sa_Județul_Bacău",
"Mga_subdibisyon_sa_Județul_Brăila",
"Mga_subdibisyon_sa_Județul_Vâlcea",
"Mga_subdibisyon_sa_Județul_Brașov",
"Mga_subdibisyon_sa_Județul_Neamț",
"Mga_subdibisyon_sa_Hunedoara_(lalawigan)",
"Mga_subdibisyon_sa_Județul_Bistrița-Năsăud",
"Mga_subdibisyon_sa_Covasna_(lalawigan)",
"Mga_subdibisyon_sa_Județul_Mureș",
"Mga_subdibisyon_sa_Județul_Sibiu",
"Mga_subdibisyon_sa_Vrancea_(lalawigan)",
"Mga_subdibisyon_sa_Constanța_(lalawigan_sa_Rumanya)",
"Mga_subdibisyon_sa_Județul_Argeș",
"Mga_subdibisyon_sa_Olt_(lalawigan)",
"Mga_subdibisyon_sa_Județul_Cluj",
"Mga_subdibisyon_sa_Județul_Dâmbovița",
"Mga_subdibisyon_sa_Județul_Mehedinți",
"Mga_subdibisyon_sa_Județul_Botoșani",
"Mga_subdibisyon_sa_Ilfov",
"Mga_subdibisyon_sa_Județul_Timiș",
"Mga_subdibisyon_sa_Județul_Iași",
"Mga_subdibisyon_sa_Județul_Călărași",
"Mga_subdibisyon_sa_Gorj",
"Mga_subdibisyon_sa_Județul_Galați",
"Mga_subdibisyon_sa_Județul_Ialomița",
"Mga_subdibisyon_sa_Județul_Maramureș",
"Mga_subdibisyon_sa_Dolj",
"Mga_subdibisyon_sa_Bihor_(lalawigan)",
"Mga_subdibisyon_sa_Giurgiu_(lalawigan)",
"Mga_subdibisyon_sa_Prahova_(lalawigan)",
"Mga_subdibisyon_sa_Satu_Mare_(lalawigan)",
"Mga_subdibisyon_sa_Tulcea_(lalawigan)",
"Mga_subdibisyon_sa_București_(lalawigan_sa_Rumanya)")
and page_title like "Comuna%"
#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 )
               */
/*
                  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 is NULL
/*
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...
