Gender of editors to specific page

Fork of Gender of editors to specific page by Pppery

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

SQL

use dewiki_p;

SELECT 
	SUM(IF(up_value = "male", 1, 0)) as male,
	SUM(IF(up_value = "female", 1, 0)) as female,
    SUM(IF(up_value != "male" OR up_value != "female", 1, 0)) as na,
FROM (select distinct actor_name as "username", (select up_value from user_properties where up_user=actor_user and up_property="gender") as "gender"
		from revision join actor on rev_actor=actor_id 
		where rev_page= (select page_id from page where page_namespace=4 and page_title="Vandalismusmeldung")) as Vandale
WHERE 
up_property = "gender";

SQL

Checking query status...