(An Untitled Masterwork)
ActivePublic
Actions

Authored by Marostegui on Feb 21 2019, 3:39 PM.

Tags

None

Referenced Files

	F28257896: raw.txt
	Feb 21 2019, 3:39 PM

Subscribers

None

	root@db2092.codfw.wmnet[enwiki]> select count(*),hour(rc_timestamp) as hour from recentchanges where hour(rc_timestamp)<24 group by hour(rc_timestamp);
	+----------+------+
	\| count(*) \| hour \|
	+----------+------+
	\| 334803 \| 0 \|
	\| 310542 \| 1 \|
	\| 319733 \| 2 \|
	\| 333288 \| 3 \|
	\| 315909 \| 4 \|
	\| 266751 \| 5 \|
	\| 261608 \| 6 \|
	\| 244767 \| 7 \|
	\| 236362 \| 8 \|
	\| 270193 \| 9 \|
	\| 269207 \| 10 \|
	\| 261341 \| 11 \|
	\| 284674 \| 12 \|
	\| 320926 \| 13 \|
	\| 379169 \| 14 \|
	\| 376148 \| 15 \|
	\| 394381 \| 16 \|
	\| 418992 \| 17 \|
	\| 432924 \| 18 \|
	\| 422719 \| 19 \|
	\| 428801 \| 20 \|
	\| 406582 \| 21 \|
	\| 366599 \| 22 \|
	\| 344903 \| 23 \|
	+----------+------+
	24 rows in set (3.78 sec)

	root@db2092.codfw.wmnet[enwiki]> select count(*),hour(rc_timestamp) as hour from recentchanges where hour(rc_timestamp)<24 group by hour(rc_timestamp);
	+----------+------+
	\| count(*) \| hour \|
	+----------+------+
	\| 334803 \| 0 \|
	\| 310542 \| 1 \|
	\| 319733 \| 2 \|
	\| 333288 \| 3 \|
	\| 315909 \| 4 \|
	\| 266751 \| 5 \|
	\| 261608 \| 6 \|
	\| 244767 \| 7 \|
	\| 236362 \| 8 \|
	\| 270193 \| 9 \|
	\| 269207 \| 10 \|
	\| 261341 \| 11 \|
	\| 284674 \| 12 \|
	\| 320926 \| 13 \|
	\| 379169 \| 14 \|
	\| 376148 \| 15 \|
	\| 394381 \| 16 \|
	\| 418992 \| 17 \|
	\| 432924 \| 18 \|
	\| 422719 \| 19 \|
	\| 428801 \| 20 \|
	\| 406582 \| 21 \|
	\| 366599 \| 22 \|
	\| 344903 \| 23 \|
	+----------+------+
	24 rows in set (3.78 sec)

(An Untitled Masterwork)ActivePublicActions