-- Total number events on enwiki between December 1 and 31 inclusive, broken down by beta vs non-beta
mysql:research@s3-analytics-slave [log]> select event_enhancedFiltersEnabled, count(*) from ChangesListFilters_16837986 where wiki='enwiki' and timestamp like '201712%' and event_pagename='Recentchanges' group by event_enhancedFiltersEnabled;
+------------------------------+----------+
| event_enhancedFiltersEnabled | count(*) |
+------------------------------+----------+
| 0 | 368523 |
| 1 | 156917 |
+------------------------------+----------+
2 rows in set (1 min 41.96 sec)
-- Type of change group:
-- hidepageedits=1 ("Page edits" removed)
mysql:research@s3-analytics-slave [log]> select event_enhancedFiltersEnabled, count(*) from ChangesListFilters_16837986 where wiki='enwiki' and timestamp like '201712%' and event_pagename='Recentchanges' and event_hidepageedits=1 group by event_enhancedFiltersEnabled ;
+------------------------------+----------+
| event_enhancedFiltersEnabled | count(*) |
+------------------------------+----------+
| 0 | 4100 |
| 1 | 4072 |
+------------------------------+----------+
2 rows in set (1 min 22.55 sec)
-- hidenewpages=1 ("Page creations" removed)
mysql:research@s3-analytics-slave [log]> select event_enhancedFiltersEnabled, count(*) from ChangesListFilters_16837986 where wiki='enwiki' and timestamp like '201712%' and event_pagename='Recentchanges' and event_hidenewpages=1 group by event_enhancedFiltersEnabled ;
+------------------------------+----------+
| event_enhancedFiltersEnabled | count(*) |
+------------------------------+----------+
| 0 | 18649 |
| 1 | 21451 |
+------------------------------+----------+
2 rows in set (1 min 21.27 sec)
-- hidelog=1 ("Logged actions" removed)
mysql:research@s3-analytics-slave [log]> select event_enhancedFiltersEnabled, count(*) from ChangesListFilters_16837986 where wiki='enwiki' and timestamp like '201712%' and event_pagename='Recentchanges' and event_hidelog=1 group by event_enhancedFiltersEnabled ;
+------------------------------+----------+
| event_enhancedFiltersEnabled | count(*) |
+------------------------------+----------+
| 0 | 25747 |
| 1 | 43195 |
+------------------------------+----------+
2 rows in set (1 min 20.74 sec)
-- hidecategorization=0 ("Categorization" shown) even though preference is set to hide categorization
mysql:research@s3-analytics-slave [log]> select event_enhancedFiltersEnabled, count(*) from ChangesListFilters_16837986 left join enwiki.user_properties on up_user=event_userId and up_property='hidecategorization' where wiki='enwiki' and timestamp like '201712%' and event_pagename='Recentchanges' and event_hidecategorization=0 and (up_value !='0' or up_value is null) group by event_enhancedFiltersEnabled;
-- hidecategorization=1 ("Categorization" not shown) even though preference is to show categorization
mysql:research@s3-analytics-slave [log]> select event_enhancedFiltersEnabled, count(*) from ChangesListFilters_16837986 left join enwiki.user_properties on up_user=event_userId and up_property='hidecategorization' where wiki='enwiki' and timestamp like '201712%' and event_pagename='Recentchanges' and event_hidecategorization=1 and up_value='0' group by event_enhancedFiltersEnabled;
-- hideWikibase=0 ("Wikidata" shown) even though preference is to not show Wikidata
mysql:research@s3-analytics-slave [log]> select event_enhancedFiltersEnabled, count(*) from ChangesListFilters_16837986 left join enwiki.user_properties on up_user=event_userId and up_property='rcshowwikidata' where wiki='enwiki' and timestamp like '201712%' and event_pagename='Recentchanges' and event_hideWikibase=0 and (up_value !='1' or up_value is null) group by event_enhancedFiltersEnabled;
-- hideWikibase=1 ("Wikidata" not shown) even though preference is to show Wikidata
mysql:research@s3-analytics-slave [log]> select event_enhancedFiltersEnabled, count(*) from ChangesListFilters_16837986 left join enwiki.user_properties on up_user=event_userId and up_property='rcshowwikidata' where wiki='enwiki' and timestamp like '201712%' and event_pagename='Recentchanges' and event_hideWikibase=1 and up_value=1 group by event_enhancedFiltersEnabled;
-- Edits by others/self:
-- hidemyself=1 ("Edits by others" only)
mysql:research@s3-analytics-slave [log]> select event_enhancedFiltersEnabled, count(*) from ChangesListFilters_16837986 where wiki='enwiki' and timestamp like '201712%' and event_pagename='Recentchanges' and event_hidemyself=1 group by event_enhancedFiltersEnabled ;
+------------------------------+----------+
| event_enhancedFiltersEnabled | count(*) |
+------------------------------+----------+
| 0 | 2460 |
| 1 | 41615 |
+------------------------------+----------+
2 rows in set (1 min 21.10 sec)
-- hidebyothers=1 ("Edits by myself" only)
mysql:research@s3-analytics-slave [log]> select event_enhancedFiltersEnabled, count(*) from ChangesListFilters_16837986 where wiki='enwiki' and timestamp like '201712%' and event_pagename='Recentchanges' and event_hidebyothers=1 group by event_enhancedFiltersEnabled ;
+------------------------------+----------+
| event_enhancedFiltersEnabled | count(*) |
+------------------------------+----------+
| 0 | 850 |
| 1 | 281 |
+------------------------------+----------+
2 rows in set (1 min 20.98 sec)
-- Major/minor:
-- hideminor=1 ("Non-minor edits" only)
mysql:research@s3-analytics-slave [log]> select event_enhancedFiltersEnabled, count(*) from ChangesListFilters_16837986 where wiki='enwiki' and timestamp like '201712%' and event_pagename='Recentchanges' and event_hideminor=1 group by event_enhancedFiltersEnabled ;
+------------------------------+----------+
| event_enhancedFiltersEnabled | count(*) |
+------------------------------+----------+
| 0 | 1369 |
| 1 | 2000 |
+------------------------------+----------+
2 rows in set (1 min 21.93 sec)
-- hidemajor=1 ("Minor edits" only)
mysql:research@s3-analytics-slave [log]> select event_enhancedFiltersEnabled, count(*) from ChangesListFilters_16837986 where wiki='enwiki' and timestamp like '201712%' and event_pagename='Recentchanges' and event_hidemajor=1 group by event_enhancedFiltersEnabled ;
-- Bots/humans:
-- hidehumans=1 ("Bots" only)
mysql:research@s3-analytics-slave [log]> select event_enhancedFiltersEnabled, count(*) from ChangesListFilters_16837986 where wiki='enwiki' and timestamp like '201712%' and event_pagename='Recentchanges' and event_hidehumans=1 group by event_enhancedFiltersEnabled ;
+------------------------------+----------+
| event_enhancedFiltersEnabled | count(*) |
+------------------------------+----------+
| 0 | 61 |
| 1 | 16 |
+------------------------------+----------+
2 rows in set (1 min 20.92 sec)
-- hidebots=0 (both bots and humans; default state is "Humans only")
mysql:research@s3-analytics-slave [log]> select event_enhancedFiltersEnabled, count(*) from ChangesListFilters_16837986 where wiki='enwiki' and timestamp like '201712%' and event_pagename='Recentchanges' and event_hidebots=0 group by event_enhancedFiltersEnabled ;
+------------------------------+----------+
| event_enhancedFiltersEnabled | count(*) |
+------------------------------+----------+
| 0 | 13 |
| 1 | 3 |
+------------------------------+----------+
2 rows in set (1 min 20.90 sec)
-- hidepatrolled/hideunpatrolled and hideReviewed are N/A on enwiki
-- User registration:
-- hideliu=1 ("Unregistered users" only)
mysql:research@s3-analytics-slave [log]> select event_enhancedFiltersEnabled, count(*) from ChangesListFilters_16837986 where wiki='enwiki' and timestamp like '201712%' and event_pagename='Recentchanges' and event_hideliu=1 group by event_enhancedFiltersEnabled ;
+------------------------------+----------+
| event_enhancedFiltersEnabled | count(*) |
+------------------------------+----------+
| 0 | 2916 |
| 1 | 10 |
+------------------------------+----------+
2 rows in set (1 min 22.20 sec)
-- hideanon=1 ("Registered users" only)
mysql:research@s3-analytics-slave [log]> select event_enhancedFiltersEnabled, count(*) from ChangesListFilters_16837986 where wiki='enwiki' and timestamp like '201712%' and event_pagename='Recentchanges' and event_hideanons=1 group by event_enhancedFiltersEnabled ;
+------------------------------+----------+
| event_enhancedFiltersEnabled | count(*) |
+------------------------------+----------+
| 0 | 3 |
+------------------------------+----------+
1 row in set (1 min 20.54 sec)
-- User experience level: (note that registered/unregistered moved into this group on 7/28)
mysql:research@s3-analytics-slave [log]> select event_userExpLevel, count(*) from ChangesListFilters_16837986 where wiki='enwiki' and timestamp like '201712%' and event_pagename ='Recentchanges' group by event_userExpLevel ;
mysql:research@s3-analytics-slave [log]> select event_enhancedFiltersEnabled, count(*) from ChangesListFilters_16837986 where wiki='enwiki' and timestamp like '201712%' and event_pagename='Recentchanges' and event_hidenondamaging=1 group by event_enhancedFiltersEnabled ;
+------------------------------+----------+
| event_enhancedFiltersEnabled | count(*) |
+------------------------------+----------+
| 0 | 1954 |
| 1 | 100 |
+------------------------------+----------+
2 rows in set (1 min 20.93 sec)
-- Damaging filters:
mysql:research@s3-analytics-slave [log]> select event_damaging, count(*) from ChangesListFilters_16837986 where wiki='enwiki' and timestamp like '201712%' and event_pagename ='Recentchanges' group by event_damaging ;
+------------------------------------+----------+
| event_damaging | count(*) |
+------------------------------------+----------+
| NULL | 381525 |
| all | 1056 |
| likelybad | 21832 |
| likelybad;verylikelybad | 87576 |
| likelygood | 1909 |
| likelygood;likelybad | 37 |
| likelygood;likelybad;verylikelybad | 38 |
| likelygood;maybebad | 115 |
| likelygood;maybebad;likelybad | 24 |
| likelygood;verylikelybad | 10 |
| maybebad | 14124 |
| maybebad;likelybad | 1109 |
| maybebad;likelybad;verylikelybad | 13213 |
| maybebad;verylikelybad | 171 |
| verylikelybad | 2701 |
+------------------------------------+----------+
15 rows in set (1 min 24.90 sec)
-- Good faith filters:
mysql:research@s3-analytics-slave [log]> select event_goodfaith, count(*) from ChangesListFilters_16837986 where wiki='enwiki' and timestamp like '201712%' and event_pagename ='Recentchanges' group by event_goodfaith ;
+------------------------------------+----------+
| event_goodfaith | count(*) |
+------------------------------------+----------+
| NULL | 401082 |
| all | 640 |
| likelybad | 24261 |
| likelybad;verylikelybad | 43342 |
| likelygood | 1519 |
| likelygood;likelybad | 17 |
| likelygood;likelybad;verylikelybad | 10 |
| likelygood;maybebad | 749 |
| likelygood;maybebad;likelybad | 9 |
| likelygood;maybebad;verylikelybad | 1 |
| likelygood;verylikelybad | 135 |
| maybebad | 4303 |
| maybebad;likelybad | 287 |
| maybebad;likelybad;verylikelybad | 45931 |
| maybebad;verylikelybad | 156 |
| verylikelybad | 2998 |
+------------------------------------+----------+
16 rows in set (1 min 24.37 sec)
-- Namespace filter:
-- Number of events where the namespace filter is set to anything at all:
mysql:research@s3-analytics-slave [log]> select event_enhancedFiltersEnabled, count(*) from ChangesListFilters_16837986 where wiki='enwiki' and timestamp like '201712%' and event_pagename='Recentchanges' and event_namespace is not null and event_namespace != '' group by event_enhancedFiltersEnabled ;
+------------------------------+----------+
| event_enhancedFiltersEnabled | count(*) |
+------------------------------+----------+
| 0 | 12206 |
| 1 | 4946 |
+------------------------------+----------+
2 rows in set, 1 warning (1 min 21.34 sec)
-- Number of events for each specific namespace:
mysql:research@s3-analytics-slave [log]> select event_enhancedFiltersEnabled, event_namespace, count(*) from ChangesListFilters_16837986 where wiki='enwiki' and timestamp like '201712%' and event_pagename ='Recentchanges' group by event_enhancedFiltersEnabled, event_namespace;
-- Note that no uses of multiple namespace filters appear in the data; this is a bug, oops!
-- "Associated namespace" checkbox (no longer available in beta):
mysql:research@s3-analytics-slave [log]> select event_enhancedFiltersEnabled, count(*) from ChangesListFilters_16837986 where wiki='enwiki' and timestamp like '201712%' and event_pagename='Recentchanges' and event_associated is not null and event_associated != '' group by event_enhancedFiltersEnabled ;
+------------------------------+----------+
| event_enhancedFiltersEnabled | count(*) |
+------------------------------+----------+
| 0 | 1362 |
+------------------------------+----------+
1 row in set, 1 warning (1 min 22.28 sec)
-- Invert namespace selection:
mysql:research@s3-analytics-slave [log]> select event_enhancedFiltersEnabled, count(*) from ChangesListFilters_16837986 where wiki='enwiki' and timestamp like '201712%' and event_pagename='Recentchanges' and event_invert is not null and event_invert != '' group by event_enhancedFiltersEnabled ;
+------------------------------+----------+
| event_enhancedFiltersEnabled | count(*) |
+------------------------------+----------+
| 0 | 1284 |
| 1 | 68 |
+------------------------------+----------+
2 rows in set, 1 warning (1 min 23.54 sec)
-- Tag filter used:
-- Number of events where tag filter is used at all:
mysql:research@s3-analytics-slave [log]> select event_enhancedFiltersEnabled, count(*) from ChangesListFilters_16837986 where wiki='enwiki' and timestamp like '201712%' and event_pagename='Recentchanges' and event_tagfilter is not null and event_tagfilter != '' group by event_enhancedFiltersEnabled ;
+------------------------------+----------+
| event_enhancedFiltersEnabled | count(*) |
+------------------------------+----------+
| 0 | 10505 |
| 1 | 28947 |
+------------------------------+----------+
2 rows in set (1 min 23.32 sec)
-- Top 10 most popular tag filters overall:
mysql:research@s3-analytics-slave [log]> select event_tagfilter, count(*) as c from ChangesListFilters_16837986 where wiki='enwiki' and timestamp like '201712%' and event_pagename ='Recentchanges' and event_tagfilter is not null group by event_tagfilter order by c desc limit 10;
| de-userfying|adding email address|removal of articles for deletion template|Extraneous formatting|OAuth CID: 21|mw-blank|blanking|canned edit summary|categories removed|changing height or weight|Citing predatory open access journal|removal of COI template|removal of copyvio templates|extraneous markup|bad external|large plot addition|large unwikified new article|new blank article|Rapid reverts|non-English content|nonsense characters|possible libel or vandalism|possible cut and paste move|possible vandalism|Possible vandalism|reference list removal|references removed|removal of Category:Living People|possible link spam|repeating characters|mw-replace|reverting anti-vandal bot|Section blanking|shouting|removal of speedy deletion templates|wikilinks removed | 2470 |
| possible libel or vandalism | 1963 |
| de-userfying | 615 |
| repeating characters | 584 |
| mw-changed-redirect-target | 363 |
| mw-blank|blanking|canned edit summary|removal of COI template|large unwikified new article|nonsense characters|possible libel or vandalism|coi-spam|possible cut and paste move|Possible self promotion in userspace|userspace spam|possible vandalism|Possible vandalism|repeating characters|mw-replace|reverting anti-vandal bot|Section blanking|shouting|removal of speedy deletion templates|very short new article | 359 |
-- Top 20 broken out by beta/non-beta and tag filter:
mysql:research@s3-analytics-slave [log]> select event_enhancedFiltersEnabled, event_tagfilter, count(*) as c from ChangesListFilters_16837986 where wiki='enwiki' and timestamp like '201712%' and event_pagename ='Recentchanges' and event_tagfilter is not null group by event_enhancedFiltersEnabled, event_tagfilter order by c desc limit 20;
| 1 | de-userfying|adding email address|removal of articles for deletion template|Extraneous formatting|OAuth CID: 21|mw-blank|blanking|canned edit summary|categories removed|changing height or weight|Citing predatory open access journal|removal of COI template|removal of copyvio templates|extraneous markup|bad external|large plot addition|large unwikified new article|new blank article|Rapid reverts|non-English content|nonsense characters|possible libel or vandalism|possible cut and paste move|possible vandalism|Possible vandalism|reference list removal|references removed|removal of Category:Living People|possible link spam|repeating characters|mw-replace|reverting anti-vandal bot|Section blanking|shouting|removal of speedy deletion templates|wikilinks removed | 2470 |
| 0 | Possible self promotion in userspace | 2421 |
| 0 | possible libel or vandalism | 1834 |
| 1 | Possible self promotion in userspace | 849 |
| 0 | de-userfying | 615 |
| 0 | repeating characters | 501 |
| 1 | mw-blank|blanking|canned edit summary|removal of COI template|large unwikified new article|nonsense characters|possible libel or vandalism|coi-spam|possible cut and paste move|Possible self promotion in userspace|userspace spam|possible vandalism|Possible vandalism|repeating characters|mw-replace|reverting anti-vandal bot|Section blanking|shouting|removal of speedy deletion templates|very short new article | 359 |