SELECT CONCAT('Template:', p1.page_title)

FROM page p1

WHERE p1.page_namespace = 10  # template

AND p1.page_title LIKE 'Editnotices/Page/%'

# exclude editnotices with a colon since they are not in mainspace. for example, exclude Editnotice/Page/Category:Test

AND p1.page_title NOT LIKE '%:%'

AND NOT EXISTS (

    SELECT 1 

    FROM page p2

    WHERE p2.page_namespace = 0  # mainspace

    AND p2.page_title = SUBSTRING(p1.page_title, LENGTH('Editnotices/Page/') + 1)

)

ORDER BY p1.page_title ASC;