SQL
AخA
select * from logging_userindex
where log_actor = "12084" /* TheSandBot */
and log_namespace = 1 /* Talk: */
and log_timestamp between '20190524000000' and '20190607000000' /* 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, "%")
) > 0 /* at least one non-redirect subpage under the pre-move name */
limit 5;
By running queries you agree to the Cloud Services Terms of Use and you irrevocably agree to release your SQL under CC0 License.
All SQL code is licensed under CC0 License.