Untitled query #88590

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...
