no wd en - Quarry

SQL

USE enwiki_p;
SELECT cl_to, COUNT(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 page_namespace = 0 AND page_is_redirect = 0
AND ll_title IS NULL
AND pp_value is NULL
group BY cl_to
having COUNT(page_title) > 10;
/*
SELECT user_name, articles
	FROM user
	LEFT JOIN (SELECT *, COUNT(*) AS articles FROM revision JOIN page ON page_id = rev_page
	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 NULL
AND ll_title IS NULL
AND page_namespace = 0 and rev_parent_id = 0 AND page_is_redirect = 0 GROUP BY rev_user) AS created
		ON created.rev_user = user.user_id
WHERE articles > 10
ORDER BY articles DESC
limit 400;
*/
SQL

Checking query status...
