Toggle navigation
Home
New Query
Recent Queries
Discuss
Database tables
Database names
MediaWiki
Wikibase
Replicas browser and optimizer
Login
History
Fork
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)
.
Toggle Highlighting
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) >= '20201012' and substring(revactor_timestamp,1,8) <= '20201018' 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) >= '20201012' and substring(revactor_timestamp,1,8) <= '20201018' 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) >= '20201012' and substring(revactor_timestamp,1,8) <= '20201018' 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) >= '20201012' and substring(revactor_timestamp,1,8) <= '20201018' 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) >= '20201012' and substring(revactor_timestamp,1,8) <= '20201018' 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) >= '20201012' and substring(revactor_timestamp,1,8) <= '20201018' 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) >= '20201012' and substring(revactor_timestamp,1,8) <= '20201018' 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) >= '20201012' and substring(revactor_timestamp,1,8) <= '20201018' 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) >= '20201012' and substring(revactor_timestamp,1,8) <= '20201018' 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) >= '20201012' and substring(revactor_timestamp,1,8) <= '20201018' 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) >= '20201012' and substring(revactor_timestamp,1,8) <= '20201018' 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) >= '20201012' and substring(revactor_timestamp,1,8) <= '20201018' 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) >= '20201012' and substring(revactor_timestamp,1,8) <= '20201018' 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) >= '20201012' and substring(revactor_timestamp,1,8) <= '20201018' 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) >= '20201012' and substring(revactor_timestamp,1,8) <= '20201018' 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) >= '20201012' and substring(revactor_timestamp,1,8) <= '20201018' 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) >= '20201012' and substring(revactor_timestamp,1,8) <= '20201018' 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) >= '20201012' and substring(revactor_timestamp,1,8) <= '20201018' 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) >= '20201012' and substring(revactor_timestamp,1,8) <= '20201018' 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) >= '20201012' and substring(revactor_timestamp,1,8) <= '20201018' 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) >= '20201012' and substring(revactor_timestamp,1,8) <= '20201018' 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) >= '20201012' and substring(revactor_timestamp,1,8) <= '20201018' 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) >= '20201012' and substring(revactor_timestamp,1,8) <= '20201018' 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) >= '20201012' and substring(revactor_timestamp,1,8) <= '20201018' 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) >= '20201012' and substring(revactor_timestamp,1,8) <= '20201018' 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) >= '20201012' and substring(revactor_timestamp,1,8) <= '20201018' 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) >= '20201012' and substring(revactor_timestamp,1,8) <= '20201018' 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) >= '20201012' and substring(revactor_timestamp,1,8) <= '20201018' 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) >= '20201012' and substring(revactor_timestamp,1,8) <= '20201018' 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) >= '20201012' and substring(revactor_timestamp,1,8) <= '20201018' 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) >= '20201012' and substring(revactor_timestamp,1,8) <= '20201018' 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) >= '20201012' and substring(revactor_timestamp,1,8) <= '20201018' 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) >= '20201012' and substring(revactor_timestamp,1,8) <= '20201018' 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) >= '20201012' and substring(revactor_timestamp,1,8) <= '20201018' 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) >= '20201012' and substring(revactor_timestamp,1,8) <= '20201018' 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) >= '20201012' and substring(revactor_timestamp,1,8) <= '20201018' 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) >= '20201012' and substring(revactor_timestamp,1,8) <= '20201018' 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) >= '20201012' and substring(revactor_timestamp,1,8) <= '20201018' 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) >= '20201012' and substring(revactor_timestamp,1,8) <= '20201018' 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) >= '20201012' and substring(revactor_timestamp,1,8) <= '20201018' 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) >= '20201012' and substring(revactor_timestamp,1,8) <= '20201018' 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) >= '20201012' and substring(revactor_timestamp,1,8) <= '20201018' 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) >= '20201012' and substring(revactor_timestamp,1,8) <= '20201018' 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) >= '20201012' and substring(revactor_timestamp,1,8) <= '20201018' ) 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
.
Checking query status...