Sysop logs by user

SQL

SELECT 
    log.log_type,
    log.log_subtype,
    log.log_action,
    log.log_timestamp,
    log.log_title,
    log.log_id,
    log_count.total_count
FROM (
    SELECT 
        log_type, 
        log_subtype, 
        MAX(log_id) AS max_log_id
    FROM logging
    JOIN actor ON logging.log_actor = actor.actor_id
    WHERE 
        log_type NOT IN ('newusers', 'upload', 'create')
        AND actor.actor_name = 'WikiBayer' 
    GROUP BY log_type, log_subtype
) AS latest_logs
JOIN logging AS log
    ON log.log_type = latest_logs.log_type
    AND log.log_subtype = latest_logs.log_subtype
    AND log.log_id = latest_logs.max_log_id
JOIN (
    SELECT 
        log_type, 
        log_subtype, 
        COUNT(*) AS total_count
    FROM logging
    JOIN actor ON logging.log_actor = actor.actor_id
    WHERE actor.actor_name = 'WikiBayer'
    GROUP BY log_type, log_subtype
) AS log_count
    ON log.log_type = log_count.log_type
    AND log.log_subtype = log_count.log_subtype
ORDER BY log.log_type, log.log_subtype, log.log_timestamp DESC;
SQL

Checking query status...
