select

    actor_name,

    count(log_action) as total,

    sum(log_action = "approve-i") as new,

    sum(log_action = "approve") as other,

    sum(log_action = "unapprove") as unapproved

from logging

    inner join actor on actor_id = log_actor

where

    log_type = "review" and

    log_namespace = 0 and

    log_action not like "%a" and

    log_timestamp between 20231025201754 and 20231101201754

group by

    log_actor

order by

    total desc,

    other desc,

    new desc