Gender Gap on Participants by Main Wikipedia

Fork of Gender Gap on Participants by Main Wikipedia by Quarry User

This query is marked as a draft This query has been published by NSkaggs (WMF).

SQL

set @enwiki = "enwiki";
set @dewiki = "dewiki";
set @frwiki = "frwiki";
set @nlwiki = "nlwiki";
set @ruwiki = "ruwiki";
set @itwiki = "itwiki";
set @eswiki = "eswiki";
set @plwiki = "plwiki";
set @jawiki = "jawiki";
set @zhwiki = "zhwiki";
set @arwiki = "arwiki";
set @ukwiki = "ukwiki";
set @ptwiki = "ptwiki";


select @enwiki as 'wiki', enwiki_p.user_properties.up_value as 'gender', count(*) as 'number' from enwiki_p.user_properties where enwiki_p.user_properties.up_property = 'gender' group by enwiki_p.user_properties.up_value
union all
select @dewiki as 'wiki', dewiki_p.user_properties.up_value as 'gender', count(*) as 'number' from dewiki_p.user_properties where dewiki_p.user_properties.up_property = 'gender' group by dewiki_p.user_properties.up_value
union all
select @frwiki as 'wiki', frwiki_p.user_properties.up_value as 'gender', count(*) as 'number' from frwiki_p.user_properties where frwiki_p.user_properties.up_property = 'gender' group by frwiki_p.user_properties.up_value
union all
select @nlwiki as 'wiki', nlwiki_p.user_properties.up_value as 'gender', count(*) as 'number' from nlwiki_p.user_properties where nlwiki_p.user_properties.up_property = 'gender' group by nlwiki_p.user_properties.up_value
union all
select @ruwiki as 'wiki', ruwiki_p.user_properties.up_value as 'gender', count(*) as 'number' from ruwiki_p.user_properties where ruwiki_p.user_properties.up_property = 'gender' group by ruwiki_p.user_properties.up_value
union all
select @itwiki as 'wiki', itwiki_p.user_properties.up_value as 'gender', count(*) as 'number' from itwiki_p.user_properties where itwiki_p.user_properties.up_property = 'gender' group by itwiki_p.user_properties.up_value
union all
select @eswiki as 'wiki', eswiki_p.user_properties.up_value as 'gender', count(*) as 'number' from eswiki_p.user_properties where eswiki_p.user_properties.up_property = 'gender' group by eswiki_p.user_properties.up_value
union all
select @plwiki as 'wiki', plwiki_p.user_properties.up_value as 'gender', count(*) as 'number' from plwiki_p.user_properties where plwiki_p.user_properties.up_property = 'gender' group by plwiki_p.user_properties.up_value
union all
select @jawiki as 'wiki', jawiki_p.user_properties.up_value as 'gender', count(*) as 'number' from jawiki_p.user_properties where jawiki_p.user_properties.up_property = 'gender' group by jawiki_p.user_properties.up_value
union all
select @zhwiki as 'wiki', zhwiki_p.user_properties.up_value as 'gender', count(*) as 'number' from zhwiki_p.user_properties where zhwiki_p.user_properties.up_property = 'gender' group by zhwiki_p.user_properties.up_value
union all
select @arwiki as 'wiki', arwiki_p.user_properties.up_value as 'gender', count(*) as 'number' from arwiki_p.user_properties where arwiki_p.user_properties.up_property = 'gender' group by arwiki_p.user_properties.up_value
union all
select @ukwiki as 'wiki', ukwiki_p.user_properties.up_value as 'gender', count(*) as 'number' from ukwiki_p.user_properties where ukwiki_p.user_properties.up_property = 'gender' group by ukwiki_p.user_properties.up_value
union all
select @ptwiki as 'wiki', ptwiki_p.user_properties.up_value as 'gender', count(*) as 'number' from ptwiki_p.user_properties where ptwiki_p.user_properties.up_property = 'gender' group by ptwiki_p.user_properties.up_value

By running queries you agree to the Cloud Services Terms of Use and you irrevocably agree to release your SQL under CC0 License.

Submit Query Stop Query

All SQL code is licensed under CC0 License.

SQL

Checking query status...