Archived extensions with subpages needing cleanup

SQL

use mediawikiwiki_p;
select page_title from categorylinks join page on page_id=cl_from where cl_to in ("Archived_extensions","Deleted_extensions_with_security_vulnerabilities")
and exists (select 1 from page subpage where subpage.page_namespace = page.page_namespace
            and subpage.page_title like concat(page.page_title,"/%") and not exists
              	(select 1 from categorylinks where cl_from = subpage.page_id 
                 and cl_to in ("Archived_extensions",
                               concat("Archived_extensions",right(subpage.page_title,3)), /* Two-letter translations */
                               concat("Archived_extensions",right(subpage.page_title,4)), /* Three-letter translations */
                               concat("Archived_extensions",right(subpage.page_title,6)), /* Things like pt-br */
                               "Archived_extensions/de-formal",
                               "Deleted_extensions_with_security_vulnerabilities") /* Since RPED is wierd */
                )
            and subpage.page_is_redirect=0
            and subpage.page_len > 0
           )
SQL

Checking query status...
