Untitled query #87258

SQL

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

Checking query status...
