AfC accepts in 2021 (WP:AfC/recent) *

Fork of AfC accepts in 6 months (WP:AfC/recent) by KylieTastic

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

This is changes to 'Wikipedia:Articles for creation/recent'
NOTE! Quick and dirty as this does not count any extra edits to that page other than the normal AFCH post

SQL

select actor_name as editor, COUNT(rev_actor) as accepts,
       (select COUNT(rc_id) from recentchanges_userindex where rc_actor = actor_id ) as recent_edits 
from revision_userindex
left join actor on rev_actor = actor_id
where (rev_page = 21063913)
  and ( YEAR(rev_timestamp) = 2021 )
group by rev_actor 
order by accepts desc, recent_edits;

select COUNT(rev_actor) as total accepts
from revision_userindex
where (rev_page = 21063913)
  and ( YEAR(rev_timestamp) = 2021 )
order by accepts desc, recent_edits;

SQL

Checking query status...