Sysop logs by user

SQL

WITH latest_logs AS (
    SELECT 
        log_type, 
        log_action,
        log_id,
        log_timestamp,
        log_title,
        ROW_NUMBER() OVER (PARTITION BY log_type, log_action ORDER BY log_id DESC) AS row_num
    FROM logging
    JOIN actor ON logging.log_actor = actor.actor_id
    WHERE 
        log_type NOT IN ('newusers', 'thank', 'upload', 'create', 'review', 'move', 'spamblacklist', 'pagetranslation', 'translationreview')
        AND actor.actor_name = 'WikiBayer' 
       AND log_action NOT IN ('autopromote', 'move_prot')
),
log_count AS (
    SELECT 
        log_type, 
        log_action,
        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_action
)
SELECT 
    l.log_type,
    l.log_action,
    l.log_timestamp,
    l.log_title,
    l.log_id,
    lc.total_count
FROM latest_logs l
JOIN log_count lc ON l.log_type = lc.log_type AND l.log_action = lc.log_action
WHERE l.row_num = 1
ORDER BY l.log_type, l.log_action, l.log_timestamp DESC;
SQL

Checking query status...
