This query is marked as a draft This query has been published by Peter Bowman.

SQL

AخA
 
SELECT
    actor_name,
    COUNT(log_action) AS total,
    SUM(log_action = "approve-i") AS new,
    SUM(log_action = "approve") AS other,
    SUM(log_action = "unapprove") AS unapproved
FROM logging
    INNER JOIN actor ON actor_id = log_actor
WHERE
    log_type = "review" AND
    log_namespace = 0 AND
    log_action NOT LIKE "%%a" AND
    log_timestamp BETWEEN 20240602220000 AND 20240609220000
GROUP BY
    log_actor
ORDER BY
    total DESC,
    other DESC,
    new DESC
By running queries you agree to the Cloud Services Terms of Use and you irrevocably agree to release your SQL under CC0 License.
All SQL code is licensed under CC0 License.

Checking query status...