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 between 20231002191000 and 20231009191000 and

    log_action not like "%a"

group by

    log_actor

order by

    total desc