enwiki skin distribution
No One
Actions

Authored By

	• demon
	Jul 25 2017, 6:42 PM

Size

732 B

Referenced Files

None

Subscribers

None

enwiki skin distribution
View Options

	mysql> select up_value as skin, count(*) as cnt from user_properties where up_property = 'skin' group by up_value order by cnt desc;
	+--------------+---------+
	\| skin \| cnt \|
	+--------------+---------+
	\| \| 7179793 \|
	\| monobook \| 2190692 \|
	\| vector \| 162396 \|
	\| cologneblue \| 86829 \|
	\| modern \| 80839 \|
	\| 0 \| 53975 \|
	\| standard \| 34178 \|
	\| chick \| 31859 \|
	\| nostalgia \| 21142 \|
	\| myskin \| 16177 \|
	\| simple \| 14113 \|
	\| 2 \| 3056 \|
	\| 1 \| 1754 \|
	\| amethyst \| 1290 \|
	\| minerva \| 105 \|
	\| minervaneue \| 27 \|
	\| minerva-neue \| 8 \|
	+--------------+---------+
	17 rows in set (1 min 36.25 sec)

	mysql> select up_value as skin, count(*) as cnt from user_properties where up_property = 'skin' group by up_value order by cnt desc;
	+--------------+---------+
	\| skin \| cnt \|
	+--------------+---------+
	\| \| 7179793 \|
	\| monobook \| 2190692 \|
	\| vector \| 162396 \|
	\| cologneblue \| 86829 \|
	\| modern \| 80839 \|
	\| 0 \| 53975 \|
	\| standard \| 34178 \|
	\| chick \| 31859 \|
	\| nostalgia \| 21142 \|
	\| myskin \| 16177 \|
	\| simple \| 14113 \|
	\| 2 \| 3056 \|
	\| 1 \| 1754 \|
	\| amethyst \| 1290 \|
	\| minerva \| 105 \|
	\| minervaneue \| 27 \|
	\| minerva-neue \| 8 \|
	+--------------+---------+
	17 rows in set (1 min 36.25 sec)