enwiki RecentChangesLinks stats week of 2017-05-22
ActivePublic
Actions

Authored by Catrope on May 31 2017, 4:08 PM.

Project Tags

Referenced Files

	F8221918: enwiki RecentChangesLinks stats week of 2017-05-22
	May 31 2017, 4:08 PM

Subscribers

None

	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)

Event Timeline

Catrope created this paste.May 31 2017, 4:08 PM

Catrope mentioned this in T166623: Actually get the numbers for how frequently RC Page related links are clicked. .May 31 2017, 4:18 PM

	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)

enwiki RecentChangesLinks stats week of 2017-05-22ActivePublicActions

Event Timeline

enwiki RecentChangesLinks stats week of 2017-05-22
ActivePublic
Actions