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;

SQL

Checking query status...