ru-uk-bg homonymous pages

SQL

use ukwiki_p;
select page_title, pp_value, (select ppb.pp_value from page pb join page_props ppb on ppb.pp_page = pb.page_id)
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
where cl_to = "Багатозначні_топоніми"#Страницы_разрешения_неоднозначностей:_населённые_пункты
and page_title in (select page_title
from bgwiki_p.page
join bgwiki_p.categorylinks c1 on page_id=c1.cl_from
#join svwiki_p.categorylinks c2 on page_id=c2.cl_from
where c1.cl_to = "Пояснителни_страници" /*and c2.cl_to like "Orter%"*/ )
/*
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="bg")
group by ll_from
SQL

Checking query status...
