Relative distribution - Wikipedian/Commonist category edits

Last run April 16 2018

Breakdown of edits made by 100+ editcount contributors comparing the Category namespace and all namespaces. Compares English Wikipedia and Wikimedia Commons. Counts are for the past 30 days, comprise new page creations, page edits, and categorization actions. Filters out bot edits.

SQL

use enwiki_p;
select count(rc_id) from recentchanges_userindex rc join user u on rc.rc_user = u.user_id where rc.rc_namespace = 14 and rc_type in (0,1,6) and rc.rc_bot = 0 and rc.rc_user != 0 and u.user_editcount > 100;
#
select count(rc_id) from recentchanges_userindex rc join user u on rc.rc_user = u.user_id where rc_type in (0,1,6) and rc.rc_bot = 0 and rc.rc_user != 0 and u.user_editcount > 100;
#

use commonswiki_p;
select count(rc_id) from recentchanges_userindex rc join user u on rc.rc_user = u.user_id where rc.rc_namespace = 14 and rc_type in (0,1,6) and rc.rc_bot = 0 and rc.rc_user != 0 and u.user_editcount > 100;
#
select count(rc_id) from recentchanges_userindex rc join user u on rc.rc_user = u.user_id where rc_type in (0,1,6) and rc.rc_bot = 0 and rc.rc_user != 0 and u.user_editcount > 100;
#

SQL

Checking query status...