Fikwiki reverts 2020

SQL

use fiwiki_p;
select 
 	actor_name, 
    pages, 
    edits, 
    (undo_c+rollback_c+flaggedrevs_undo) as reverts, 
    undo_c, 
    rollback_c, 
    flaggedrevs_undo, 
    flaggedrevs_review, 
    blocks, 
    abusefilteredits 
from (
  select 
  	page_namespace, 
	count(distinct(rev_id)) as edits, 
	sum(ctd_name="mw-undo") as undo_c, 
  	sum(ctd_name="mw-rollback") as rollback_c, 
	sum(comment_text LIKE "%Hylättiin viim%") as flaggedrevs_undo,
	count(distinct(page_id)) as pages, 
	floor(rev_timestamp/10000000000) as year, 
	actor_name, 
	r_actor_c as flaggedrevs_review,
  	b_actor_c as blocks,
  	abusefilteredits
from 
  	page, 
	revision_userindex 
	LEFT JOIN change_tag ON ct_rev_id=rev_id
	LEFT JOIN change_tag_def ON ctd_id=ct_tag_id,
	actor_revision 
	LEFT JOIN ( 
      select 
      	actor_id as r_actor_id, 
      	count(distinct(log_id)) as r_actor_c 
      from 
      	logging_userindex, 
      	actor_logging
      where 
      	log_actor=actor_id 
      	and log_action IN ('approve', 'approve2', 'approve-i', 'approve-i2') 
      	and log_type="review" 
      	and log_timestamp > 20200024044443 
      	and actor_name!="SeulojaBot" 
      group by actor_name order by r_actor_c desc limit 500
    ) AS reviews ON r_actor_id=actor_id 
    LEFT JOIN ( 
      select 
      	actor_id as b_actor_id, 
      	count(distinct(log_id)) as b_actor_c 
      from 
      	logging_userindex, 
      	actor_logging 
      where 
      	log_actor=actor_id 
      	and log_action="block" 
      	and log_type="block" 
      	and log_timestamp > 20200024044443 
      group by actor_name 
      order by b_actor_c desc limit 100
    ) as blocks ON b_actor_id=actor_id 
    LEFT JOIN (
      select 
      	sum(1) as abusefilteredits, 
      	afh_user 
      from 
      	abuse_filter_history 
      where 
      	afh_timestamp>20200024044443 
      group by afh_user_text
    ) as afh ON afh_user=actor_user, 
  	comment_revision 
  where 
  	rev_comment_id=comment_id 
  	AND page_id=rev_page 
  	and rev_actor = actor_id 
  	and rev_timestamp>20200024044443 
  	and (actor_name not like "%Bot" AND actor_name not LIKE "%bot") 
  	and page_namespace=0 
  group by year,actor_name
) as t order by reverts desc limit 100
SQL

Checking query status...
