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
A smart kitten
.
Toggle Highlighting
SQL
select * from logging_userindex inner join page on page_title like CONCAT(log_title, "/%") where log_actor = "12084" /* TheSandBot */ and log_namespace = 1 /* Talk namespace */ and log_timestamp between '20190606061817' and '20190606061819' /* catch edits made during task 3 - [[WP:Bots/Requests for approval/TheSandBot 3]] */ /*and ( select count(*) from page where page_namespace = 1 and page_is_redirect = 0 and page_title like CONCAT(log_title, "/%") limit 1 ) = 1*/ /* at least one non-redirect subpage under the pre-move name */ limit 1;
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...