Editnotices for nonexistent articles [enwiki]

SQL

SELECT page_title, CONCAT("https://en.wikipedia.org/wiki/Template:", page_title) AS $link
FROM page editnotice
WHERE editnotice.page_namespace = 10
AND editnotice.page_is_redirect = 0
AND editnotice.page_title LIKE "Editnotices/Page/%"
AND NOT (SELECT *
         FROM page subject
         WHERE subject.page_namespace = 0
         AND subject.page_title = REPLACE(editnotice.page_title, "Editnotices/Page/", "")
         LIMIT 1)

AخA
 
SELECT page_title, CONCAT("https://en.wikipedia.org/wiki/Template:", page_title) AS $linkFROM page editnoticeWHERE editnotice.page_namespace = 10AND editnotice.page_is_redirect = 0AND editnotice.page_title LIKE "Editnotices/Page/%"AND NOT (SELECT *         FROM page subject         WHERE subject.page_namespace = 0         AND subject.page_title = REPLACE(editnotice.page_title, "Editnotices/Page/", "")         LIMIT 1)

SQL

Checking query status...