Toggle navigation
Home
New Query
Recent Queries
Discuss
Database tables
Database names
MediaWiki
Wikibase
Replicas browser and optimizer
Login
History
Fork
Fork of
English Wikipedia active editor genders
by
Lucas Werkmeister
This query is marked as a draft
This query has been published
by
SNowick (WMF)
.
Number of active English Wikipedia editors (users with at least one edit in the last thirty days) by gender, according to user properties.
Toggle Highlighting
SQL
USE `enwiki_p`; SELECT COALESCE(`up_value`, "unspecified") AS "gender", COUNT(*) AS "count" FROM ( SELECT DISTINCT `rc_user` FROM `recentchanges` ) AS `active_users` LEFT JOIN `user_properties` ON `rc_user` = `up_user` WHERE `up_property` = "gender" OR `up_property` IS NULL GROUP BY `up_value`; SELECT NOW() AS "as of";
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
.
Checking query status...