unconnected ceb disamb

SQL

USE cebwiki_p;
SELECT REPLACE(page_title, '_', ' ')#page_title
#,GROUP_CONCAT(ll_lang)
	FROM page
join categorylinks on page_id=cl_from
	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 cl_to = "Robotskapade_förgreningssidor"
WHERE cl_to = "Pagklaro_paghimo_ni_bot"
and pp_value is NULL
#AND ll_title IS NULL
AND page_is_redirect = 0 AND page_namespace = 0
# and page_title like "%(pagklaro)"
#/**/and page_title in (select REPLACE(page_title, '_(desambigua)', '_(pagklaro)')#page_title
#/**/and REPLACE(page_title, '_(pagklaro)', '') in (select page_title
/**/
#and page_title in (select page_title
and page_title in (select page_title#REPLACE(page_title, '_(olika_betydelser)', '')
from nlwiki_p.page p
#	LEFT JOIN (SELECT * FROM svwiki_p.page_props WHERE pp_propname = 'wikibase_item') AS props1
#		ON pp_page = p.page_id
join nlwiki_p.categorylinks c2 on p.page_id=c2.cl_from
 and page_title like "%(doorverwijspagina)"#desambiguación)"#"%(disambigua)"#"%(disambiguation)"desambiguación#
where c2.cl_to = "Wikipedia:Doorverwijspagina"
                   #"Wikipedia:Desambiguación"#"Pagine_di_disambiguazione"#"Disambiguation_pages"#"Pagklaro_paghimo_ni_bot"
                      # "Robotskapade_förgreningssidor"#Dezambiguizare"
                   AND p.page_namespace = 0 AND p.page_is_redirect = 0
# and p.page_title like "%(olika_betydelser)"
#and pp_value is not NULL
and p.page_id not in (select m.ll_from from langlinks m where m.ll_lang="ceb"))/**/
/*and page_id not in (select l.ll_from from langlinks l where l.ll_lang="sv")*//*
group by ll_from*//*
and page_title in (select page_title
from enwiki_p.page p3
join enwiki_p.categorylinks c3 on p3.page_id=c3.cl_from
where c3.cl_to = "Disambiguation_pages"#Dezambiguizare"
                   AND p3.page_namespace = 0 AND p3.page_is_redirect = 0)*/
and page_id not in (select m.ll_from from langlinks m where m.ll_lang="nl")
group by page_title
ORDER BY page_title;
SQL

Checking query status...
