Suspicious user talk page moves - Quarry

This query is marked as a draft This query has been published by Pppery.

SQL

SELECT (SELECT COUNT(*) from logging_userindex l2 
	WHERE l2.log_timestamp >= l1.log_timestamp and l2.log_timestamp < (l1.log_timestamp+1000000) and l2.log_actor=l1.log_actor
        and l2.log_type="newusers") as creation_count, 
actor_user, actor_name from logging l1 join actor on log_actor=actor_id 
where l1.log_timestamp > "20190601000000" and l1.log_type="newusers" limit 10;

AخA
 
SELECT (SELECT COUNT(*) from logging_userindex l2     WHERE l2.log_timestamp >= l1.log_timestamp and l2.log_timestamp < (l1.log_timestamp+1000000) and l2.log_actor=l1.log_actor        and l2.log_type="newusers") as creation_count, actor_user, actor_name from logging l1 join actor on log_actor=actor_id where l1.log_timestamp > "20190601000000" and l1.log_type="newusers" limit 10;   

By running queries you agree to the Cloud Services Terms of Use and you irrevocably agree to release your SQL under CC0 License.

Submit Query Stop Query

All SQL code is licensed under CC0 License.

Checking query status...