select

    actor_name,

    count(log_action) as total,

    sum(log_action like "%-i") as new,

    sum(log_action = "approve") as other,

    sum(log_action like "unapprove%") as unapproved

from logging

    inner join actor on actor_id = log_actor

where

    log_type = "review" and

    log_namespace = 0 and

    log_timestamp > date_sub(now(), interval 7 day) and

    log_action not like "%-a"

group by

    log_actor

order by

    total desc

limit 50;