Active Reply Tool users (weekly)

Fork of Reply Tool usage/user (Phase 0-3 wikis) by PPelberg (WMF)
This query is marked as a draft This query has been published by PPelberg (WMF).
SQL

select actor_name, count(*) as total
from (
	
select ct.ct_id, ct.ct_rev_id, actor_user, actor_name
from enwiki_p.change_tag ct
inner join enwiki_p.revision_actor_temp rat
on ct.ct_rev_id = rat.revactor_rev
inner join enwiki_p.actor act
on rat.revactor_actor = act.actor_id
inner join enwiki_p.change_tag_def
on ct_tag_id = ctd_id
where ctd_name = 'discussiontools-reply'
and substring(revactor_timestamp,1,8) >= '20200921' and substring(revactor_timestamp,1,8) <= '20200927'

union all
	
select ct.ct_id, ct.ct_rev_id, actor_user, actor_name
from amwiki_p.change_tag ct
inner join amwiki_p.revision_actor_temp rat
on ct.ct_rev_id = rat.revactor_rev
inner join amwiki_p.actor act
on rat.revactor_actor = act.actor_id
inner join amwiki_p.change_tag_def
on ct_tag_id = ctd_id
where ctd_name = 'discussiontools-reply'
and substring(revactor_timestamp,1,8) >= '20200921' and substring(revactor_timestamp,1,8) <= '20200927'

union all
	
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) >= '20200921' and substring(revactor_timestamp,1,8) <= '20200927'
  
union all
	
select ct.ct_id, ct.ct_rev_id, actor_user, actor_name
from aswiki_p.change_tag ct
inner join aswiki_p.revision_actor_temp rat
on ct.ct_rev_id = rat.revactor_rev
inner join aswiki_p.actor act
on rat.revactor_actor = act.actor_id
inner join aswiki_p.change_tag_def
on ct_tag_id = ctd_id
where ctd_name = 'discussiontools-reply'
and substring(revactor_timestamp,1,8) >= '20200921' and substring(revactor_timestamp,1,8) <= '20200927'

union all
  
select ct.ct_id, ct.ct_rev_id, actor_user, actor_name
from bhwiki_p.change_tag ct
inner join bhwiki_p.revision_actor_temp rat
on ct.ct_rev_id = rat.revactor_rev
inner join bhwiki_p.actor act
on rat.revactor_actor = act.actor_id
inner join bhwiki_p.change_tag_def
on ct_tag_id = ctd_id
where ctd_name = 'discussiontools-reply'
and substring(revactor_timestamp,1,8) >= '20200921' and substring(revactor_timestamp,1,8) <= '20200927'
  
union all
  
select ct.ct_id, ct.ct_rev_id, actor_user, actor_name
from cawiki_p.change_tag ct
inner join cawiki_p.revision_actor_temp rat
on ct.ct_rev_id = rat.revactor_rev
inner join cawiki_p.actor act
on rat.revactor_actor = act.actor_id
inner join cawiki_p.change_tag_def
on ct_tag_id = ctd_id
where ctd_name = 'discussiontools-reply'
and substring(revactor_timestamp,1,8) >= '20200921' and substring(revactor_timestamp,1,8) <= '20200927'
  
union all
  
select ct.ct_id, ct.ct_rev_id, actor_user, actor_name
from ckbwiki_p.change_tag ct
inner join ckbwiki_p.revision_actor_temp rat
on ct.ct_rev_id = rat.revactor_rev
inner join ckbwiki_p.actor act
on rat.revactor_actor = act.actor_id
inner join ckbwiki_p.change_tag_def
on ct_tag_id = ctd_id
where ctd_name = 'discussiontools-reply'
and substring(revactor_timestamp,1,8) >= '20200921' and substring(revactor_timestamp,1,8) <= '20200927'
  
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-reply'
and substring(revactor_timestamp,1,8) >= '20200921' and substring(revactor_timestamp,1,8) <= '20200927'

union all
	
select ct.ct_id, ct.ct_rev_id, actor_user, actor_name
from eswiki_p.change_tag ct
inner join eswiki_p.revision_actor_temp rat
on ct.ct_rev_id = rat.revactor_rev
inner join eswiki_p.actor act
on rat.revactor_actor = act.actor_id
inner join eswiki_p.change_tag_def
on ct_tag_id = ctd_id
where ctd_name = 'discussiontools-reply'
and substring(revactor_timestamp,1,8) >= '20200921' and substring(revactor_timestamp,1,8) <= '20200927'

union all
	
select ct.ct_id, ct.ct_rev_id, actor_user, actor_name
from euwiki_p.change_tag ct
inner join euwiki_p.revision_actor_temp rat
on ct.ct_rev_id = rat.revactor_rev
inner join euwiki_p.actor act
on rat.revactor_actor = act.actor_id
inner join euwiki_p.change_tag_def
on ct_tag_id = ctd_id
where ctd_name = 'discussiontools-reply'
and substring(revactor_timestamp,1,8) >= '20200921' and substring(revactor_timestamp,1,8) <= '20200927' 
  
union all
	
select ct.ct_id, ct.ct_rev_id, actor_user, actor_name
from fawiki_p.change_tag ct
inner join fawiki_p.revision_actor_temp rat
on ct.ct_rev_id = rat.revactor_rev
inner join fawiki_p.actor act
on rat.revactor_actor = act.actor_id
inner join fawiki_p.change_tag_def
on ct_tag_id = ctd_id
where ctd_name = 'discussiontools-reply'
and substring(revactor_timestamp,1,8) >= '20200921' and substring(revactor_timestamp,1,8) <= '20200927'
  
union all
	
select ct.ct_id, ct.ct_rev_id, actor_user, actor_name
from fiwiki_p.change_tag ct
inner join fiwiki_p.revision_actor_temp rat
on ct.ct_rev_id = rat.revactor_rev
inner join fiwiki_p.actor act
on rat.revactor_actor = act.actor_id
inner join fiwiki_p.change_tag_def
on ct_tag_id = ctd_id
where ctd_name = 'discussiontools-reply'
and substring(revactor_timestamp,1,8) >= '20200921' and substring(revactor_timestamp,1,8) <= '20200927'   
  
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) >= '20200921' and substring(revactor_timestamp,1,8) <= '20200927' 

union all  
  
select ct.ct_id, ct.ct_rev_id, actor_user, actor_name
from hewiki_p.change_tag ct
inner join hewiki_p.revision_actor_temp rat
on ct.ct_rev_id = rat.revactor_rev
inner join hewiki_p.actor act
on rat.revactor_actor = act.actor_id
inner join hewiki_p.change_tag_def
on ct_tag_id = ctd_id
where ctd_name = 'discussiontools-reply'
and substring(revactor_timestamp,1,8) >= '20200921' and substring(revactor_timestamp,1,8) <= '20200927'      
  
union all
	
select ct.ct_id, ct.ct_rev_id, actor_user, actor_name
from hiwiki_p.change_tag ct
inner join hiwiki_p.revision_actor_temp rat
on ct.ct_rev_id = rat.revactor_rev
inner join hiwiki_p.actor act
on rat.revactor_actor = act.actor_id
inner join hiwiki_p.change_tag_def
on ct_tag_id = ctd_id
where ctd_name = 'discussiontools-reply'
and substring(revactor_timestamp,1,8) >= '20200921' and substring(revactor_timestamp,1,8) <= '20200927'
  
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) >= '20200921' and substring(revactor_timestamp,1,8) <= '20200927'
  
union all
	
select ct.ct_id, ct.ct_rev_id, actor_user, actor_name
from hywiki_p.change_tag ct
inner join hywiki_p.revision_actor_temp rat
on ct.ct_rev_id = rat.revactor_rev
inner join hywiki_p.actor act
on rat.revactor_actor = act.actor_id
inner join hywiki_p.change_tag_def
on ct_tag_id = ctd_id
where ctd_name = 'discussiontools-reply'
and substring(revactor_timestamp,1,8) >= '20200921' and substring(revactor_timestamp,1,8) <= '20200927'

union all
	
select ct.ct_id, ct.ct_rev_id, actor_user, actor_name
from iswiki_p.change_tag ct
inner join iswiki_p.revision_actor_temp rat
on ct.ct_rev_id = rat.revactor_rev
inner join iswiki_p.actor act
on rat.revactor_actor = act.actor_id
inner join iswiki_p.change_tag_def
on ct_tag_id = ctd_id
where ctd_name = 'discussiontools-reply'
and substring(revactor_timestamp,1,8) >= '20200921' and substring(revactor_timestamp,1,8) <= '20200927'  

union all
	
select ct.ct_id, ct.ct_rev_id, actor_user, actor_name
from itwiki_p.change_tag ct
inner join itwiki_p.revision_actor_temp rat
on ct.ct_rev_id = rat.revactor_rev
inner join itwiki_p.actor act
on rat.revactor_actor = act.actor_id
inner join itwiki_p.change_tag_def
on ct_tag_id = ctd_id
where ctd_name = 'discussiontools-reply'
and substring(revactor_timestamp,1,8) >= '20200921' and substring(revactor_timestamp,1,8) <= '20200927'   
  
union all
  
select ct.ct_id, ct.ct_rev_id, actor_user, actor_name
from jawiki_p.change_tag ct
inner join jawiki_p.revision_actor_temp rat
on ct.ct_rev_id = rat.revactor_rev
inner join jawiki_p.actor act
on rat.revactor_actor = act.actor_id
inner join jawiki_p.change_tag_def
on ct_tag_id = ctd_id
where ctd_name = 'discussiontools-reply'
and substring(revactor_timestamp,1,8) >= '20200921' and substring(revactor_timestamp,1,8) <= '20200927'
  
union all
  
select ct.ct_id, ct.ct_rev_id, actor_user, actor_name
from kawiki_p.change_tag ct
inner join kawiki_p.revision_actor_temp rat
on ct.ct_rev_id = rat.revactor_rev
inner join kawiki_p.actor act
on rat.revactor_actor = act.actor_id
inner join kawiki_p.change_tag_def
on ct_tag_id = ctd_id
where ctd_name = 'discussiontools-reply'
and substring(revactor_timestamp,1,8) >= '20200921' and substring(revactor_timestamp,1,8) <= '20200927'
  
union all  
  
select ct.ct_id, ct.ct_rev_id, actor_user, actor_name
from kowiki_p.change_tag ct
inner join kowiki_p.revision_actor_temp rat
on ct.ct_rev_id = rat.revactor_rev
inner join kowiki_p.actor act
on rat.revactor_actor = act.actor_id
inner join kowiki_p.change_tag_def
on ct_tag_id = ctd_id
where ctd_name = 'discussiontools-reply'
and substring(revactor_timestamp,1,8) >= '20200921' and substring(revactor_timestamp,1,8) <= '20200927' 

union all  
  
select ct.ct_id, ct.ct_rev_id, actor_user, actor_name
from ltwiki_p.change_tag ct
inner join ltwiki_p.revision_actor_temp rat
on ct.ct_rev_id = rat.revactor_rev
inner join ltwiki_p.actor act
on rat.revactor_actor = act.actor_id
inner join ltwiki_p.change_tag_def
on ct_tag_id = ctd_id
where ctd_name = 'discussiontools-reply'
and substring(revactor_timestamp,1,8) >= '20200921' and substring(revactor_timestamp,1,8) <= '20200927' 
  
union all  
  
select ct.ct_id, ct.ct_rev_id, actor_user, actor_name
from maiwiki_p.change_tag ct
inner join maiwiki_p.revision_actor_temp rat
on ct.ct_rev_id = rat.revactor_rev
inner join maiwiki_p.actor act
on rat.revactor_actor = act.actor_id
inner join maiwiki_p.change_tag_def
on ct_tag_id = ctd_id
where ctd_name = 'discussiontools-reply'
and substring(revactor_timestamp,1,8) >= '20200921' and substring(revactor_timestamp,1,8) <= '20200927'   

union all  
  
select ct.ct_id, ct.ct_rev_id, actor_user, actor_name
from mnwiki_p.change_tag ct
inner join mnwiki_p.revision_actor_temp rat
on ct.ct_rev_id = rat.revactor_rev
inner join mnwiki_p.actor act
on rat.revactor_actor = act.actor_id
inner join mnwiki_p.change_tag_def
on ct_tag_id = ctd_id
where ctd_name = 'discussiontools-reply'
and substring(revactor_timestamp,1,8) >= '20200921' and substring(revactor_timestamp,1,8) <= '20200927'   

union all  
  
select ct.ct_id, ct.ct_rev_id, actor_user, actor_name
from mrwiki_p.change_tag ct
inner join mrwiki_p.revision_actor_temp rat
on ct.ct_rev_id = rat.revactor_rev
inner join mrwiki_p.actor act
on rat.revactor_actor = act.actor_id
inner join mrwiki_p.change_tag_def
on ct_tag_id = ctd_id
where ctd_name = 'discussiontools-reply'
and substring(revactor_timestamp,1,8) >= '20200921' and substring(revactor_timestamp,1,8) <= '20200927'  

union all  
  
select ct.ct_id, ct.ct_rev_id, actor_user, actor_name
from mywiki_p.change_tag ct
inner join mywiki_p.revision_actor_temp rat
on ct.ct_rev_id = rat.revactor_rev
inner join mywiki_p.actor act
on rat.revactor_actor = act.actor_id
inner join mywiki_p.change_tag_def
on ct_tag_id = ctd_id
where ctd_name = 'discussiontools-reply'
and substring(revactor_timestamp,1,8) >= '20200921' and substring(revactor_timestamp,1,8) <= '20200927'   
  
union all  
  
select ct.ct_id, ct.ct_rev_id, actor_user, actor_name
from newiki_p.change_tag ct
inner join newiki_p.revision_actor_temp rat
on ct.ct_rev_id = rat.revactor_rev
inner join newiki_p.actor act
on rat.revactor_actor = act.actor_id
inner join newiki_p.change_tag_def
on ct_tag_id = ctd_id
where ctd_name = 'discussiontools-reply'
and substring(revactor_timestamp,1,8) >= '20200921' and substring(revactor_timestamp,1,8) <= '20200927'   
  
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) >= '20200921' and substring(revactor_timestamp,1,8) <= '20200927'

union all
  
select ct.ct_id, ct.ct_rev_id, actor_user, actor_name
from nowiki_p.change_tag ct
inner join nowiki_p.revision_actor_temp rat
on ct.ct_rev_id = rat.revactor_rev
inner join nowiki_p.actor act
on rat.revactor_actor = act.actor_id
inner join nowiki_p.change_tag_def
on ct_tag_id = ctd_id
where ctd_name = 'discussiontools-reply'
and substring(revactor_timestamp,1,8) >= '20200921' and substring(revactor_timestamp,1,8) <= '20200927' 

union all
  
select ct.ct_id, ct.ct_rev_id, actor_user, actor_name
from nqowiki_p.change_tag ct
inner join nqowiki_p.revision_actor_temp rat
on ct.ct_rev_id = rat.revactor_rev
inner join nqowiki_p.actor act
on rat.revactor_actor = act.actor_id
inner join nqowiki_p.change_tag_def
on ct_tag_id = ctd_id
where ctd_name = 'discussiontools-reply'
and substring(revactor_timestamp,1,8) >= '20200921' and substring(revactor_timestamp,1,8) <= '20200927'

union all
  
select ct.ct_id, ct.ct_rev_id, actor_user, actor_name
from pawiki_p.change_tag ct
inner join pawiki_p.revision_actor_temp rat
on ct.ct_rev_id = rat.revactor_rev
inner join pawiki_p.actor act
on rat.revactor_actor = act.actor_id
inner join pawiki_p.change_tag_def
on ct_tag_id = ctd_id
where ctd_name = 'discussiontools-reply'
and substring(revactor_timestamp,1,8) >= '20200921' and substring(revactor_timestamp,1,8) <= '20200927'   

union all
  
select ct.ct_id, ct.ct_rev_id, actor_user, actor_name
from plwiki_p.change_tag ct
inner join plwiki_p.revision_actor_temp rat
on ct.ct_rev_id = rat.revactor_rev
inner join plwiki_p.actor act
on rat.revactor_actor = act.actor_id
inner join plwiki_p.change_tag_def
on ct_tag_id = ctd_id
where ctd_name = 'discussiontools-reply'
and substring(revactor_timestamp,1,8) >= '20200921' and substring(revactor_timestamp,1,8) <= '20200927'
  
union all
  
select ct.ct_id, ct.ct_rev_id, actor_user, actor_name
from ptwiki_p.change_tag ct
inner join ptwiki_p.revision_actor_temp rat
on ct.ct_rev_id = rat.revactor_rev
inner join ptwiki_p.actor act
on rat.revactor_actor = act.actor_id
inner join ptwiki_p.change_tag_def
on ct_tag_id = ctd_id
where ctd_name = 'discussiontools-reply'
and substring(revactor_timestamp,1,8) >= '20200921' and substring(revactor_timestamp,1,8) <= '20200927' 
  
union all
  
select ct.ct_id, ct.ct_rev_id, actor_user, actor_name
from satwiki_p.change_tag ct
inner join satwiki_p.revision_actor_temp rat
on ct.ct_rev_id = rat.revactor_rev
inner join satwiki_p.actor act
on rat.revactor_actor = act.actor_id
inner join satwiki_p.change_tag_def
on ct_tag_id = ctd_id
where ctd_name = 'discussiontools-reply'
and substring(revactor_timestamp,1,8) >= '20200921' and substring(revactor_timestamp,1,8) <= '20200927'
  
union all
  
select ct.ct_id, ct.ct_rev_id, actor_user, actor_name
from siwiki_p.change_tag ct
inner join siwiki_p.revision_actor_temp rat
on ct.ct_rev_id = rat.revactor_rev
inner join siwiki_p.actor act
on rat.revactor_actor = act.actor_id
inner join siwiki_p.change_tag_def
on ct_tag_id = ctd_id
where ctd_name = 'discussiontools-reply'
and substring(revactor_timestamp,1,8) >= '20200921' and substring(revactor_timestamp,1,8) <= '20200927'   
  
union all
  
select ct.ct_id, ct.ct_rev_id, actor_user, actor_name
from srwiki_p.change_tag ct
inner join srwiki_p.revision_actor_temp rat
on ct.ct_rev_id = rat.revactor_rev
inner join srwiki_p.actor act
on rat.revactor_actor = act.actor_id
inner join srwiki_p.change_tag_def
on ct_tag_id = ctd_id
where ctd_name = 'discussiontools-reply'
and substring(revactor_timestamp,1,8) >= '20200921' and substring(revactor_timestamp,1,8) <= '20200927'
  
union all
  
select ct.ct_id, ct.ct_rev_id, actor_user, actor_name
from svwiki_p.change_tag ct
inner join svwiki_p.revision_actor_temp rat
on ct.ct_rev_id = rat.revactor_rev
inner join svwiki_p.actor act
on rat.revactor_actor = act.actor_id
inner join svwiki_p.change_tag_def
on ct_tag_id = ctd_id
where ctd_name = 'discussiontools-reply'
and substring(revactor_timestamp,1,8) >= '20200921' and substring(revactor_timestamp,1,8) <= '20200927'  

union all
  
select ct.ct_id, ct.ct_rev_id, actor_user, actor_name
from tawiki_p.change_tag ct
inner join tawiki_p.revision_actor_temp rat
on ct.ct_rev_id = rat.revactor_rev
inner join tawiki_p.actor act
on rat.revactor_actor = act.actor_id
inner join tawiki_p.change_tag_def
on ct_tag_id = ctd_id
where ctd_name = 'discussiontools-reply'
and substring(revactor_timestamp,1,8) >= '20200921' and substring(revactor_timestamp,1,8) <= '20200927'   

union all
  
select ct.ct_id, ct.ct_rev_id, actor_user, actor_name
from thwiki_p.change_tag ct
inner join thwiki_p.revision_actor_temp rat
on ct.ct_rev_id = rat.revactor_rev
inner join thwiki_p.actor act
on rat.revactor_actor = act.actor_id
inner join thwiki_p.change_tag_def
on ct_tag_id = ctd_id
where ctd_name = 'discussiontools-reply'
and substring(revactor_timestamp,1,8) >= '20200921' and substring(revactor_timestamp,1,8) <= '20200927' 

union all
  
select ct.ct_id, ct.ct_rev_id, actor_user, actor_name
from trwiki_p.change_tag ct
inner join trwiki_p.revision_actor_temp rat
on ct.ct_rev_id = rat.revactor_rev
inner join trwiki_p.actor act
on rat.revactor_actor = act.actor_id
inner join trwiki_p.change_tag_def
on ct_tag_id = ctd_id
where ctd_name = 'discussiontools-reply'
and substring(revactor_timestamp,1,8) >= '20200921' and substring(revactor_timestamp,1,8) <= '20200927' 
  
union all
  
select ct.ct_id, ct.ct_rev_id, actor_user, actor_name
from ukwiki_p.change_tag ct
inner join ukwiki_p.revision_actor_temp rat
on ct.ct_rev_id = rat.revactor_rev
inner join ukwiki_p.actor act
on rat.revactor_actor = act.actor_id
inner join ukwiki_p.change_tag_def
on ct_tag_id = ctd_id
where ctd_name = 'discussiontools-reply'
and substring(revactor_timestamp,1,8) >= '20200921' and substring(revactor_timestamp,1,8) <= '20200927'  
  
union all
  
select ct.ct_id, ct.ct_rev_id, actor_user, actor_name
from viwiki_p.change_tag ct
inner join viwiki_p.revision_actor_temp rat
on ct.ct_rev_id = rat.revactor_rev
inner join viwiki_p.actor act
on rat.revactor_actor = act.actor_id
inner join viwiki_p.change_tag_def
on ct_tag_id = ctd_id
where ctd_name = 'discussiontools-reply'
and substring(revactor_timestamp,1,8) >= '20200921' and substring(revactor_timestamp,1,8) <= '20200927' 
  
union all
  
select ct.ct_id, ct.ct_rev_id, actor_user, actor_name
from zhwiki_p.change_tag ct
inner join zhwiki_p.revision_actor_temp rat
on ct.ct_rev_id = rat.revactor_rev
inner join zhwiki_p.actor act
on rat.revactor_actor = act.actor_id
inner join zhwiki_p.change_tag_def
on ct_tag_id = ctd_id
where ctd_name = 'discussiontools-reply'
and substring(revactor_timestamp,1,8) >= '20200921' and substring(revactor_timestamp,1,8) <= '20200927'
  
  
  
  
  
) a
group by actor_name
order by count(*) desc
By running queries you agree to the Cloud Services Terms of Use and you irrevocably agree to release your SQL under CC0 License.
Submit Query Stop Query
All SQL code is licensed under CC0 License.
SQL

Checking query status...
