"Langcode icon" templates

SQL

USE enwiki_p;
SELECT page_title, page_is_redirect
FROM page
INNER JOIN revision ON rev_page = page_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%"
/*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...
