Women total, not bots, with at least 1 edit

Fork of Women total, not bots, with at least 1 edit by Bennylin

This query is marked as a draft This query has been published by Pyb.

SQL

USE frwiki_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...