https://bugzilla.wikimedia.org/show_bug.cgi?id=16775
Roan Kattouw <[email protected]> changed: What |Removed |Added ---------------------------------------------------------------------------- CC| |[email protected] --- Comment #2 from Roan Kattouw <[email protected]> 2008-12-24 13:20:47 UTC --- (In reply to comment #0) > I ran a query on the Toolserver to determine the number of active users: > > SELECT rc_user_text FROM recentchanges;l > > I then ran the output through a de-dupe script and then filtered out IPv4 > addresses. A more useful query would probably be SELECT DISTINCT rc_user_text FROM recentchanges WHERE rc_user != 0 AND rc_type != 3; This filters out duplicates, IPs and log entries (can't think of a better mechanism to exclude account creations this quickly). -- 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
