Untitled query #67242

SQL

SELECT actor_name, count(log_actor)
from logging
join actor on logging.log_actor = actor.actor_id
join user_groups on actor_user = ug_user and ug_group = 'sysop'
and logging.log_type in ('abusefilter', 'block', 'delete', 'import', 'managetags', 'protect', 'rights', 'spamblacklist', 'merge')
group by logging.log_actor

union all

SELECT actor_name, count(log_actor)
from logging
join actor on logging.log_actor = actor.actor_id
join user_former_groups on actor_user = ufg_user and ufg_group = 'sysop'
and logging.log_type in ('abusefilter', 'block', 'delete', 'import', 'managetags', 'protect', 'rights', 'spamblacklist', 'merge')
group by logging.log_actor

order by count(log_actor) desc
SQL

Checking query status...
