amy_rc added a comment.
Adding Lucas comments from mattermost discussion - As a database query
MariaDB [wikidatawiki]> SELECT rc_namespace, COUNT(DISTINCT rc_actor) AS
editors FROM recentchanges WHERE rc_namespace >= 0 GROUP BY rc_namespace ORDER
BY editors DESC;
result with registered users only
MariaDB [wikidatawiki]> SELECT rc_namespace, COUNT(DISTINCT rc_actor) AS
editors FROM recentchanges JOIN actor ON rc_actor = actor_id WHERE rc_namespace
>= 0 AND actor_user > 0 GROUP BY rc_namespace ORDER BY editors DESC;
TASK DETAIL
https://phabricator.wikimedia.org/T275999
EMAIL PREFERENCES
https://phabricator.wikimedia.org/settings/panel/emailpreferences/
To: amy_rc
Cc: amy_rc, Lucas_Werkmeister_WMDE, Aklapper, Lydia_Pintscher, Akuckartz,
Nandana, Lahi, Gq86, GoranSMilovanovic, QZanden, LawExplorer, _jensen,
rosalieper, Scott_WUaS, Jonas, abian, Wikidata-bugs, aude, Mbch331
_______________________________________________
Wikidata-bugs mailing list
[email protected]
https://lists.wikimedia.org/mailman/listinfo/wikidata-bugs
