knwikisource proofread count

SQL

USE knwikisource_p;
SELECT
CONCAT("# [[Special:Contributions/",actor_name,"]]") AS rev_user_text,
COUNT(actor_id) AS recent_user_editcount
    SUM(IF(ctd_name = 'proofreadpage-quality0', 1, 0)) AS without_text,
    SUM(IF(ctd_name = 'proofreadpage-quality1', 1, 0)) AS not_proofread,
    SUM(IF(ctd_name = 'proofreadpage-quality2', 1, 0)) AS problematic,
    SUM(IF(ctd_name = 'proofreadpage-quality3', 1, 0)) AS proofread,
    SUM(IF(ctd_name = 'proofreadpage-quality4', 1, 0)) AS validated,
    SUM(IF(ct_name IS NOT NULL, 1, 0)) AS category_changes
FROM 
    revision
    LEFT JOIN change_tag ON (rev_id = ct_rev_id)
    LEFT JOIN change_tag_def ON (ct_tag_id = ctd_id)
    LEFT JOIN categorylinks ON (cl_from = rev_page AND cl_to = ct_name)
    JOIN actor ON rev_actor=actor_id
	JOIN page ON rev_page=page_id
WHERE actor_user IS NOT NULL
  AND page_namespace IN ('0','104', '106')
  rev_timestamp BETWEEN '2024-08-01 00:00:00' AND '2024-09-15 23:59:59'
GROUP BY 
    user
ORDER BY 
    total_edits DESC;
SQL

Checking query status...
