fawiki patrols

SQL

use fawiki_p;
select count(*)
from logging
where log_type='patrol'
and log_timestamp between '20190501000000' and '20190502000000'
and log_namespace=0
union
select count(*)
from logging
where log_type='patrol'
and log_timestamp between '20190502000000' and '20190503000000'
and log_namespace=0
union
select count(*)
from logging
where log_type='patrol'
and log_timestamp between '20190503000000' and '20190504000000'
and log_namespace=0
union
select count(*)
from logging
where log_type='patrol'
and log_timestamp between '20190504000000' and '20190505000000'
and log_namespace=0
union
select count(*)
from logging
where log_type='patrol'
and log_timestamp between '20190505000000' and '20190506000000'
and log_namespace=0
union
select count(*)
from logging
where log_type='patrol'
and log_timestamp between '20190501000000' and '20190502000000'
union
select count(*)
from logging
where log_type='patrol'
and log_timestamp between '20190502000000' and '20190503000000'
union
select count(*)
from logging
where log_type='patrol'
and log_timestamp between '20190503000000' and '20190504000000'
union
select count(*)
from logging
where log_type='patrol'
and log_timestamp between '20190504000000' and '20190505000000'
union
select count(*)
from logging
where log_type='patrol'
and log_timestamp between '20190505000000' and '20190506000000';
SQL

Checking query status...
