Skin usage statistics in elwiki

SQL

use elwiki_p;

SELECT up_value AS skin, count(*) AS users, max(upa_touched) AS last_updated
FROM user_properties_anon
WHERE up_property="skin"
GROUP BY up_value
ORDER BY users DESC;

/* existent */
SELECT up_value AS skin, count(*) AS users, max(upa_touched) AS last_updated
FROM user_properties_anon
WHERE up_property="skin" AND up_value IN('vector', 'monobook', 'modern', 'timeless', 'minerva', 'cologneblue')
GROUP BY up_value
ORDER BY users DESC;

​x
 
use elwiki_p;​SELECT up_value AS skin, count(*) AS users, max(upa_touched) AS last_updatedFROM user_properties_anonWHERE up_property="skin"GROUP BY up_valueORDER BY users DESC;​/* existent */SELECT up_value AS skin, count(*) AS users, max(upa_touched) AS last_updatedFROM user_properties_anonWHERE up_property="skin" AND up_value IN('vector', 'monobook', 'modern', 'timeless', 'minerva', 'cologneblue')GROUP BY up_valueORDER BY users DESC;

SQL

Checking query status...