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
x
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";
By running queries you agree to the Cloud Services Terms of Use and you irrevocably agree to release your SQL under CC0 License.
All SQL code is licensed under CC0 License.