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)