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 page_is_redirect = 0
and cl_to = "Dezambiguizare"
group BY page_title
ORDER BY page_title;
*/
USE ukwiki_p;
SELECT page_title, pp_value
	FROM page
JOIN templatelinks ON tl_from = page_id and tl_title = "Lang-ro" and tl_namespace = 10
		join categorylinks on cl_from=page_id
join pagelinks on page_id = pl_from and pl_title = "Румунія"
	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="ro")
AND page_namespace = 0 and page_is_redirect = 0
and cl_to = "Багатозначні_топоніми"
group BY page_title
ORDER BY page_title;
SQL

Checking query status...
