"Langcode icon" templates

SQL

USE enwiki_p;
SELECT
  actor_name,
  rev_actor_id,
  num_pages_edited
FROM (
SELECT
  CASE
    WHEN rev_actor THEN rev_actor
    WHEN revactor_actor THEN revactor_actor
    ELSE NULL
  END AS rev_actor_id,
  COUNT(DISTINCT page_title) AS num_pages_edited
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_actor_id
) AS innertable1
LEFT JOIN actor ON actor_id = rev_actor_id
ORDER BY num_pages_edited DESC
/*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...
