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 count(*) as '2023w3' from logging_userindex
where log_timestamp between '20230115000000' and '20230121235959' and log_type="block" and log_actor!=198977042 and not (log_actor=346314 and log_timestamp between '20230121000000' and '20230121235959') /* seems like the bot was on the main account for a bit here */ 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;
select count(*) as '2023w5' from logging_userindex
where log_timestamp between '20230129000000' and '20230204235959' and log_type="block" and log_actor!=198977042 order by log_timestamp desc;
select count(*) as '2023w6' from logging_userindex
where log_timestamp between '20230205000000' and '20230211235959' and log_type="block" and log_actor!=198977042 order by log_timestamp desc;
select count(*) as '2023w7' from logging_userindex
where log_timestamp between '20230212000000' and '20230218235959' and log_type="block" and log_actor!=198977042 order by log_timestamp desc;
select count(*) as '2023w8' from logging_userindex
where log_timestamp between '20230219000000' and '20230225235959' and log_type="block" and log_actor!=198977042 order by log_timestamp desc;
select count(*) as '2023w9' from logging_userindex
where log_timestamp between '20230226000000' and '20230304235959' and log_type="block" and log_actor!=198977042 order by log_timestamp desc;
select count(*) as '2023w10' from logging_userindex
where log_timestamp between '20230305000000' and '20230311235959' and log_type="block" and log_actor!=198977042 order by log_timestamp desc;
SQL

Checking query status...
