Untitled query #80968

SQL

select count(*) as '2023w1' from logging_userindex
where log_timestamp between '20230101000000' and '202430107235959' 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 '202430114235959' 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 '202430121235959' 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 '202430128235959' and log_type="block" and log_actor!=198977042 order by log_timestamp desc;*/
SQL

Checking query status...
