Women total, not bots, with at least 1 edit

SQL

USE idwiki_p;
SELECT COUNT(DISTINCT rev_actor) AS WomenTotal FROM revision WHERE rev_actor IN
(
   SELECT user_id FROM user JOIN user_properties ON user_id=up_user WHERE 
 up_property = 'gender' AND up_value = 'female'
);
   SELECT COUNT(DISTINCT rev_actor) AS MenTotal FROM revision WHERE rev_actor IN
(
   SELECT user_id FROM user  JOIN user_properties ON user_id=up_user WHERE 
 up_property = 'gender' AND up_value = 'male'
);
   SELECT COUNT(DISTINCT rev_actor) as Total FROM revision WHERE rev_actor IN
(
   SELECT user_id FROM user
);

SQL

Checking query status...