SET SESSION TRANSACTION ISOLATION LEVEL READ UNCOMMITTED;

SELECT cl_to, COUNT(*) AS pages
  FROM page, categorylinks
 WHERE page_id = cl_from
   AND page_namespace = 2
   AND page_title NOT LIKE '%/%'
   AND NOT EXISTS (
       SELECT * FROM page AS cat, templatelinks
        WHERE cat.page_namespace = 14
          AND cat.page_title = cl_to
          AND tl_from = cat.page_id
          AND tl_namespace = 10
          AND (tl_title IN ('User_category', 'Sockpuppet_category', 'Wikipedia_category', 'Educat', 'UsersSpeak', 'User_language_subcategory', 'Userloc-2', 'Userbox') OR tl_title LIKE 'Usercat%')
       )
   AND cl_to NOT REGEXP '[Ww]iki|[Bb]ot|[Uu]ser|[Tt]ask.?[Ff]orce|[Pp]ossible|[Cc]andidates|IP_address|[Ll]icen[cs]e|[Ss]ockpuppet'
 GROUP BY cl_to
     ;