Replicas browser and optimizer
Gender by user groups in ptwiki
This query is marked as a draft
This query has been published
use dewiki_p; select ug_group, gender, count(*) from ( select ug_group, if(up_value IS NULL ,"none",up_value) as gender from (select ug_user, ug_group from user_groups) a left outer join (select up_user, up_value from user_properties where up_property = "gender") b on ug_user = up_user ) x group by ug_group, gender;
By running queries you agree to the
and you irrevocably agree to release your SQL under
All SQL code is licensed under
Checking query status...
Report a bug!
Wikimedia Cloud VPS
, written in