Archived extensions with help

Fork of Archived extensions with subpages needing cleanup by Pppery

This query is marked as a draft This query has been published by Pppery.

SQL

use mediawikiwiki_p;
select page_title from categorylinks join page on page_id=cl_from where cl_to="Archived_extensions"
and exists (select 1 from page subpage where subpage.page_namespace = 12
            and (subpage.page_title like concat(page.page_title,"%") 
             	or subpage.page_title like concat("Extension:",page.page_title,"%")) 
            and subpage.page_is_redirect=0
            and subpage.page_len > 0
            and not exists (select 1 from categorylinks cc where cc.cl_from=subpage.page_id and cc.cl_to in ("Archived_extensions","Pages_kept_for_historical_interest"))
           )

SQL

Checking query status...