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/*

    LEFT JOIN langlinks

        ON ll_from = page_id*/

where page_is_redirect = 0 AND page_namespace = 0

and pp_value is not NULL

#AND ll_title IS NULL

group BY cl_to

having pages > 50

order by pages desc;/**//*

USE barwiki_p;

SELECT page_title

    FROM page

        join categorylinks on cl_from=page_id

    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 pp_value is not NULL

AND ll_title IS NULL

AND page_namespace = 0 and cl_to = "Begriffsklärung"

group BY page_title

ORDER BY page_title;*/