Reply Tool usage (ar, fr, hu, nl): feb, 2020

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-reply'  
and substring(revactor_timestamp,1,8) >= '20200218' and substring(revactor_timestamp,1,8) <='20200223'
  
union all
  
select ct.ct_id, ct.ct_rev_id, actor_user, actor_name
from frwiki_p.change_tag ct
inner join frwiki_p.revision_actor_temp rat
on ct.ct_rev_id = rat.revactor_rev
inner join frwiki_p.actor act
on rat.revactor_actor = act.actor_id
inner join frwiki_p.change_tag_def
on ct_tag_id = ctd_id
where ctd_name = 'discussiontools-reply'  
and substring(revactor_timestamp,1,8) >= '20200218' and substring(revactor_timestamp,1,8) <='20200223'
  
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-reply'  
and substring(revactor_timestamp,1,8) >= '20200218' and substring(revactor_timestamp,1,8) <='20200223'
  
union all
  
select ct.ct_id, ct.ct_rev_id, actor_user, actor_name
from nlwiki_p.change_tag ct
inner join nlwiki_p.revision_actor_temp rat
on ct.ct_rev_id = rat.revactor_rev
inner join nlwiki_p.actor act
on rat.revactor_actor = act.actor_id
inner join nlwiki_p.change_tag_def
on ct_tag_id = ctd_id
where ctd_name = 'discussiontools-reply'  
and substring(revactor_timestamp,1,8) >= '20200218' and substring(revactor_timestamp,1,8) <='20200223'
  
 
) a
group by actor_name
order by count(*) desc
SQL

Checking query status...
