ceb-sv cats - Quarry

SQL

SELECT sp.page_title#CONCAT("Category:",sp.page_title),spp.pp_value
	FROM svwiki_p.page sp
join svwiki_p.categorylinks sc on sc.cl_to = sp.page_title#sc.cl_from = sp.page_id
	LEFT JOIN (SELECT * FROM svwiki_p.page_props WHERE pp_propname = 'wikibase_item') AS spp
		ON spp.pp_page = sp.page_id
JOIN (SELECT * FROM cebwiki_p.page cp 
      LEFT JOIN (SELECT * FROM cebwiki_p.page_props WHERE pp_propname = 'wikibase_item') AS cpp
ON cpp.pp_page = cp.page_id
join cebwiki_p.categorylinks cc on cp.page_title=cc.cl_to
      WHERE cp.page_namespace = 14 and cp.page_is_redirect = 0 and cpp.pp_value is NULL) AS ceb
		ON ceb.page_title = sp.page_title 
where spp.pp_value is NULL
and sp.page_title in (select p1.page_title from svwiki_p.page p1 
	LEFT JOIN svwiki_p.langlinks sl
    	ON sl.ll_from = p1.page_id where p1.page_namespace = 0 
        and p1.page_is_redirect = 0 
                      and sl.ll_lang="ceb"#sl.ll_title in (select REPLACE(cp1.page_title,'_', ' ') 
                       #from cebwiki_p.page cp1 LEFT JOIN cebwiki_p.langlinks cl
    	/*ON cl.ll_from = cp1.page_id where cp1.page_namespace = 0 and cp1.page_is_redirect = 0)*/
                     )
group by page_title
/*SELECT page_title#CONCAT("Category:",sp.page_title),spp.pp_value
	FROM svwiki_p.page sp
	LEFT JOIN svwiki_p.langlinks sl
    	ON sl.ll_from = sp.page_id
join svwiki_p.categorylinks sc on sc.cl_from = sp.page_id
	LEFT JOIN (SELECT * FROM svwiki_p.page_props WHERE pp_propname = 'wikibase_item') AS spp
		ON spp.pp_page = sp.page_id
JOIN (SELECT * FROM cebwiki_p.page cp 
      LEFT JOIN (SELECT * FROM cebwiki_p.page_props WHERE pp_propname = 'wikibase_item') AS cpp
ON cpp.pp_page = cp.page_id
join cebwiki_p.categorylinks cc on cp.page_id=cc.cl_from 
      WHERE cp.page_namespace = 0 and cp.page_is_redirect = 0 and cpp.pp_value is NULL) AS ceb
		ON ceb.page_title = sp.page_title and sl.ll_title = REPLACE(cp.page_title,'_', ' ')
where sc.cl_to = cc.cl_to and */
SQL

Checking query status...
