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

Checking query status...
