Redirects with subpages

SQL

select concat("Extension:",page_title) from page where page_is_redirect=1 and page_namespace=102
and exists (select 1 from page subpage where subpage.page_namespace = page.page_namespace
            and subpage.page_title like concat(replace(page.page_title,"_","|_"),"/%") escape "|" and not exists
              	(select 1 from categorylinks where cl_from = subpage.page_id and cl_to="Archived_extensions")
             and not exists /* Translated archived extensions */
            	(select 1 from categorylinks where cl_from = subpage.page_id and cl_to=concat("Archived_extensions",right(subpage.page_title,3)))
            and subpage.page_is_redirect=0
            and subpage.page_len > 0
           )
 and page_title != "FileImporter/Data" -- Deliberate workaround for translate extension
SQL

Checking query status...
