Toggle navigation
Home
New Query
Recent Queries
Discuss
Database tables
Database names
MediaWiki
Wikibase
Replicas browser and optimizer
Login
History
Fork
This query is marked as a draft
This query has been published
by
Pppery
.
Toggle Highlighting
SQL
select actor_name, rev_id, comment_text from change_tag join change_tag_def on ctd_id=ct_tag_id join revision on rev_id=ct_rev_id join actor_revision on actor_id=rev_actor join user on user_id = actor_user join comment_revision on comment_id=rev_comment_id where ctd_name="mw-rollback" and not exists (select 1 from user_groups where ug_user=user_id and (ug_group = "rollbacker" || ug_group="sysop")) and not exists (select 1 from user_former_groups where ufg_user=user_id and (ufg_group = "rollbacker" || ufg_group="sysop")) -- uses of huggle are by definition in the context of counter-vandalism efforts and not (comment_text like "%[[WP:HG%") and rev_timestamp > "20190801101010";
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...