knwikisource proofread count

SQL

SELECT 
WHERE 
    ctd_name LIKE 'proofreadpage-quality%' AND
    rev_timestamp BETWEEN '2024-08-01 00:00:00' AND '2024-09-15 23:59:59'
    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,
    COUNT(*) AS total_rev_count  -- Total number of revisions
FROM 
    change_tag_def
    JOIN change_tag ON (ctd_id = ct_tag_id)
    JOIN revision ON (ct_rev_id = rev_id)
SQL

Checking query status...
