enwiki articles trancluding editnotices

SQL

SELECT sourcepage.page_title AS article,
  CONCAT(tl_namespace, ":", tl_title) AS editnotice,
  CONCAT("https://en.wikipedia.org/wiki/", sourcepage.page_title) AS link
FROM templatelinks
INNER JOIN page templatepage ON templatepage.page_title = tl_title
INNER JOIN page sourcepage ON sourcepage.page_id = tl_from
WHERE tl_from_namespace = 0
AND sourcepage.page_is_redirect = 0
AND tl_namespace = 10
AND EXISTS (
  SELECT 1
  FROM categorylinks
  WHERE cl_from = templatepage.page_id
  AND (
    cl_to = "Editnotice_templates"
    OR cl_to = "1RR-related_templates"
    OR cl_to = "Varieties_of_English_templates"
    OR cl_to = "Wikipedia_Did_you_know_editnotice_templates"
  )
  LIMIT 1
)
SQL

Checking query status...
