https://bugzilla.wikimedia.org/show_bug.cgi?id=45179
Dan Andreescu <[email protected]> changed: What |Removed |Added ---------------------------------------------------------------------------- Status|NEW |RESOLVED Resolution|--- |FIXED --- Comment #6 from Dan Andreescu <[email protected]> --- The query that produces the answer to the question posed here: select coalesce(up_value, 'default') as skin, count(*) as skin_users from (select user.user_id, count(*) as edits_in_last_30_days from recentchanges inner join user on user.user_id = recentchanges.rc_user where recentchanges.rc_namespace = 0 and recentchanges.rc_type < 2 and recentchanges.rc_user > 0 group by user_id having edits_in_last_30_days >= 5 ) as active_editors left join user_properties on user_properties.up_user = active_editors.user_id and user_properties.up_property = 'skin' group by skin; My fumbling process to find this query, if anyone's interested: https://gist.github.com/milimetric/5262726 And results: /* +-------------+------------+ | 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 | +-------------+------------+ */ -- You are receiving this mail because: You are on the CC list for the bug. You are watching all bug changes. _______________________________________________ Wikibugs-l mailing list [email protected] https://lists.wikimedia.org/mailman/listinfo/wikibugs-l
