USE enwiki_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_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 > 30

order by pages desc;