Test query - Quarry

SQL

use commonswiki_p;
select count(log_id) as Counter, actor_name as Bureaucrat
from (select count(log_id) as Counter1, actor_name as Bureaucrat1
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%"
union
select count(log_id) as Counter2, actor_name as Bureaucrat2
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%"
union
select count(log_id) as Counter3, actor_name as Bureaucrat3
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%"
union
select count(log_id) as Counter4, actor_name as Bureaucrat4
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%"
union
select count(log_id) as Counter5, actor_name as Bureaucrat5
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%"
union
select count(log_id) as Counter6, actor_name as Bureaucrat6
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 actor_name;
SQL

Checking query status...
