ckb Admin Stats 2207

SQL

SELECT actor_name,
    SUM(IF( (log_type = 'delete'),1,0)) AS 'delete',
    SUM(IF( (log_type = 'protect'),1,0)) AS 'protect',
    SUM(IF( (log_type = 'block'),1,0)) AS 'block',
    SUM(IF( (log_type = 'merge'),1,0)) AS 'merge',
    SUM(IF( (log_type = 'rights'),1,0)) AS 'rights',
    SUM(IF( (log_type = 'contentmodel'),1,0)) AS 'contentmodel',
    SUM(IF( log_type IN ('contentmodel', 'rights', 'merge', 'block', 'protect', 'delete'),1,0)) AS 'total'
    FROM logging
    INNER JOIN actor ON logging.log_actor = actor.actor_id
    WHERE log_type IS NOT NULL
    AND log_action IS NOT NULL
    AND actor_name IN (SELECT user_name FROM user_groups INNER JOIN user ON user_id = ug_user WHERE ug_group = 'sysop')
    AND log_type IN ('block', 'delete', 'protect', 'rights', 'contentmodel', 'merge')
    AND log_action NOT IN ('delete_redir', 'autopromote', 'move_prot')
    AND ucase (actor_name) not like ucase ("%BOT") collate utf8_general_ci
    AND actor_name NOT IN (SELECT user_name FROM user_groups INNER JOIN user ON user_id = ug_user WHERE ug_group = 'bot')
    GROUP BY actor_name
    ORDER BY total DESC, actor_name ASC;
SQL

Checking query status...
