Number of users on aawiki

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

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;

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...