no ceb IW by cat

SQL

USE svwiki_p;
SELECT cl_to, COUNT(page_title) as pages
	FROM page 
    join categorylinks on cl_from=page_id/*
	left JOIN (SELECT * FROM page_props WHERE pp_propname = 'wikibase_item') AS props
		ON pp_page = page_id*/
WHERE page_id in (SELECT DISTINCT cl_from from categorylinks WHERE cl_to like "Robotskapade_%")
AND page_namespace = 0 AND page_is_redirect = 0
#AND pp_value is NULL
and page_id not in (select m.ll_from from langlinks m where m.ll_lang="ceb")
group BY cl_to
having pages > 10
order by pages desc;
/*
SELECT page_title#cl_to, COUNT(page_title) as Npages, GROUP_CONCAT(page_title)
	FROM page 
    join categorylinks on cl_from=page_id
WHERE cl_to = "Robotskapade_Rumänienförgreningar"
AND page_namespace = 0 AND page_is_redirect = 0
#AND pp_value is NULL
and page_id not in (select m.ll_from from langlinks m where m.ll_lang="ceb")
*/
SQL

Checking query status...
