Count self-declared gender on Portuguese Wikipedia

SQL

use ptwiki_p;
select up_value as gender, count(*) as users from user_properties INNER JOIN user ON user_id = up_user where up_property = 'gender' AND user_editcount > 0  group by up_value;
use eswiki_p;
select up_value as gender, count(*) as users from user_properties INNER JOIN user ON user_id = up_user where up_property = 'gender' AND user_editcount > 0  group by up_value;
use enwiki_p;
select up_value as gender, count(*) as users from user_properties INNER JOIN user ON user_id = up_user where up_property = 'gender' AND user_editcount > 0  group by up_value;

​x
 
use ptwiki_p;select up_value as gender, count(*) as users from user_properties INNER JOIN user ON user_id = up_user where up_property = 'gender' AND user_editcount > 0  group by up_value;use eswiki_p;select up_value as gender, count(*) as users from user_properties INNER JOIN user ON user_id = up_user where up_property = 'gender' AND user_editcount > 0  group by up_value;use enwiki_p;select up_value as gender, count(*) as users from user_properties INNER JOIN user ON user_id = up_user where up_property = 'gender' AND user_editcount > 0  group by up_value;​

SQL

Checking query status...