items of ro.disambigs to merge with en.disambigs

SQL

use rowiki_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
where page_is_redirect = 0 AND page_namespace = 0
and cl_to like "Pagini_de_dezambiguizar%"
#and page_title not like "%(dezambiguizare)"
and REPLACE(page_title, '_(dezambiguizare)', '') in (select REPLACE(pu.page_title, '_(disambiguation)', '')
from enwiki_p.page pu
join enwiki_p.categorylinks c1 on pu.page_id=c1.cl_from and pu.page_title like "%(disambiguation)"
and cl_to = "All_disambiguation_pages"
and page_is_redirect = 0 AND page_namespace = 0
)
and 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="en")
SQL

Checking query status...
