Articles w/title matching regex w/template on talk:

Fork of Articles w/title matching regex in cat tree, w/path by Cryptic

This query is marked as a draft This query has been published by Cryptic.

Non-redirect mainspace pages containing a Greek letter name in Latin script (case-insensitive, distinct word) whose talk pages transclude {{WikiProject Chemistry}} or {{WikiProject Chemicals}}.

For [[WP:RAQ#Spelled out Latin characters in Chemistry articles]] circa 9 July 2023.

SQL

SELECT REPLACE(a.page_title, '_', ' ') AS title, lt_title AS 'template'
FROM page AS a
JOIN page AS t ON t.page_namespace = 1 AND t.page_title = a.page_title
JOIN templatelinks on tl_from = t.page_id
JOIN linktarget ON lt_id = tl_target_id
WHERE a.page_namespace = 0
  AND a.page_is_redirect = 0
  AND LOWER(CONVERT(a.page_title USING 'utf8')) RLIKE '(\\b|_)(alpha|beta|gamma|delta|epsilon|zeta|eta|theta|iota|kappa|lambda|mu|nu|xi|omicron|pi|rho|sigma|tau|upsilon|phi|chi|psi|omega)(\\b|_)'
  AND lt_namespace = 10 -- Template:
  AND lt_title IN ('WikiProject_Chemistry', 'WikiProject_Chemicals');

SQL

Checking query status...