[19:57:39] <musikanimal>	 hello, is there any way to see which skins are the most popular on a given wiki?
[20:00:34] <Zppix>	 Theres a special or wp page on enwiki
[20:00:40] <Zppix>	 I forget the name
[20:09:03] <Krenair>	 musikanimal, can look it up in user_properties
[20:12:34] <musikanimal>	 Krenair: is that sanitized in the replicas? I see "fancysig", "gender", "nickname" and "timecorrection"
[20:12:56] <Krenair>	 'skin'
[20:13:46] <Krenair>	 yes
[20:14:05] <musikanimal>	 dang
[20:14:31] <musikanimal>	 we should look into Special:SkinUsage or something, similar to Special:GadgetUsage which I think is what Zppix was thinking of
[20:14:44] <Reedy>	 musikanimal: if skin isn't set, the user is using the wikis default
[20:15:29] <Zppix>	 No, i was viewing skinstats few weeks ago
[20:15:40] <Zppix>	 Maybe it was an tool
[20:15:46] <musikanimal>	 aha! thank you Reedy 
[20:15:58] <musikanimal>	 yeah, the data is there
[20:16:01] <Reedy>	 Which may be why the stats look confusing
[20:25:35] <Krenair>	 the same applies with all preferences
[20:28:27] <musikanimal>	 and there's no way to see what gadgets a user has enabled, correct?
[20:36:56] <musikanimal>	 I guess user_properties isn't populated for every registered account, only ~11.2 million unique up_user's (user IDs)
[20:37:41] <Reedy>	 if they've not modified anything..
[20:37:54] <musikanimal>	 oh right
[20:38:08] <musikanimal>	 well this is better, weans out a lot of the throwaway accounts
[20:39:05] <musikanimal>	 probably not a safe assumption, but probable that most experienced users have modified at least some of those settings
[20:45:01] <Krenair>	 not without access to the real production databases
[20:45:04] <musikanimal>	 Reedy: back to the other question, I assume there's no way to see what gadgets a user has turned on? I'm trying to diagnose an issue a non-techy is experiencing
[20:45:11] <musikanimal>	 the skin stats was just out of curiousity
[20:45:25] <musikanimal>	 or Krenair
[20:45:26] <Reedy>	 I presume there will be...
[20:45:46] <musikanimal>	 I mean, it doesn't seem like private information
[20:48:43] <Reedy>	 It may just not be whitelisted
[20:59:32] <Zppix>	 musikanimal: probably but honestly you probably need to sign a nda to protect wmfs rear (i think my legal knowledge is crappy)
[20:59:54] <musikanimal>	 all good, we got it figured out
[21:00:16] <Reedy>	 Zppix: WMF staff already have
[21:00:23] <musikanimal>	 if per-user gadget usage is explicitly hidden from public view I'm sure there's a good reason for it
[21:00:27] <Zppix>	 I meant for volunteers
[21:00:34] <Reedy>	 He's not a volunteer
[21:00:37] <Reedy>	 So it doesn't matter
[21:00:40] <Zppix>	 Really?
[21:00:42] <musikanimal>	 hehe, this is correct :)
[21:00:44] <Zppix>	 Didnt know that
[21:00:45] <Zppix>	 Lol
[21:00:53] <musikanimal>	 well, I am a volunteer, too!
[21:00:56] <Zppix>	 Since when??
[21:01:02] <Zppix>	 Was u staff
[21:01:06] <musikanimal>	 it was recent, 3 months or so
[21:02:59] <Reedy>	 musikanimal: On labs, like I say, it's probably just not been whitelisted.. Can't 100% say if it should or shouldn't be, but that'd be the reason it's not there
[21:11:16] <musikanimal>	 wow, okay, 5 months I've been staff
[21:11:27] <musikanimal>	 *since I've been staff
[21:11:46] <Zppix>	 I didnt know that wow
[21:12:51] <Zppix>	 Also while were here are there criteria andor requirements for gerrit repos to be included in irc by gerrit-wm via -dev??
[21:12:58] <Zppix>	 Just curious
[21:14:20] <Reedy>	 Well, the clue is in the channel name
[21:14:37] <Reedy>	 They've got to be on WMF sites.. Or actively being worked on for deployment
[21:16:52] <Krenair>	 musikanimal, oh, look at meta_p.user_properties_whitelist
[21:17:38] <Krenair>	 this controls the user_properties_anon view on wiki db replicas
[21:28:47] <musikanimal>	 nice! but user_properties_whitelist is also not in the replicas :(
[21:29:04] <musikanimal>	 not that we could modify it
[21:29:51] <Zppix>	 musikanimal: maybe ask to have a replica-version of that
[21:29:53] <Zppix>	 ?
[21:32:30] <musikanimal>	 I don't see why that table is hidden from view
[21:32:57] <Zppix>	 Trade secrects probably xD
[21:38:09] <Krenair>	 musikanimal, what?
[21:38:30] <Krenair>	 Zppix, no. please stop speculating so wildly
[21:38:47] <Zppix>	 It was a joke
[21:39:47] <musikanimal>	 I don't know, I'm confused
[21:39:50] <Krenair>	 musikanimal, sorry, I got the wrong name
[21:39:54] <Krenair>	 meta_p.properties_anon_whitelist
[21:39:57] <musikanimal>	 oh okay heh
[21:40:03] <musikanimal>	 ah
[21:40:40] <musikanimal>	 metawiki_p
[21:41:23] <Krenair>	 just meta, not metawiki
[21:41:33] <musikanimal>	 oh wow
[21:44:28] <musikanimal>	 Krenair: I don't understand what user_properties_anon is for?
[21:44:47] <Krenair>	 it controls what properties can appear in the user_properties_anon view on wiki db replicas
[21:46:10] <musikanimal>	 no I mean user_properties_anon
[21:46:41] <musikanimal>	 the columns include: touched, property and value
[21:46:45] <musikanimal>	 lots of duplicates
[21:46:59] <musikanimal>	 I think some other column has been removed, the user id ?
[21:47:11] <Krenair>	 that's deliberate
[21:47:20] <musikanimal>	 yeah
[21:47:21] <Krenair>	 it doesn't let you view the user id in the underlying table
[21:47:38] <musikanimal>	 right
[21:47:48] <musikanimal>	 that's the part I want haha
[21:48:03] <Krenair>	             "view": "select cast(extract(year_month from user_touched)*100+1 as date) upa_touched, up_property, up_value",
[21:49:03] <Krenair>	 oh, other thing about user_properties_anon is that it's limited to small.dblist and medium.dblist
[22:03:41] <arseny92>	 [00:41] <Krenair> just meta, not metawiki
[22:03:50] <arseny92>	 why two dbs 
[22:04:12] <Krenair>	 they are two entirely different things
[22:04:15] <Krenair>	 the second is a wiki db replica
[22:04:15] <arseny92>	 eh?
[22:04:22] <Krenair>	 the first contains meta information about all of the wiki db replicas
[22:06:46] <Reedy>	 so meta
[22:06:50] <Reedy>	 much meta
[22:06:51] <Reedy>	 wow