disambiguri tematice de interconectat (@bg in ro; @ro in uk)

SQL

USE rowiki_p;
SELECT page_title, pp_value
	FROM page
#JOIN templatelinks ON tl_from = page_id and tl_title = "Lang-bg" and tl_namespace = 10
		join categorylinks on cl_from=page_id
join pagelinks on page_id = pl_from and pl_title = "Bulgaria"
# pl_namespace
	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
WHERE pp_value is not NULL
AND /*ll_title IS NULL*/ ll_from not in (select m.ll_from from langlinks m where m.ll_lang="bg")
AND page_namespace = 0
and cl_to = "Dezambiguizare"
#(cl_to = "Comunele_Ucrainei" or cl_to like "Sate_în_Ucraina")#"%în_Ucraina"
group BY page_title
ORDER BY page_title;
/*
USE rowiki_p;
SELECT page_title, pp_value
	FROM page
JOIN templatelinks ON tl_from = page_id and tl_title in ("Bg", "Lang-bg") and tl_namespace = 10
		join categorylinks on cl_from=page_id
	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
WHERE pp_value is not NULL
AND #ll_title IS NULL
ll_from not in (select m.ll_from from langlinks m where m.ll_lang="bg")
AND page_namespace = 0
and cl_to like "Sate_în%"
#(cl_to = "Comunele_Ucrainei" or cl_to like "Sate_în_Ucraina")#"%în_Ucraina"
group BY page_title
ORDER BY page_title;
*/
SQL

Checking query status...
