knwikisource proofreadathon edit count

SQL

USE knwikisource_p;
SELECT
CONCAT("# [[Special:Contributions/",actor_name,"]]") AS rev_user_text,
COUNT(actor_id) AS recent_user_editcount
/*user_editcount*/
FROM revision
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')
  AND rev_timestamp BETWEEN 20240701000000 AND 20241231235959
GROUP BY actor_id
ORDER BY recent_user_editcount DESC
/*proofread and validation*/
SELECT 
    YEAR(rev_timestamp) AS year,
    MONTHNAME(rev_timestamp) AS month,
    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)
WHERE 
    ctd_name LIKE 'proofreadpage-quality%'
LIMIT 100;
SQL

Checking query status...
