1063882 - Get updated numbers on MozillaWiki skin users

Status: RESOLVED FIXED

(Infrastructure & Operations :: IT-Managed Tools, task)

Description

[Gordon P. Hemsley [:GPHemsley]]

+++ This bug was initially created as a clone of Bug #1057806 +++

Bug 1062656 purports to have reset (removed) the skin preferences for anyone using the following skins: 'cavendish', 'modern', 'cologneblue', 'standard', 'myskin', 'chick', 'sandstone', 'nostalgia', 'simple', 'gmo', ''.

It would be good to get updated numbers on skin users after the change.

As before, the query is as follows:

>>>
SELECT up_value, COUNT(up_user) AS skin_users
FROM user_properties
WHERE up_property = 'skin'
GROUP BY up_value
ORDER BY skin_users DESC, up_value ASC
<<<

Comment 1

[C. Liang [:cyliang]]

mysql> SELECT up_value, COUNT(up_user) AS skin_users
    -> FROM user_properties
    -> WHERE up_property = 'skin'
    -> GROUP BY up_value
    -> ORDER BY skin_users DESC, up_value ASC;
+----------+------------+
| up_value | skin_users |
+----------+------------+
| vector   |        137 |
| monobook |         81 |
+----------+------------+
2 rows in set (0.01 sec)