Untitled query #80489

This query is marked as a draft This query has been published by Abián.
SQL

select "en" as langcode, up_user, up_value from enwiki_p.user_properties where up_property='gender' union
select "de" as langcode, up_user, up_value from dewiki_p.user_properties where up_property='gender' union
select "fr" as langcode, up_user, up_value from frwiki_p.user_properties where up_property='gender' union
select "es" as langcode, up_user, up_value from eswiki_p.user_properties where up_property='gender' union
select "ru" as langcode, up_user, up_value from ruwiki_p.user_properties where up_property='gender' union
select "ja" as langcode, up_user, up_value from jawiki_p.user_properties where up_property='gender' union
select "it" as langcode, up_user, up_value from itwiki_p.user_properties where up_property='gender' union
select "pt" as langcode, up_user, up_value from ptwiki_p.user_properties where up_property='gender' union
select "ar" as langcode, up_user, up_value from arwiki_p.user_properties where up_property='gender' union
select "fa" as langcode, up_user, up_value from fawiki_p.user_properties where up_property='gender' union
select "zh" as langcode, up_user, up_value from zhwiki_p.user_properties where up_property='gender' union
select "pl" as langcode, up_user, up_value from plwiki_p.user_properties where up_property='gender' union
select "tr" as langcode, up_user, up_value from trwiki_p.user_properties where up_property='gender' union
select "uk" as langcode, up_user, up_value from ukwiki_p.user_properties where up_property='gender' union
select "nl" as langcode, up_user, up_value from nlwiki_p.user_properties where up_property='gender' union
select "he" as langcode, up_user, up_value from hewiki_p.user_properties where up_property='gender' union
select "id" as langcode, up_user, up_value from idwiki_p.user_properties where up_property='gender' union
select "cs" as langcode, up_user, up_value from cswiki_p.user_properties where up_property='gender' union
select "no" as langcode, up_user, up_value from nowiki_p.user_properties where up_property='gender' union
select "sv" as langcode, up_user, up_value from svwiki_p.user_properties where up_property='gender' union
select "ca" as langcode, up_user, up_value from cawiki_p.user_properties where up_property='gender' union
select "vi" as langcode, up_user, up_value from viwiki_p.user_properties where up_property='gender' union
select "bn" as langcode, up_user, up_value from bnwiki_p.user_properties where up_property='gender' union
select "ko" as langcode, up_user, up_value from kowiki_p.user_properties where up_property='gender' union
select "hi" as langcode, up_user, up_value from hiwiki_p.user_properties where up_property='gender' union
select "hu" as langcode, up_user, up_value from huwiki_p.user_properties where up_property='gender' union
select "fi" as langcode, up_user, up_value from fiwiki_p.user_properties where up_property='gender' union
select "sr" as langcode, up_user, up_value from srwiki_p.user_properties where up_property='gender' union
select "simple" as langcode, up_user, up_value from simplewiki_p.user_properties where up_property='gender' union
select "ro" as langcode, up_user, up_value from rowiki_p.user_properties where up_property='gender' union
select "el" as langcode, up_user, up_value from elwiki_p.user_properties where up_property='gender' union
select "th" as langcode, up_user, up_value from thwiki_p.user_properties where up_property='gender' union
select "az" as langcode, up_user, up_value from azwiki_p.user_properties where up_property='gender' union
select "sk" as langcode, up_user, up_value from skwiki_p.user_properties where up_property='gender' union
select "hy" as langcode, up_user, up_value from hywiki_p.user_properties where up_property='gender' union
select "bg" as langcode, up_user, up_value from bgwiki_p.user_properties where up_property='gender' union
select "hr" as langcode, up_user, up_value from hrwiki_p.user_properties where up_property='gender' union
select "da" as langcode, up_user, up_value from dawiki_p.user_properties where up_property='gender' union
select "et" as langcode, up_user, up_value from etwiki_p.user_properties where up_property='gender' union
select "ms" as langcode, up_user, up_value from mswiki_p.user_properties where up_property='gender' union
select "eu" as langcode, up_user, up_value from euwiki_p.user_properties where up_property='gender' union
select "ta" as langcode, up_user, up_value from tawiki_p.user_properties where up_property='gender' union
select "bs" as langcode, up_user, up_value from bswiki_p.user_properties where up_property='gender' union
select "ml" as langcode, up_user, up_value from mlwiki_p.user_properties where up_property='gender' union
select "uz" as langcode, up_user, up_value from uzwiki_p.user_properties where up_property='gender' union
select "be" as langcode, up_user, up_value from bewiki_p.user_properties where up_property='gender' union
select "gl" as langcode, up_user, up_value from glwiki_p.user_properties where up_property='gender' union
select "ur" as langcode, up_user, up_value from urwiki_p.user_properties where up_property='gender' union
select "af" as langcode, up_user, up_value from afwiki_p.user_properties where up_property='gender' union
select "ka" as langcode, up_user, up_value from kawiki_p.user_properties where up_property='gender' union
select "sl" as langcode, up_user, up_value from slwiki_p.user_properties where up_property='gender' union
select "eo" as langcode, up_user, up_value from eowiki_p.user_properties where up_property='gender' union
select "lv" as langcode, up_user, up_value from lvwiki_p.user_properties where up_property='gender' union
select "lt" as langcode, up_user, up_value from ltwiki_p.user_properties where up_property='gender' union
select "sq" as langcode, up_user, up_value from sqwiki_p.user_properties where up_property='gender' union
select "te" as langcode, up_user, up_value from tewiki_p.user_properties where up_property='gender' union
select "ckb" as langcode, up_user, up_value from ckbwiki_p.user_properties where up_property='gender' union
select "kk" as langcode, up_user, up_value from kkwiki_p.user_properties where up_property='gender' union
select "zh_yue" as langcode, up_user, up_value from zh_yuewiki_p.user_properties where up_property='gender' union
select "mr" as langcode, up_user, up_value from mrwiki_p.user_properties where up_property='gender' union
select "arz" as langcode, up_user, up_value from arzwiki_p.user_properties where up_property='gender' union
select "gu" as langcode, up_user, up_value from guwiki_p.user_properties where up_property='gender' union
select "kn" as langcode, up_user, up_value from knwiki_p.user_properties where up_property='gender' union
select "la" as langcode, up_user, up_value from lawiki_p.user_properties where up_property='gender' union
select "cy" as langcode, up_user, up_value from cywiki_p.user_properties where up_property='gender' union
select "ne" as langcode, up_user, up_value from newiki_p.user_properties where up_property='gender' union
select "ba" as langcode, up_user, up_value from bawiki_p.user_properties where up_property='gender' union
select "my" as langcode, up_user, up_value from mywiki_p.user_properties where up_property='gender' union
select "sh" as langcode, up_user, up_value from shwiki_p.user_properties where up_property='gender' union
select "test" as langcode, up_user, up_value from testwiki_p.user_properties where up_property='gender' union
select "pa" as langcode, up_user, up_value from pawiki_p.user_properties where up_property='gender' union
select "mk" as langcode, up_user, up_value from mkwiki_p.user_properties where up_property='gender' union
select "be_tarask" as langcode, up_user, up_value from be_taraskwiki_p.user_properties where up_property='gender' union
select "ga" as langcode, up_user, up_value from gawiki_p.user_properties where up_property='gender' union
select "als" as langcode, up_user, up_value from alswiki_p.user_properties where up_property='gender' union
select "an" as langcode, up_user, up_value from anwiki_p.user_properties where up_property='gender' union
select "as" as langcode, up_user, up_value from aswiki_p.user_properties where up_property='gender' union
select "tt" as langcode, up_user, up_value from ttwiki_p.user_properties where up_property='gender' union
select "tg" as langcode, up_user, up_value from tgwiki_p.user_properties where up_property='gender' union
select "sw" as langcode, up_user, up_value from swwiki_p.user_properties where up_property='gender' union
select "or" as langcode, up_user, up_value from orwiki_p.user_properties where up_property='gender' union
select "zh_classical" as langcode, up_user, up_value from zh_classicalwiki_p.user_properties where up_property='gender' union
select "ht" as langcode, up_user, up_value from htwiki_p.user_properties where up_property='gender' union
select "nn" as langcode, up_user, up_value from nnwiki_p.user_properties where up_property='gender' union
select "ku" as langcode, up_user, up_value from kuwiki_p.user_properties where up_property='gender' union
select "fy" as langcode, up_user, up_value from fywiki_p.user_properties where up_property='gender' union
select "jv" as langcode, up_user, up_value from jvwiki_p.user_properties where up_property='gender' union
select "ast" as langcode, up_user, up_value from astwiki_p.user_properties where up_property='gender' union
select "sa" as langcode, up_user, up_value from sawiki_p.user_properties where up_property='gender' union
select "lb" as langcode, up_user, up_value from lbwiki_p.user_properties where up_property='gender' union
select "tl" as langcode, up_user, up_value from tlwiki_p.user_properties where up_property='gender' union
select "ha" as langcode, up_user, up_value from hawiki_p.user_properties where up_property='gender' union
select "si" as langcode, up_user, up_value from siwiki_p.user_properties where up_property='gender' union
select "ps" as langcode, up_user, up_value from pswiki_p.user_properties where up_property='gender' union
select "is" as langcode, up_user, up_value from iswiki_p.user_properties where up_property='gender' union
select "sco" as langcode, up_user, up_value from scowiki_p.user_properties where up_property='gender' union
select "lij" as langcode, up_user, up_value from lijwiki_p.user_properties where up_property='gender' union
select "azb" as langcode, up_user, up_value from azbwiki_p.user_properties where up_property='gender' union
select "scn" as langcode, up_user, up_value from scnwiki_p.user_properties where up_property='gender' union
select "lmo" as langcode, up_user, up_value from lmowiki_p.user_properties 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.
Submit Query Stop Query
All SQL code is licensed under CC0 License.
SQL

Checking query status...
