No indeed, so my query does coalesce(user_properties.up_value, 'default') as skin, then groups by skin.  So that means the 2525 users literally have a user_properties record that's the empty string.  Not sure what that means.  Any mediawiki guys care to comment?  If I had a gun to my head I'd guess they would get the default skin.  But then if I had a gun to my head I'd have much bigger problems.


On Thu, Mar 28, 2013 at 10:16 AM, Federico Leva (Nemo) <nemowiki@gmail.com> wrote:
Dan Andreescu, 28/03/2013 14:31:

For those of you interested in this but not on the bugzilla thread, I
believe Oliver and I found an answer:

Interesting! What's that 2525? The sum of the other numbers seem to match the 5+ edits/month user count on WikiStats, so I suppose it's not additional users.

Nemo


+-------------+------------+
| skin        | skin_users |
+-------------+------------+
|             |       2525 |
| 0           |         32 |
| chick       |         21 |
| cologneblue |        104 |
| default     |      26582 |
| modern      |        329 |
| monobook    |       2810 |
| myskin      |          8 |
| nostalgia   |         15 |
| simple      |         21 |
| standard    |         98 |
| vector      |         74 |
+-------------+------------+



On Thu, Mar 21, 2013 at 5:50 PM, Dan Andreescu <dandreescu@wikimedia.org
<mailto:dandreescu@wikimedia.org>> wrote:

    I started looking because of your message Federico, so thank you for
    sending that to remind me :)


    On Thu, Mar 21, 2013 at 5:47 PM, Oliver Keyes <okeyes@wikimedia.org
    <mailto:okeyes@wikimedia.org>> wrote:

        Da; Dan and I be discussing it as we speak.


        On 21 March 2013 21:45, Matthew Flaschen
        <mflaschen@wikimedia.org <mailto:mflaschen@wikimedia.org>> wrote:

            On 03/21/2013 10:54 AM, Federico Leva (Nemo) wrote:
             > Was an answer to the question here found and published
            somewhere?

            No, but your timing is good.  Dan Andreescu has started
            looking at it
            again just recently today.

            Let's use https://bugzilla.wikimedia.org/show_bug.cgi?id=45179 .

            Matt Flaschen

            _______________________________________________
            Analytics mailing list
            Analytics@lists.wikimedia.org
            <mailto:Analytics@lists.wikimedia.org>

            https://lists.wikimedia.org/mailman/listinfo/analytics




        --
        Oliver Keyes
        Community Liaison, Product Development
        Wikimedia Foundation

        _______________________________________________
        Analytics mailing list
        Analytics@lists.wikimedia.org <mailto:Analytics@lists.wikimedia.org>
        https://lists.wikimedia.org/mailman/listinfo/analytics






_______________________________________________
Analytics mailing list
Analytics@lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/analytics