https://bugzilla.wikimedia.org/show_bug.cgi?id=46512
--- Comment #11 from Krinkle <[email protected]> --- Did another query limiting to where up_value!=1 (as it is enabled by default) and LEFT(user_touched, 8) >= '20130301' (filter out users who have no activity in the last 6 months). Also ran it on an RTL wiki and multi-language wikis as they may be other trends there. > SELECT user_touched, up_property from user, user_properties WHERE > up_user=user.user_id AND up_property='vector-collapsiblenav' AND up_value!=1 > AND LEFT(user_touched, 8) >= '20130301'; > ... > # English, German, Dutch > [enwiki] 902 rows in set (0.03 sec) > [dewiki] 318 rows in set (0.39 sec) > [nlwiki] 58 rows in set (0.36 sec) > # Hebrew > [hewiki] 19 rows in set (0.05 sec) > # Multi-language > [commonswiki] 159 rows in set (0.64 sec) > [metawiki] 67 rows in set (0.34 sec) -- You are receiving this mail because: You are on the CC list for the bug. _______________________________________________ Wikibugs-l mailing list [email protected] https://lists.wikimedia.org/mailman/listinfo/wikibugs-l
