50 Editors on Punjabi Wikipedia (2019–2024)

SQL

SELECT 
    YEAR(user_registration) AS year,
    user_id,
    user_name,
    user_editcount,
    CASE
    	WHEN up_property = 'gender' THEN up_value
        ELSE 'unknown'
    END AS gender
FROM 
    user
LEFT JOIN 
    user_properties 
    ON user_id = up_user
WHERE 
    user_editcount >= 100 
    AND LOWER(CAST(user_name AS CHAR)) NOT LIKE '%bot%' 
    AND user_name NOT LIKE 'MediaWiki message delivery' 
    AND YEAR(user_registration) BETWEEN 2019 AND 2024
GROUP BY 
    user_editcount,gender, YEAR(user_registration)
ORDER BY 
    YEAR(user_registration), user_editcount DESC
LIMIT 50;

SQL

Checking query status...