sh RO-related duplicates disambigs

SQL

USE shwiki_p;
select p1.page_title, REPLACE(REPLACE(REPLACE(REPLACE(p1.page_title, "Ş", "Ș"), "ş", "ș"), "Ţ", "Ț"), "ţ", "ț")
from page p1
#join page p2 on REPLACE(REPLACE(REPLACE(REPLACE(p2.page_title, "Ş", "Ș"), "ş", "ș"), "Ţ", "Ț"), "ţ", "ț") = p1.page_title
where /*page_title in (select pl_title FROM shwiki_p.pagelinks pl1 where pl1.pl_from = 4597219) 
AND*/ p1.page_is_redirect = 0 AND p1.page_namespace = 0 #and p2.page_is_redirect = 0 AND p2.page_namespace = 0
/*
AND REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(page_title, '_(razvrstavanje)', ''), "Ş", "Ș"), "ş", "ș"), "Ţ", "Ț"), "ţ", "ț")
        in (select REPLACE(page_title, '_(dezambiguizare)', '')#page_title
        */
            
and p1.page_title like "%(razvrstavanje)" 
and (p1.page_title like "%ş%" or p1.page_title like "%ţ%") 
/*
and REPLACE(page_title, '_(razvrstavanje)', '') in (select page_title#REPLACE(page_title, '_(Begriffsklärung)', '')#page_title
/*and REPLACE(page_title, '_(olika_betydelser)', '') in (select page_title#REPLACE(page_title, '_(Begriffsklärung)', '')#page_title
#and REPLACE(page_title, '_(pagklaro)', '') in (select REPLACE(page_title, '_(Begriffsklärung)', '')#page_title
#and REPLACE(page_title, '_(olika_betydelser)', '') in (select REPLACE(page_title, '_(Begriffsklärung)', '')#page_title
           */
and REPLACE(REPLACE(REPLACE(REPLACE(p1.page_title, "Ş", "Ș"), "ş", "ș"), "Ţ", "Ț"), "ţ", "ț") in (select p2.page_title
#from enwiki_p.page p
#join enwiki_p.categorylinks c2 on p.page_id=c2.cl_from
from shwiki_p.page p2
#join shwiki_p.categorylinks c2 on p.page_id=c2.cl_from
#where c2.cl_to = "Disambiguation_pages" 
#where c2.cl_to = "Dezambiguizare" 
            where p2.page_is_redirect = 0 AND p2.page_namespace = 0 
and p2.page_title like "%(razvrstavanje)"
and (p2.page_title like "%ș%" or p2.page_title like "%ț%") 
                     
                     )#
                     
#and page_id not in (select m.ll_from from langlinks m /*where m.ll_lang="ro"*/)
ORDER BY p1.page_title
#limit 400
SQL

Checking query status...
