Edit Contributions of రచ్చబండ Participants Over Time: 3, 6, 12, and 24 Months

SQL

SELECT 
    COUNT(rev_id) AS edit_count,
    CASE
        WHEN rev_timestamp >= DATE_FORMAT(NOW() - INTERVAL 3 MONTH, '%Y%m%d%H%i%s') THEN 'Last 3 Months'
        WHEN rev_timestamp >= DATE_FORMAT(NOW() - INTERVAL 6 MONTH, '%Y%m%d%H%i%s') THEN 'Last 6 Months'
        WHEN rev_timestamp >= DATE_FORMAT(NOW() - INTERVAL 12 MONTH, '%Y%m%d%H%i%s') THEN 'Last 12 Months'
        WHEN rev_timestamp >= DATE_FORMAT(NOW() - INTERVAL 24 MONTH, '%Y%m%d%H%i%s') THEN 'Last 24 Months'
        ELSE 'Older'
    END AS period
FROM 
    revision
    JOIN page ON page_id = rev_page
WHERE 
    page_title = 'రచ్చబండ' -- Adjust this to the correct page_title according to language.
    AND page_namespace = 4 
    AND rev_timestamp >= DATE_FORMAT(NOW() - INTERVAL 24 MONTH, '%Y%m%d%H%i%s')
GROUP BY 
    period;

SQL

Checking query status...