Fork of Knwikisource Total number edits by ~aanzx
This query is marked as a draft This query has been published by Ranjithsiji.

SQL

​x
 
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 
    revision
    LEFT JOIN change_tag ON (rev_id = ct_rev_id)
    LEFT JOIN change_tag_def ON (ct_tag_id = ctd_id)
WHERE 
    ctd_name LIKE 'proofreadpage-quality%' OR ctd_name IS NULL
GROUP BY 
    YEAR(rev_timestamp), 
    MONTH(rev_timestamp)
ORDER BY
    YEAR(rev_timestamp), 
    MONTH(rev_timestamp);
​
By running queries you agree to the Cloud Services Terms of Use and you irrevocably agree to release your SQL under CC0 License.
Submit Query
All SQL code is licensed under CC0 License.

Checking query status...