Untitled query #86408

SQL

WITH ActiveEditors AS (
    SELECT 
        u.user_id,
        u.user_name,
        up.up_value AS Gender,
        YEAR(u.user_registration) AS Year,
        MONTH(u.user_registration) AS Month,
        COUNT(CASE WHEN r.rev_id = 'article' THEN r.rev_id END) AS article_edits,
        COUNT(CASE WHEN r.rev_id = 'non-article' THEN r.rev_id END) AS non_article_edits
    FROM 
        user u
    LEFT JOIN 
        user_properties up ON up.up_user = u.user_id
    LEFT JOIN
        revision r ON r.rev_id = u.user_id
    WHERE 
        YEAR(r.rev_timestamp) BETWEEN 2019 AND 2024
        AND up.up_property = 'gender'
        AND up.up_value IN ('male', 'female') 
    GROUP BY 
        u.user_id, u.user_name, up.up_value, Year, Month
    HAVING 
        (article_edits + non_article_edits) >= 5 
)
SELECT 
    user_name,
    Gender,
    Year,
    Month,
    article_edits,
    non_article_edits
FROM 
    ActiveEditors
ORDER BY 
    Year, Month, user_name;
SQL

Checking query status...
