Paste P5515

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

Authored by Catrope on May 31 2017, 3:57 PM.

Tags

Referenced Files

	F8221887: ruwiki RecentChangesLinks stats week of 2017-05-22
	May 31 2017, 3:57 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='ruwiki' group by event_url order by c desc;
	+--------+----+-------------------------------------------+-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
	\| wiki \| c \| event_label \| event_url \|
	+--------+----+-------------------------------------------+-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
	\| ruwiki \| 17 \| К удалению \| https://ru.wikipedia.org/wiki/%D0%92%D0%B8%D0%BA%D0%B8%D0%BF%D0%B5%D0%B4%D0%B8%D1%8F:%D0%9A_%D1%83%D0%B4%D0%B0%D0%BB%D0%B5%D0%BD%D0%B8%D1%8E \|
	\| ruwiki \| 2 \| Журналы \| https://ru.wikipedia.org/wiki/%D0%A1%D0%BB%D1%83%D0%B6%D0%B5%D0%B1%D0%BD%D0%B0%D1%8F:%D0%96%D1%83%D1%80%D0%BD%D0%B0%D0%BB%D1%8B \|
	\| ruwiki \| 2 \| Запросы \| https://ru.wikipedia.org/wiki/%D0%92%D0%B8%D0%BA%D0%B8%D0%BF%D0%B5%D0%B4%D0%B8%D1%8F:%D0%97%D0%B0%D0%BF%D1%80%D0%BE%D1%81%D1%8B_%D0%BA_%D0%B0%D0%B4%D0%BC%D0%B8%D0%BD%D0%B8%D1%81%D1%82%D1%80%D0%B0%D1%82%D0%BE%D1%80%D0%B0%D0%BC \|
	\| ruwiki \| 1 \| Срабатывания фильтров \| https://ru.wikipedia.org/wiki/%D0%A1%D0%BB%D1%83%D0%B6%D0%B5%D0%B1%D0%BD%D0%B0%D1%8F:%D0%96%D1%83%D1%80%D0%BD%D0%B0%D0%BB_%D0%B7%D0%BB%D0%BE%D1%83%D0%BF%D0%BE%D1%82%D1%80%D0%B5%D0%B1%D0%BB%D0%B5%D0%BD%D0%B8%D0%B9 \|
	\| ruwiki \| 1 \| администраторам \| https://ru.wikipedia.org/wiki/%D0%92%D0%B8%D0%BA%D0%B8%D0%BF%D0%B5%D0%B4%D0%B8%D1%8F:%D0%90%D0%B4%D0%BC%D0%B8%D0%BD%D0%B8%D1%81%D1%82%D1%80%D0%B0%D1%82%D0%BE%D1%80%D1%8B_%D0%B2_%D1%81%D0%B5%D1%82%D0%B8 \|
	\| ruwiki \| 1 \| Правки новичков \| https://ru.wikipedia.org/w/index.php?title=%D0%A1%D0%BB%D1%83%D0%B6%D0%B5%D0%B1%D0%BD%D0%B0%D1%8F:Contributions&contribs=newbie \|
	\| ruwiki \| 1 \| К улучшению \| https://ru.wikipedia.org/wiki/%D0%92%D0%B8%D0%BA%D0%B8%D0%BF%D0%B5%D0%B4%D0%B8%D1%8F:%D0%9A_%D1%83%D0%BB%D1%83%D1%87%D1%88%D0%B5%D0%BD%D0%B8%D1%8E \|
	+--------+----+-------------------------------------------+-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
	7 rows in set (0.01 sec)

Event Timeline

Catrope created this paste.May 31 2017, 3:57 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

Liuxinyu970226 added a project: Russian-Sites.Jun 15 2017, 5:24 AM