Untitled query #80968

SQL

-- select count(*) as '2023w1' from logging_userindex
-- where log_timestamp between '20230101000000' and '20230107235959' and log_type="block" and log_actor!=198977042 order by log_timestamp desc;
-- select count(*) as '2023w2' from logging_userindex
-- where log_timestamp between '20230108000000' and '20230114235959' and log_type="block" and log_actor!=198977042 order by log_timestamp desc;
select distinct actor_name /* count(*) as '2023w3' */ from logging_userindex inner join actor_logging on log_actor=actor_id
where log_timestamp between '20230115000000' and '20230121235959' and log_type="block" and log_actor!=198977042 order by log_timestamp desc;
-- select count(*) as '2023w4' from logging_userindex
-- where log_timestamp between '20230122000000' and '20230128235959' and log_type="block" and log_actor!=198977042 order by log_timestamp desc;
SQL

Checking query status...
