Articles w/title matching regex w/template

SQL

SELECT REPLACE(page_title, '_', ' ') AS title, lt_title AS 'template'
FROM page
JOIN templatelinks on tl_from = page_id
JOIN linktarget ON lt_id = tl_target_id
WHERE page_namespace = 0
  AND page_is_redirect = 0
  AND LOWER(CONVERT(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 ('Chembox', 'Infobox_drug');

AخA
 
SELECT REPLACE(page_title, '_', ' ') AS title, lt_title AS 'template'FROM pageJOIN templatelinks on tl_from = page_idJOIN linktarget ON lt_id = tl_target_idWHERE page_namespace = 0  AND page_is_redirect = 0  AND LOWER(CONVERT(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 ('Chembox', 'Infobox_drug');

SQL

Checking query status...