activity_of_bureaucrats

SQL

SELECT DISTINCT cl_to, COUNT(cl_from) as editcount
  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 NOT (
    		   cl_to LIKE "%rticle%"
    		OR cl_to LIKE "%ages%"
    		OR cl_to LIKE "%All%"
    		OR cl_to LIKE "%using%"
    		OR cl_to LIKE "%Good"
    		OR cl_to LIKE "%Wikipedia%"
    		OR cl_to LIKE "%missing%"
    		OR cl_to LIKE "%with%"
    		OR cl_to LIKE "%anguage%"
    		OR cl_to LIKE "%template%"
    		OR cl_to LIKE "%box%"
    		OR cl_to LIKE "%stub%"
    		OR cl_to LIKE "%Use%"
    		OR cl_to LIKE "%dmy%"
    		OR cl_to LIKE "%ikidata%"
    		OR cl_to LIKE "%CS1%"
    		OR cl_to LIKE "%list%"
    		OR cl_to LIKE "%image%"
    		OR cl_to LIKE "%mdy%"
    		OR cl_to LIKE "%TOC%"
    		OR cl_to LIKE "%mdy%"
    		OR cl_to LIKE "%ategory%"
    		OR cl_to LIKE "%edirect%"
    		OR cl_to LIKE "%Cite%"
    		OR cl_to LIKE "%link%"
    		OR cl_to LIKE "%need%"
    		OR cl_to LIKE "%Engvar%"
    		OR cl_to LIKE "%ommon%"
    	)
  GROUP BY cl_to
  ORDER BY COUNT(cl_from) DESC
  LIMIT 5;
SQL

Checking query status...
