Untitled query #33878

SQL

USE arwiki_p;
    select user_name,
    (select count(*) from logging where log_user = user_id
    and log_action = 'delete' 
    AND log_timestamp BETWEEN 20180902000000 AND 20190302000000) as "delete",
   	(select count(*) from logging where log_user = user_id
    and log_action = 'restore'
    AND log_timestamp BETWEEN 20180902000000 AND 20190302000000) as 'restore',
	(select count(*) from logging where log_user = user_id
    and log_action = 'block'
    AND log_timestamp BETWEEN 20180902000000 AND 20190302000000) as 'block',
    (select count(*) from logging where log_user = user_id
    and log_action = 'reblock'
    AND log_timestamp BETWEEN 20180902000000 AND 20190302000000) as 'reblock',
    (select count(*) from logging where log_user = user_id
    and log_action = 'unblock'
    AND log_timestamp BETWEEN 20180902000000 AND 20190302000000) as 'unblock',
    (select count(*) from logging where log_user = user_id
    and log_action = 'protect'
    AND log_timestamp BETWEEN 20180902000000 AND 20190302000000) as 'protect',
    (select count(*) from logging where log_user = user_id
    and log_action = 'unprotect'
    AND log_timestamp BETWEEN 20180902000000 AND 20190302000000) as 'unprotect'
    from user
    inner join user_groups 
    on ug_user = user_id
    where ug_group = 'sysop';
SQL

Checking query status...
