Page MenuHomePhabricator
Paste P5802

enwiki skin distribution
ActivePublic

Authored by demon on Jul 25 2017, 6:42 PM.
Tags
None
Referenced Files
F8850268: enwiki skin distribution
Jul 25 2017, 6:42 PM
Subscribers
None
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)