AfDs created by an NPP reviewer or administrator in the past week

SQL

SELECT	articleC.cl_to as cat, count(*) as c, article.page_title as draft
FROM	page AS article
join	categorylinks as articleC on articleC.cl_from=article.page_id
WHERE	article.page_is_redirect=0
		AND	article.page_namespace=118
        and article.page_title in
        (SELECT	article.page_title as draft
          FROM	page AS article
          join	categorylinks as articleC on articleC.cl_from=article.page_id
          WHERE	article.page_is_redirect=0
          AND	article.page_namespace=118
          and (articleC.cl_to like "Content_moved_from_mainspace_to_draftspace_from_%_2023")
        )
     and articleC.cl_to not in ('All_content_moved_from_mainspace_to_draftspace', 'Declined_draft_pages_submitted_for_review_by_an_IP',
                                'Draft_articles', 'Webarchive_template_wayback_links','Unsubmitted_draft_pages_created_by_an_IP',
                                'Infobox_mapframe_without_OSM_relation_ID_on_Wikidata'	)
     and articleC.cl_to not like ('%_AfC_%')
     and articleC.cl_to not like ('Content_moved_from_mainspace_to_draftspace_from_%_%')
     and articleC.cl_to not like ('Draft_articles_on_%')
     and articleC.cl_to not like ('AfC_submissions_%')
     and articleC.cl_to not like ('CS1_%')
     and articleC.cl_to not like ('Drafts_about_%')
     and articleC.cl_to not like ('Pages_with_%')
     and articleC.cl_to not like ('Pages_using_%')
     and articleC.cl_to not like ('Articles_using_%')
     and articleC.cl_to not like ('%draft%')
     and articleC.cl_to not like ('%Draft%')
     
group by cat
order by c desc
limit 20;
SQL

Checking query status...
