knwikisource page quality edits by year/month

SQL

SELECT 
	YEAR(rev_timestamp) AS year,
	MONTHNAME(rev_timestamp) AS month,
    COUNT(*) AS total_rev_count,
    SUM( IF ( ctd_name = 'proofreadpage-quality0', 1, null ) ) AS quality_0,
    SUM( IF ( ctd_name = 'proofreadpage-quality1', 1, null ) ) AS not_proofread,
    SUM( IF ( ctd_name = 'proofreadpage-quality2', 1, null ) ) AS quality_2,
    SUM( IF ( ctd_name = 'proofreadpage-quality3', 1, null ) ) AS quality_3,
    SUM( IF ( ctd_name = 'proofreadpage-quality4', 1, null ) ) AS quality_4
FROM change_tag_def
	JOIN change_tag ON ( ctd_id = ct_tag_id )
    JOIN revision ON ( ct_rev_id=rev_id )
WHERE ctd_name LIKE 'proofreadpage-quality%'
GROUP BY YEAR(rev_timestamp), MONTH(rev_timestamp)
;
SQL

Checking query status...
