Untitled query #85405

SQL

SELECT log_actor,  FROM logging
WHERE log_timestamp >= 20041223000000  AND log_timestamp < 20041224000000
GROUP BY log_actor
LIMIT 100;

SELECT
    log_actor,
    DATE_FORMAT(log_timestamp, '%Y-%m-%d %H:00:00') AS timestamp,  -- Grouping by hour
    SUM(CASE WHEN log_type = 'delete' and log_action = 'delete' THEN 1 ELSE 0 END) AS deletions,
    SUM(CASE WHEN log_type = 'delete' and log_action = 'restore' THEN 1 ELSE 0 END) AS restorations,
FROM
    your_table_name  -- Replace with your actual table name
GROUP BY
    log_actor,
    DATE_FORMAT(log_timestamp, '%Y-%m-%d %H:00:00')
ORDER BY
    log_actor, timestamp;
SQL

Checking query status...
