Untitled query #85405

SQL

SELECT
    log_actor,
    DATE_FORMAT(STR_TO_DATE(log_timestamp, '%Y%m%d%H%i%s'), '%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
    logging_userindex
WHERE 
    log_timestamp > '20041223000000' AND log_timestamp < '20241224000000'
GROUP BY
    log_actor,
    DATE_FORMAT(STR_TO_DATE(log_timestamp, '%Y%m%d%H%i%s'), '%Y-%m-%d %H:00:00')
ORDER BY
    log_actor, timestamp;
SQL

Checking query status...
