Untitled query #6829

SQL

USE enwiki_p;
SELECT cl_to, count(cl_to)
FROM categorylinks

WHERE count(cl_to) < 100 
AND 
cl_from IN
		(SELECT ll_from
		FROM langlinks
	
	WHERE ll_lang = "ar")
	AND
	cl_to NOT IN
		
(SELECT page_title 
		FROM langlinks JOIN page
		
	ON page_id = ll_from        
		WHERE ll_lang = "ar"
	
		AND page_namespace = 14)
	AND
	cl_from NOT IN
	
	(SELECT cl_from
		FROM categorylinks
		
WHERE cl_to = "Hidden_categories" OR cl_to = "Loanwords" OR  cl_to = "Container_categories" OR cl_to = "Tracking_categories")



ORDER BY count(cl_to) DESC
LIMIT 100;
SQL

Checking query status...
