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

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');

AخA
 
SELECT REPLACE(a.page_title, '_', ' ') AS title, lt_title AS 'template'FROM page AS aJOIN page AS t ON t.page_namespace = 1 AND t.page_title = a.page_titleJOIN templatelinks on tl_from = t.page_idJOIN linktarget ON lt_id = tl_target_idWHERE 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...