User Engagement on రచ్చబండ Page Over Time: 3, 6, 12, and 24 Months

SQL

SELECT 
    COUNT(DISTINCT actor_name) AS user_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
    JOIN actor ON actor_id = rev_actor
WHERE 
    page_title = 'రచ్చబండ'
    AND page_namespace = 4  -- Adjust this to the correct namespace if needed.
    AND rev_timestamp >= DATE_FORMAT(NOW() - INTERVAL 24 MONTH, '%Y%m%d%H%i%s')
GROUP BY 
    period;

SQL

Checking query status...