articles_in_which_there_is_a_link_to_user_pages

SQL

SELECT  cl_to#, COUNT(cl_from) as editcount
  FROM categorylinks
  /*WHERE cl_from IN (
          SELECT DISTINCT ll_from
          FROM langlinks
          WHERE ll_lang = "ar"
          )*/
      WHERE cl_to 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 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 10;
SQL

Checking query status...
