USE enwiki_p;

SELECT  cl_to, COUNT(cl_from)

FROM categorylinks

WHERE cl_from IN (

        SELECT DISTINCT ll_from

        FROM langlinks

        WHERE ll_lang = "ar"

        )

    AND cl_to NOT IN (

        SELECT DISTINCT page_title

        FROM langlinks

        LEFT JOIN page ON page_id = ll_from

        WHERE ll_lang = "ar"

            AND page_namespace = 14

        ) 

     AND cl_to NOT IN

       (SELECT DISTINCT page_title FROM page

       WHERE page_title LIKE "%rticle%"  

         OR  page_title LIKE "%ages%"

         OR  page_title LIKE "%All%"

         OR  page_title LIKE "%using%"

         OR  page_title LIKE "%Good"

         OR  page_title LIKE "%Wikipedia%"

         OR  page_title LIKE "%missing%"

         OR  page_title LIKE "%with%"

         OR  page_title LIKE "%anguage%"

         OR  page_title LIKE "%template%"

         OR  page_title LIKE "%box%"

         OR  page_title LIKE "%stub%"

         OR  page_title LIKE "%Use%"

         OR  page_title LIKE "%dmy%"

         OR  page_title LIKE "%ikidata%" 

         OR  page_title LIKE "%CS1%" 

         OR  page_title LIKE "%list%" 

         OR  page_title LIKE "%image%"         

         OR  page_title LIKE "%mdy%")        

GROUP BY cl_to

ORDER BY COUNT(cl_from) DESC

LIMIT 2000;