ceb disamb - Quarry

SQL

USE svwiki_p;
SELECT page_title
	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 = "Razvrstavanje"
#WHERE cl_to = "Pagklaro_paghimo_ni_bot"
where cl_to = "Robotskapade_förgreningssidor"
#WHERE cl_to = "Pagklaro_paghimo_ni_bot"#_Rusya"
and pp_value is not NULL
#AND ll_title IS NULL
# and page_title like "%(pagklaro)"
AND page_is_redirect = 0 AND page_namespace = 0
and /*page_title*/REPLACE(page_title, '_(olika_betydelser)', '') in (select p.page_title#REPLACE(page_title, '_(Begriffsklärung)', '')#page_title
#and REPLACE(page_title, '_(razvrstavanj)', '') in (select page_title#REPLACE(page_title, '_(Begriffsklärung)', '')#page_title
#and page_title in (select REPLACE(page_title, '_(olika_betydelser)', '')#page_title#REPLACE(page_title, '_(Begriffsklärung)', '')#page_title
#and REPLACE(page_title, '_(pagklaro)', '') in (select page_title#REPLACE(page_title, '_(Begriffsklärung)', '')#page_title
#and REPLACE(page_title, '_(pagklaro)', '') in (select REPLACE(page_title, '_(olika_betydelser)', '')#page_title(Begriffsklärung)
#and REPLACE(page_title, '_(olika_betydelser)', '') in (select REPLACE(page_title, '_(Begriffsklärung)', '')#page_title
from cebwiki_p.page p
join cebwiki_p.categorylinks c2 on p.page_id=c2.cl_from
#where c2.cl_to = "Robotskapade_förgreningssidor"
where c2.cl_to = "Pagklaro_paghimo_ni_bot"#"Razvrstavanje"
                   #"Страницы_разрешения_неоднозначностей_по_алфавиту"/*"Robotskapade_Rysslandförgreningar"*/ 
AND p.page_is_redirect = 0 AND p.page_namespace = 0 
#where c2.cl_to = "Dezambiguizare" AND page_is_redirect = 0 AND page_namespace = 0 
#where c2.cl_to = "Begriffsklärung" AND page_is_redirect = 0 AND page_namespace = 0 
# and p.page_title like "%(Begriffsklärung)"
# and p.page_title like "%(olika_betydelser)"
and p.page_id not in (select m1.ll_from from langlinks m1 where m1.ll_lang="sv"))
/*and page_title in (select page_title
from svwiki_p.page
join svwiki_p.categorylinks c3 on page_id=c3.cl_from
	LEFT JOIN (SELECT * FROM page_props WHERE pp_propname = 'wikibase_item') AS props
		ON pp_page = page_id
where c3.cl_to = "Robotskapade_förgreningssidor" AND page_is_redirect = 0 AND page_namespace = 0
and pp_value is NULL)*//*
group by ll_from*/
and page_id not in (select m.ll_from from langlinks m where m.ll_lang="ceb")
ORDER BY page_title;
SQL

Checking query status...
