Active editors of punjabi wiki

This query is marked as a draft This query has been published by Tulspal.

SQL

SELECT YEAR(rev_timestamp) AS year,user_name, COUNT(DISTINCT rev_actor) AS editors
FROM revision
JOIN user 
    ON rev_actor = user_id
JOIN 
    user_properties
    ON user_id = up_user
WHERE
    rev_timestamp LIKE '2019%'
    AND user_name IS NOT NULL 
GROUP BY YEAR(rev_timestamp),editors
LIMIT 20;

By running queries you agree to the Cloud Services Terms of Use and you irrevocably agree to release your SQL under CC0 License.

Submit Query Stop Query

All SQL code is licensed under CC0 License.

SQL

Checking query status...