Toggle navigation
Home
New Query
Recent Queries
Discuss
Database tables
Database names
MediaWiki
Wikibase
Replicas browser and optimizer
Login
History
Fork
This query is marked as a draft
This query has been published
by
מקף
.
Toggle Highlighting
SQL
WITH active_users AS ( SELECT actor.actor_user FROM actor_revision AS actor WHERE TRUE AND actor.actor_user IS NOT NULL ), gender_data AS ( SELECT up_user, up_value AS gender FROM user_properties WHERE up_property = 'gender' ), active_users_with_gender AS ( SELECT active_users.actor_user, gender_data.gender FROM active_users LEFT JOIN gender_data ON active_users.actor_user = gender_data.up_user ) SELECT DATE_FORMAT(CONVERT_TZ(STR_TO_DATE(actor.rev_timestamp, '%Y%m%d%H%i%s'), '+00:00', '+03:00'), '%Y-%m') AS month, COUNT(DISTINCT active_users_with_gender.actor_user) AS user_count, active_users_with_gender.gender FROM actor_revision AS actor LEFT JOIN active_users_with_gender ON actor.actor_user = active_users_with_gender.actor_user GROUP BY month, active_users_with_gender.gender ORDER BY month, active_users_with_gender.gender;
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...