enwiki articles trancluding editnotices

SQL

SELECT sourcepage.page_title, 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 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...