Fork of
Suspicious user talk page moves
by Pppery
This query is marked as a draft
This query has been published
by CX Zoom.
SQL
AخA
select log_id, log_timestamp,
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_actor="34841508" and log_params not like "%User talk:%"
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.