Untitled query #72489

SQL

SELECT 
    actor_name as "Creator",
    COUNT(*) AS "Year total", 
    SUM(CASE WHEN rev_timestamp LIKE '202301%' THEN 1 ELSE 0 END) AS "Jan", 
    SUM(CASE WHEN rev_timestamp LIKE '202302%' THEN 1 ELSE 0 END) AS "Feb", 
    SUM(CASE WHEN rev_timestamp LIKE '202303%' THEN 1 ELSE 0 END) AS "Mar", 
    SUM(CASE WHEN rev_timestamp LIKE '202304%' THEN 1 ELSE 0 END) AS "Apr", 
    SUM(CASE WHEN rev_timestamp LIKE '202305%' THEN 1 ELSE 0 END) AS "May", 
    SUM(CASE WHEN rev_timestamp LIKE '202306%' THEN 1 ELSE 0 END) AS "Jun", 
    SUM(CASE WHEN rev_timestamp LIKE '202307%' THEN 1 ELSE 0 END) AS "Jul", 
    SUM(CASE WHEN rev_timestamp LIKE '202308%' THEN 1 ELSE 0 END) AS "Aug",
    SUM(CASE WHEN rev_timestamp LIKE '202309%' THEN 1 ELSE 0 END) AS "Sep", 
    SUM(CASE WHEN rev_timestamp LIKE '202310%' THEN 1 ELSE 0 END) AS "Oct", 
    SUM(CASE WHEN rev_timestamp LIKE '202311%' THEN 1 ELSE 0 END) AS "Nov", 
    SUM(CASE WHEN rev_timestamp LIKE '202312%' THEN 1 ELSE 0 END) AS "Dec"
FROM revision
JOIN actor_revision ON actor_id = rev_actor
JOIN page ON page_id = rev_page
JOIN comment ON rev_comment_id = comment_id
LEFT JOIN change_tag ON rev_id = ct_rev_id 
    AND (ct_tag_id = 11 
         OR ct_tag_id = 64) #redirects created by autowikibrowser aren't tagged as redirects
WHERE rev_parent_id = 0
  AND page_namespace = 0
  AND ct_tag_id IS NULL
  AND rev_timestamp >= '2023'
  AND rev_timestamp < '2024'
  AND comment_text NOT LIKE "%(via [[WP:JWB]])"
GROUP BY actor_name
HAVING COUNT(*) >= 10
ORDER BY COUNT(*) DESC;
SQL

Checking query status...
