Replicas browser and optimizer
Users with Gender disclosured in dewiki
This query is marked as a draft
This query has been published
use ptwiki_p; select user_name as bot, up_value as gender from user, user_properties where user_id = up_user and user_id in ( select ug_user from user_groups where ug_group = 'bot' and ug_user in ( select up_user from user_properties where up_property = 'gender' ) ) and up_property = "gender" ; # select up_value as gender, count(*) as users from user_properties where up_property = 'gender' group by up_value;
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