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)