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

SQL

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" and (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") > 1 limit 1;
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
All SQL code is licensed under CC0 License.

Checking query status...