omonime interwiki de unit itemii

SQL

use cebwiki_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 = "Iran_paghimo_ni_bot"#like "Civil_parishes_in%"#cl_to = "Lakes_of_Finland"#
/*in ("Populated_places_in_Central_Province,_Sri_Lanka",
"Populated_places_in_Eastern_Province,_Sri_Lanka",
"Populated_places_in_North_Central_Province,_Sri_Lanka",
"Populated_places_in_North_Western_Province,_Sri_Lanka",
"Populated_places_in_Northern_Province,_Sri_Lanka",
"Populated_places_in_Sabaragamuwa_Province",
"Populated_places_in_Southern_Province,_Sri_Lanka",
"Populated_places_in_Uva_Province",
"Populated_places_in_Western_Province,_Sri_Lanka")*/#"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_namespace = 0 and page_is_redirect = 0
and page_title in (select p2.page_title
from svwiki_p.page p2
#join svwiki_p.categorylinks c1 on page_id=c1.cl_from
join svwiki_p.categorylinks c2 on p2.page_id = c2.cl_from
where /*c1.cl_to like "Orter_i%"
and */c2.cl_to = "Robotskapade_Iranartiklar" AND p2.page_namespace = 0 and p2.page_is_redirect = 0
and p2.page_id not in (select m1.ll_from from svwiki_p.langlinks m1 where m1.ll_lang="ceb"))
#and page_id in (select pl_from FROM svwiki_p.pagelinks swpl where swpl.pl_title = "Civil_parish"))
           /*    in ("Indelningar_i_Centralprovinsen_(Sri_Lanka)",
"Indelningar_i_Nordprovinsen_(Sri_Lanka)",
"Indelningar_i_Nordvästprovinsen_(Sri_Lanka)",
"Indelningar_i_Norra_Centralprovinsen_(Sri_Lanka)",
"Indelningar_i_Sabaragamuwa",
"Indelningar_i_Sydprovinsen_(Sri_Lanka)",
"Indelningar_i_Uvaprovinsen",
"Indelningar_i_Västprovinsen_(Sri_Lanka)",
"Indelningar_i_Östprovinsen_(Sri_Lanka)"))#*/#*/
/*
                  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 page_id not in (select m.ll_from from cebwiki_p.langlinks m where m.ll_lang="sv")
group by page_title
#and ll_title != REPLACE(page_title, '_', ' ')
SQL

Checking query status...
