https://bugzilla.wikimedia.org/show_bug.cgi?id=16775
MZMcBride <[email protected]> changed: What |Removed |Added ---------------------------------------------------------------------------- Summary|Number of active users is |Number of "active users" is |100,000 off at en.wiki |a rather confusing statistic --- Comment #3 from MZMcBride <[email protected]> 2008-12-27 06:13:30 UTC --- Received by pastebin from OverlordQ: SELECT COUNT(DISTINCT rc_user_text) FROM recentchanges WHERE rc_user != 0 AND rc_bot = 0 AND (rc_log_type != 'newusers' OR rc_log_type IS NULL); +------------------------------+ | COUNT(DISTINCT rc_user_text) | +------------------------------+ | 153024 | +------------------------------+ 1 row in set (1 min 57.97 sec) mysql> SELECT COUNT(DISTINCT rc_user_text) FROM recentchanges WHERE rc_user != 0; +------------------------------+ | COUNT(DISTINCT rc_user_text) | +------------------------------+ | 264739 | +------------------------------+ 1 row in set (14.11 sec) So, the number isn't wrong, per se. Just rather confusing... I've adjusted the bug summary accordingly. Possible options to add clarification: link to a MW.org page describing how the statistic is calculated (and what each piece means, how often it's refreshed, etc.). I believe the Job queue includes a link by default now in MediaWiki core. -- Configure bugmail: https://bugzilla.wikimedia.org/userprefs.cgi?tab=email ------- You are receiving this mail because: ------- You are the assignee for the bug. You are on the CC list for the bug. _______________________________________________ Wikibugs-l mailing list [email protected] https://lists.wikimedia.org/mailman/listinfo/wikibugs-l
