omonime interwiki de unit itemii

SQL

use dewiki_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 = "Begriffsklärung"#in ("Lakes_of_Saskatchewan")#"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 = "Robotskapade_förgreningssidor"/*like "Orter_i_Algeriet%")*//*in ("Indelningar_i_Kanarieöarna",
"Indelningar_i_Kastilien-La_Mancha",
"Indelningar_i_Baskien",
"Indelningar_i_Galicien",
"Indelningar_i_Katalonien",
"Indelningar_i_Kantabrien",
"Indelningar_i_Asturien",
"Indelningar_i_Kastilien_och_Leon",
"Indelningar_i_Navarra",
"Indelningar_i_La_Rioja,_Spanien",
"Indelningar_i_Madrid",
"Indelningar_i_Extremadura",
"Indelningar_i_Aragonien",
"Indelningar_i_Andalusien",
"Indelningar_i_Valencia_(autonom_region)",
"Indelningar_i_Balearerna",
"Indelningar_i_Murcia_(autonom_region)",
"Indelningar_i_Ceuta_(region)",
"Indelningar_i_Melilla_(region)")*/)#*/
                  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, '_', ' ')
SQL

Checking query status...
