frwp skin stats
ActivePublic
Actions

Authored by Legoktm on Nov 17 2017, 6:05 AM.

Tags

None

Referenced Files

	F10838802: frwp skin stats
	Nov 17 2017, 6:05 AM

Subscribers

None

	mysql:wikiadmin@db1088 [frwiki]> select up_value, count(*) from user_properties where up_property="skin" group by up_value;
	+--------------+----------+
	\| up_value \| count(*) \|
	+--------------+----------+
	\| \| 441859 \|
	\| 0 \| 2516 \|
	\| 1 \| 91 \|
	\| 2 \| 167 \|
	\| amethyst \| 80 \|
	\| chick \| 778 \|
	\| cologneblue \| 3320 \|
	\| minerva \| 8 \|
	\| minerva-neue \| 1 \|
	\| minervaneue \| 31 \|
	\| modern \| 4461 \|
	\| monobook \| 143375 \|
	\| myskin \| 507 \|
	\| nostalgia \| 791 \|
	\| simple \| 391 \|
	\| standard \| 1009 \|
	\| timeless \| 121 \|
	\| vector \| 12726 \|
	+--------------+----------+
	18 rows in set (4.90 sec)

Event Timeline

	mysql:wikiadmin@db1088 [frwiki]> select up_value, count(*) from user_properties where up_property="skin" group by up_value;
	+--------------+----------+
	\| up_value \| count(*) \|
	+--------------+----------+
	\| \| 441859 \|
	\| 0 \| 2516 \|
	\| 1 \| 91 \|
	\| 2 \| 167 \|
	\| amethyst \| 80 \|
	\| chick \| 778 \|
	\| cologneblue \| 3320 \|
	\| minerva \| 8 \|
	\| minerva-neue \| 1 \|
	\| minervaneue \| 31 \|
	\| modern \| 4461 \|
	\| monobook \| 143375 \|
	\| myskin \| 507 \|
	\| nostalgia \| 791 \|
	\| simple \| 391 \|
	\| standard \| 1009 \|
	\| timeless \| 121 \|
	\| vector \| 12726 \|
	+--------------+----------+
	18 rows in set (4.90 sec)