User:Krinkle/Queries/commonswiki userpropstat skin
Appearance
< User:Krinkle | Queries
commons.wikimedia.org : User properties statistics (skin)
Last update: 2011-05-29 20:23 (UTC)
Last update: 2011-05-29 20:23 (UTC)
# commonswiki_userpropstat_skin.sh sql commonswiki_p < commonswiki_userpropstat_skin.sql > commonswiki_userpropstat_skin.txt # commonswiki_userpropstat_skin.sql SELECT COUNT(*), up_value FROM user_properties_anonym WHERE up_property='skin' GROUP BY up_value; # commonswiki_userpropstat_skin.txt COUNT(*) up_value 548784 15 amethyst 814 chick 2359 cologneblue 2864 modern 146086 monobook 492 myskin 594 nostalgia 1 on 416 simple 1219 standard 6346 vector