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
SunAfterRain
.
Toggle Highlighting
SQL
select rc_title, actor_name as `rc_user`, rc_timestamp, rc_this_oldid as `rc_oldid`, (rc_new_len - rc_old_len) as `rc_len_diff`, comment_text as `rc_comment` from recentchanges left join actor on rc_actor = actor_id left join page on rc_cur_id = page_id left join comment on rc_comment_id = comment_id left join change_tag on rc_id = ct_rc_id left join change_tag_def on ct_tag_id = ctd_id where (actor_name = "InternetArchiveBot" or ctd_name = "OAuth CID: 1804") and rc_type = 0 and rc_this_oldid = page_latest and rc_new_len - rc_old_len > 2000;
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...