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
94rain
.
Toggle Highlighting
SQL
/* Moves without redirect */ use zhwiki_p; set @by_date = "20220101010101"; select log_id, log_type, log_action, user_name, user_editcount, user_registration, log_params from logging join actor_logging on actor_id = log_actor join user on user_id = actor_user join comment_logging on comment_id = log_comment_id where log_type="move" and log_params like '%"5::noredir";s:1:"1%' and log_timestamp > @by_date and comment_text not like "%自动移动页面%" and log_namespace != 828 and not (log_namespace=10 and log_title like '%.css') and not exists (select 1 from user_groups where ug_user = actor_user and (ug_group="patroller" || ug_group="rollbacker" || ug_group="autoreviewer" || ug_group="sysop" || ug_group="bot"));
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...