Editnotices for nonexistent articles [enwiki]

Fork of Editnotices for redirected articles [enwiki] by Tamzin

This query is marked as a draft This query has been published by Tamzin.

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 EXISTS (SELECT *
                FROM page subject
                WHERE subject.page_namespace = 0
                AND subject.page_title = REPLACE(editnotice.page_title, "Editnotices/Page/", "") 
                LIMIT 1)
AND REPLACE(editnotice.page_title, "Editnotices/Page/", "") NOT RLIKE "^Talk|(User|Wikipedia|File|MediaWiki|Template|Help|Category|Portal|Draft|TimedText|Module|Gadget( definition)?)( talk)?"

SQL

Checking query status...