Fork of
Suspicious user talk page moves
by Pppery
This query is marked as a draft
This query has been published
by EqJjgOa8rVvsRmZL.
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 like "2023%"
order by log_timestamp desc limit 100;
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.