SQL
x
set @start_timestamp := 20240301000000;
set @end_timestamp := 20240401000000;
select
actor_name,
count(log_id) as creation_count
from logging
inner join page on page_id = log_page
inner join actor on actor_id = log_actor
where
log_type = "create" and
page_namespace = 0 and
log_timestamp >= @start_timestamp
and log_timestamp < @end_timestamp
group by
actor_name
with rollup;
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.