mysql:research@s3-analytics-slave [log]> select wiki, count(*) as c, event_label, event_url from RecentChangesTopLinks_16732249 where timestamp between '20170522000000' and '20170528235959' and wiki='enwiki' group by event_url order by c desc; +--------+-----+---------------------------+----------------------------------------------------------------------------------------------------------------------+ | wiki | c | event_label | event_url | +--------+-----+---------------------------+----------------------------------------------------------------------------------------------------------------------+ | enwiki | 144 | New pages | https://en.wikipedia.org/wiki/Special:NewPagesFeed | | enwiki | 132 | IPs' contribs | https://en.wikipedia.org/w/index.php?title=Special:Recentchanges&hideliu=1&hideanons=0 | | enwiki | 67 | Mobile contribs | https://en.wikipedia.org/w/index.php?namespace=&tagfilter=mobile+edit&title=Special%3ARecentChanges | | enwiki | 37 | New editors' contribs | https://en.wikipedia.org/w/index.php?title=Special:Contributions&contribs=newbie | | enwiki | 20 | Vital articles | https://en.wikipedia.org/w/index.php?title=Special:RecentChangesLinked&namespace=0&target=Wikipedia%3AVital+articles | | enwiki | 7 | RC patrol | https://en.wikipedia.org/wiki/Wikipedia:Recent_changes_patrol | | enwiki | 5 | What does this page mean? | https://en.wikipedia.org/wiki/Help:Recent_changes | | enwiki | 3 | Village pump | https://en.wikipedia.org/wiki/Wikipedia:Village_pump | | enwiki | 3 | Cleanup | https://en.wikipedia.org/wiki/Wikipedia:Cleanup | | enwiki | 3 | Vandalism | https://en.wikipedia.org/wiki/Wikipedia:Administrator_intervention_against_vandalism | | enwiki | 3 | Featured articles | https://en.wikipedia.org/wiki/Special:RecentChangesLinked/Wikipedia:Featured_articles | | enwiki | 2 | This page | https://en.wikipedia.org/wiki/MediaWiki:Recentchangestext | | enwiki | 2 | Deletion | https://en.wikipedia.org/wiki/Wikipedia:Articles_for_deletion | | enwiki | 2 | Wikipedia Signpost | https://en.wikipedia.org/wiki/Wikipedia:Wikipedia_Signpost | | enwiki | 2 | Good articles | https://en.wikipedia.org/wiki/Special:RecentChangesLinked/Wikipedia:Good_articles/all | | enwiki | 2 | Discuss this page | https://en.wikipedia.org/wiki/MediaWiki_talk:Recentchangestext | | enwiki | 2 | New pages | https://en.m.wikipedia.org/wiki/Special:NewPagesFeed | | enwiki | 1 | Mailing lists | https://en.wikipedia.org/wiki/Wikipedia:Mailing_lists | | enwiki | 1 | Policy | https://en.wikipedia.org/wiki/Wikipedia:Policies_and_guidelines | | enwiki | 1 | FAQ | https://en.wikipedia.org/wiki/Wikipedia:FAQ | | enwiki | 1 | Living people | https://en.wikipedia.org/wiki/Special:RecentChangesLinked/Category:Living_people | | enwiki | 1 | Chat | https://en.m.wikipedia.org/wiki/Wikipedia:IRC | | enwiki | 1 | Milestones | https://en.m.wikipedia.org/wiki/Wikipedia:Milestones | | enwiki | 1 | Featured articles | https://en.m.wikipedia.org/wiki/Special:RecentChangesLinked/Wikipedia:Featured_articles | | enwiki | 1 | Introduction | https://en.wikipedia.org/wiki/Wikipedia:Introduction | +--------+-----+---------------------------+----------------------------------------------------------------------------------------------------------------------+ 25 rows in set (0.01 sec)