CSD G8 editnotices

SQL

-- select distinct substring_index(page_title, '/', 2) from page
-- where page_title like 'Editnotices/%' and page_namespace = 10

select p1.page_title from page p1
-- left join page p2 on p2.page_namespace = 0 and p2.page_title = regexp_replace(p1.page_title, '^Editnotices/Page/', '')
/*
and regexp_replace(p1.page_title, '^Editnotices/Page/', '') = concat(CASE p2.page_namespace
                    WHEN    0 THEN ''                   WHEN    1 THEN 'Talk:'
                    WHEN    2 THEN 'User:'              WHEN    3 THEN 'User_talk:'
                    WHEN    4 THEN 'Wikipedia:'         WHEN    5 THEN 'Wikipedia_talk:'
                    WHEN    6 THEN 'File:'              WHEN    7 THEN 'File_talk:'
                    WHEN    8 THEN 'MediaWiki:'         WHEN    9 THEN 'MediaWiki_talk:'
                    WHEN   10 THEN 'Template:'          WHEN   11 THEN 'Template_talk:'
                    WHEN   12 THEN 'Help:'              WHEN   13 THEN 'Help_talk:'
                    WHEN   14 THEN 'Category:'          WHEN   15 THEN 'Category_talk:'
                    WHEN  100 THEN 'Portal:'            WHEN  101 THEN 'Portal_talk:'
                    WHEN  108 THEN 'Book:'              WHEN  109 THEN 'Book_talk:'
                    WHEN  118 THEN 'Draft:'             WHEN  119 THEN 'Draft_talk:'
                    WHEN  446 THEN 'Education_Program:' WHEN  447 THEN 'Education_Program_talk:'
                    WHEN  710 THEN 'TimedText:'         WHEN  711 THEN 'TimedText_talk:'
                    WHEN  828 THEN 'Module:'            WHEN  829 THEN 'Module_talk:'
                    WHEN 2300 THEN 'Gadget:'            WHEN 2301 THEN 'Gadget_talk:'
                    WHEN 2302 THEN 'Gadget_definition:' WHEN 2303 THEN 'Gadget_definition_talk:'
                  END, p2.page_title)
*/
where p1.page_title like 'Editnotices/Page/%' and p1.page_namespace = 10 -- and p2.page_id is null
and (regexp_replace(p1.page_title, '^Editnotices/Page/', '') not in (
       select p2.page_title from page p2 where p2.page_namespace = 0
     )
     or regexp_replace(p1.page_title, '^Editnotices/Page/Category:', '') not in (
       select p2.page_title from page p2 where p2.page_namespace = 14
     )
     or regexp_replace(p1.page_title, '^Editnotices/Page/Help:', '') not in (
       select p2.page_title from page p2 where p2.page_namespace = 12
     )
    )
SQL

Checking query status...
