= Request =
**What's requested:**
Wikipedia's preferences offer you due to historical reasons under the Preferences > Appearance tab four skins to choose from besides the default Vector.
**Why it's requested:**
We're still offering CologneBlue, Modern, MonoBook options aside of Vector and it would be great to have a better understanding of our users.
I'm aware of the statistics provided by https://wikiapiary.com/wiki/Skin:Skins but from my understanding there are just installed skins counted. It would be interesting to get the number of active users (maybe something like skin setting and being repeatedly logged in during last 12 months)
**When it's requested:**
No current deadline to fulfill here.
**Other helpful information:**
= Results =
== Methods =
Created an intermediate table using the following query:
```
create table staging.neilpquinn_editor_year
select
user_name,
# wiki relies on the DB system taking the first value in each group
wiki as home_wiki,
local_user_id as home_user_id,
sum(edits) as adjusted_edits
from
(select
user_name,
wiki,
local_user_id,
# special case to avoid unexpected choices of Wikidata as home wiki
if(wiki = 'wikidatawiki', sum(edits) * 0.1, sum(edits)) as edits
from staging.editor_month
where
month >= '2015-11-01' and month < '2016-11-01' and
local_user_id != 0 and
bot = 0
group by user_name, wiki
order by user_name asc, edits desc
) user_wiki
group by user_name;
```
Ran the following query on all wikis using multiquery:
```
select
database() as wiki,
up_value as skin,
count(*) as users
from staging.neilpquinn_editor_year
left join user_properties
on home_user_id = up_user and up_property = "skin"
where home_wiki = database()
group by up_value;
```
Plus did the same, filtering first for >= 30 and then >= 600 edits.