"Langcode icon" templates

SQL

USE enwiki_p;
SELECT
  user_name
  COUNT(DISTINCT page_title) AS "Pages edited"
FROM (
SELECT
  page_title,
  CASE
    WHEN rev_actor THEN rev_actor
    WHEN revactor_actor THEN revactor_actor
    ELSE NULL
  END AS rev_user_id
FROM page
INNER JOIN revision ON rev_page = page_id
LEFT JOIN revision_actor_temp ON revactor_rev = rev_id
WHERE
  page_namespace = 10
  AND (
    page_title RLIKE "^[A-Za-z]{2,3}\_icon"
    OR page_title LIKE "Zh-%icon"
    OR page_title LIKE "Seto_icon%"
  )
  AND page_title NOT LIKE "Air_icon%"
  AND page_title NOT LIKE "Bio_icon%"
  AND page_title NOT LIKE "Bus_icon%"
  AND page_title NOT LIKE "DYK_icon_link%"
  AND page_title NOT LIKE "GA_icon%"
  AND page_title NOT LIKE "GAR_icon%"
  AND page_title NOT LIKE "HSU_icon%"
  AND page_title NOT LIKE "MTS_icon%"
  AND page_title NOT LIKE "WiR_icon%"
  AND page_title NOT LIKE "Top_icon%"
GROUP BY rev_user_id
) AS innertable1
LEFT JOIN user ON user_id = rev_user_id
/*For some reason, joining templatelinks was too slow:

INNER JOIN templatelinks ON tl_from = page_id

...

WHERE tl_namespace = 10
  AND tl_title = "Link_language"*/
SQL

Checking query status...
