Paste P7264

Edits per 10 minutes in the last 2 hours
ActivePublic
Actions

Authored by jcrespo on Jun 15 2018, 1:04 PM.

Tags

None

Referenced Files

	F22261344: Edits per 10 minutes in the last 2 hours
	Jun 15 2018, 1:04 PM

Subscribers

None

	root@db1068[commonswiki]> SELECT LEFT(rev_timestamp, 11) AS 10minute, count(*) FROM revision where rev_timestamp > '2018061511' GROUP BY LEFT(rev_timestamp, 11);
	+-------------+----------+
	\| 10minute \| count(*) \|
	+-------------+----------+
	\| 20180615110 \| 725 \|
	\| 20180615111 \| 715 \|
	\| 20180615112 \| 553 \|
	\| 20180615113 \| 643 \|
	\| 20180615114 \| 686 \|
	\| 20180615115 \| 571 \|
	\| 20180615120 \| 551 \|
	\| 20180615121 \| 602 \|
	\| 20180615122 \| 817 \|
	\| 20180615123 \| 725 \|
	\| 20180615124 \| 698 \|
	\| 20180615125 \| 633 \|
	\| 20180615130 \| 125 \|
	+-------------+----------+
	13 rows in set (0.00 sec)

Event Timeline

jcrespo created this paste.Jun 15 2018, 1:04 PM