Test query - Quarry

SQL

use commonswiki_p;
select count(log_id) as Count, actor_name as Bureaucrat
from logging
join actor
on actor_id = log_actor
join user_groups
on actor_user = ug_user
where log_type = "rights"
and log_action = "rights"
and log_timestamp between "20190101000000" and "20191116000000"
and ug_group = "bureaucrat"
and log_params like "%sysop%"
group by actor_name
union
select count(log_id) as Count, actor_name as Bureaucrat
from logging
join actor
on actor_id = log_actor
join user_groups
on actor_user = ug_user
where log_type = "rights"
and log_action = "rights"
and log_timestamp between "20190101000000" and "20191116000000"
and ug_group = "bureaucrat"
and log_params like "%admin%"
group by actor_name
union
select count(log_id) as Count, actor_name as Bureaucrat
from logging
join actor
on actor_id = log_actor
join user_groups
on actor_user = ug_user
where log_type = "rights"
and log_action = "rights"
and log_timestamp between "20190101000000" and "20191116000000"
and ug_group = "bureaucrat"
and log_params like "%gwtoolset%"
group by actor_name
union
select count(log_id) as Count, actor_name as Bureaucrat
from logging
join actor
on actor_id = log_actor
join user_groups
on actor_user = ug_user
where log_type = "rights"
and log_action = "rights"
and log_timestamp between "20190101000000" and "20191116000000"
and ug_group = "bureaucrat"
and log_params like "%bot%"
group by actor_name
union
select count(log_id) as Count, actor_name as Bureaucrat
from logging
join actor
on actor_id = log_actor
join user_groups
on actor_user = ug_user
where log_type = "rights"
and log_action = "rights"
and log_timestamp between "20190101000000" and "20191116000000"
and ug_group = "bureaucrat"
and log_params like "%accountcreator%"
group by actor_name
union
select count(log_id) as Count, actor_name as Bureaucrat
from logging
join actor
on actor_id = log_actor
join user_groups
on actor_user = ug_user
where log_type = "rights"
and log_action = "rights"
and log_timestamp between "20190101000000" and "20191116000000"
and ug_group = "bureaucrat"
and log_params like "%bureaucrat%"
group by Bureaucrat
order by Bureaucrat
group by Bureaucrat;
SQL

Checking query status...
