Untitled query #87264

SQL

SELECT 
    CASE 
        WHEN rev_timestamp >= DATE_SUB(CURRENT_DATE, INTERVAL 3 MONTH) THEN 'Last 3 months'
        WHEN rev_timestamp >= DATE_SUB(CURRENT_DATE, INTERVAL 6 MONTH) THEN 'Last 6 months'
        WHEN rev_timestamp >= DATE_SUB(CURRENT_DATE, INTERVAL 12 MONTH) THEN 'Last 12 months'
        ELSE 'Last 24 months'
    END AS time_period,
    COUNT(rev_id) AS edit_count
FROM revision
JOIN page ON page.page_id = revision.rev_page
WHERE 
    page.page_title = 'రచ్చబండ'
    AND page.page_namespace = 4
    AND rev_timestamp >= DATE_SUB(CURRENT_DATE, INTERVAL 24 MONTH)
GROUP BY time_period
ORDER BY time_period;
SQL

Checking query status...
