User:Krinkle/Queries/commonswiki userpropstat skin

commons.wikimedia.org : User properties statistics (skin)
    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