Fork of
Suspicious user talk page moves
by Pppery
This query is marked as a draft
This query has been published
by Belteshassar.
SQL
AخA
select log_id,log_timestamp,(select actor_name from actor where log_actor=actor_id) as "user",
log_title,log_params,(select comment_text from comment where comment_id=log_comment_id) as "summary"
from logging where log_type="move" and log_namespace=2 and log_params like "%4::target%" and log_title not like "%/%"
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.