New Discussion Tool usage (ar, cs, hu)

SQL

select actor_name, count(*) as total
from (
	
select ct.ct_id, ct.ct_rev_id, actor_user, actor_name
from arwiki_p.change_tag ct
inner join arwiki_p.revision_actor_temp rat
on ct.ct_rev_id = rat.revactor_rev
inner join arwiki_p.actor act
on rat.revactor_actor = act.actor_id
inner join arwiki_p.change_tag_def
on ct_tag_id = ctd_id
where ctd_name = 'discussiontools-newtopic'
and substring(revactor_timestamp,1,8) >= '20210101' 
  
union all
  
select ct.ct_id, ct.ct_rev_id, actor_user, actor_name
from cswiki_p.change_tag ct
inner join cswiki_p.revision_actor_temp rat
on ct.ct_rev_id = rat.revactor_rev
inner join cswiki_p.actor act
on rat.revactor_actor = act.actor_id
inner join cswiki_p.change_tag_def
on ct_tag_id = ctd_id
where ctd_name = 'discussiontools-newtopic'
and substring(revactor_timestamp,1,8) >= '20210101' 
  
union all
  
select ct.ct_id, ct.ct_rev_id, actor_user, actor_name
from huwiki_p.change_tag ct
inner join huwiki_p.revision_actor_temp rat
on ct.ct_rev_id = rat.revactor_rev
inner join huwiki_p.actor act
on rat.revactor_actor = act.actor_id
inner join huwiki_p.change_tag_def
on ct_tag_id = ctd_id
where ctd_name = 'discussiontools-newtopic'
and substring(revactor_timestamp,1,8) >= '20210101'   
  
 
) a
group by actor_name
order by count(*) desc
SQL

Checking query status...
