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="Content_moved_from_mainspace_to_draftspace_from_November_2023") )
group by cat
order by c
limit 10;

SQL

Checking query status...