Fork of
Suspicious user talk page moves
by Pppery
This query is marked as a draft
This query has been published
by Achim55.
SQL
AخA
select log_id,log_timestamp,concat("User talk:",log_title),log_params
from logging_logindex
where log_type="move" and log_namespace=3 and log_params not like "%User talk:%" and log_title not like "%/%"
and log_timestamp > 20220000000000
order by log_timestamp desc
limit 200;
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.