Number of users on aawiki

Investigating the number of users listed on aawiki compared to number of users who actually made edits. Note that the count of distinct users in the revision table regards all anonymous edits as a single user (with user ID 0).

SQL

USE aawiki_p;
SELECT count(*) AS num_accounts FROM user;
SELECT count(*) AS num_nonzero_accounts FROM user WHERE user_editcount > 0;
SELECT COUNT(DISTINCT IF(rev_user = 0, rev_user_text, rev_user)) AS num_rev_users FROM revision;
SELECT COUNT(rev_id) AS num_edits FROM revision;

AخA
 
USE aawiki_p;SELECT count(*) AS num_accounts FROM user;SELECT count(*) AS num_nonzero_accounts FROM user WHERE user_editcount > 0;SELECT COUNT(DISTINCT IF(rev_user = 0, rev_user_text, rev_user)) AS num_rev_users FROM revision;SELECT COUNT(rev_id) AS num_edits FROM revision;

SQL

Checking query status...