Skin usage by cohort

SQL

USE enwiki_p;
SELECT count(user_id) AS number,
       up_value AS skin,
       (CASE WHEN user_editcount = 0 THEN 'edits0'
             WHEN user_editcount BETWEEN 1 AND 9 THEN 'edits1-9'
             WHEN user_editcount BETWEEN 10 AND 99 THEN 'edits10-999'
             WHEN user_editcount BETWEEN 100 AND 999 THEN 'edits100-9999'
             WHEN user_editcount BETWEEN 1000 AND 9999 THEN 'edits1000-99999'
             ELSE 'edits10000-' END) AS editorBucket,
       (CASE WHEN user_touched > DATE_SUB(NOW(), INTERVAL 1 MONTH) THEN 'live_0-1m'
             WHEN user_touched BETWEEN DATE_SUB(NOW(), INTERVAL 3 MONTH) AND DATE_SUB(NOW(), INTERVAL 1 MONTH) THEN 'live_1-3m'
             WHEN user_touched BETWEEN DATE_SUB(NOW(), INTERVAL 6 MONTH) AND DATE_SUB(NOW(), INTERVAL 3 MONTH) THEN 'live_3-6m'
             WHEN user_touched BETWEEN DATE_SUB(NOW(), INTERVAL 12 MONTH) AND DATE_SUB(NOW(), INTERVAL 6 MONTH) THEN 'live_6-12m'
             ELSE 'old' END) AS activeBucket
FROM enwiki_p.user_properties
  INNER JOIN enwiki_p.user ON up_user=user_id
  WHERE up_property = 'skin'
GROUP BY skin,
         editorBucket,
         activeBucket;
SQL

Checking query status...
