Untitled query #6829

SQL

USE enwiki_p;
SELECT cl_to, count(cl_to) FROM categorylinks
   WHERE 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"
       )     
   AND cl_to NOT IN		
      (SELECT page_title FROM page       
	   WHERE page_namespace = 14
       AND page_title LIKE "%articles%"
       OR  page_title LIKE "%containing%"
       OR  page_title LIKE "%missing%"
       OR  page_title LIKE "%language%"
       OR  page_title LIKE "%needing%"
       OR  page_title LIKE "Articles%"
       OR  page_title LIKE "All%"
       OR  page_title LIKE "%with%"
       )       
GROUP BY cl_to
ORDER BY count(cl_to) DESC
LIMIT 100;
SQL

Checking query status...
