MariaDB [wikidatawiki_p]> desc revtag;
+-------------+---------------------+------+-----+---------+-------+
| Field       | Type                | Null | Key | Default | Extra |
+-------------+---------------------+------+-----+---------+-------+
| rt_type     | varbinary(60)       | NO   |     | NULL    |       |
| rt_page     | bigint(20) unsigned | NO   |     | NULL    |       |
| rt_revision | bigint(20) unsigned | NO   |     | NULL    |       |
| rt_value    | blob                | YES  |     | NULL    |       |
+-------------+---------------------+------+-----+---------+-------+
4 rows in set (0,002 sec)

MariaDB [wikidatawiki_p]>

MariaDB [wikidatawiki]> select page_namespace, count(page_id) from page INNER JOIN revtag ON (page_id = rt_page) where rt_revision = 2147483647 group by page_namespace;
+----------------+----------------+
| page_namespace | count(page_id) |
+----------------+----------------+
|              4 |              2 |
|             12 |              1 |
|           1198 |           1010 |
+----------------+----------------+
3 rows in set (0.029 sec)

MariaDB [wikidatawiki]> select distinct rt_type from revtag where rt_revision = 2147483647;
+-------------+
| rt_type     |
+-------------+
| fuzzy       |
| tp:mark     |
| tp:tag      |
| tp:transver |
+-------------+
4 rows in set (0.002 sec)
MariaDB [wikidatawiki]> select rt_type, count(rt_type) from revtag where rt_revision = 2147483647 group by rt_type;
+-------------+----------------+
| rt_type     | count(rt_type) |
+-------------+----------------+
| fuzzy       |             15 |
| tp:mark     |              1 |
| tp:tag      |              2 |
| tp:transver |           1042 |
+-------------+----------------+
4 rows in set (0.002 sec)

mysql:research@dbstore1009.eqiad.wmnet [wikidatawiki]> SELECT trr_revision, COUNT(*) FROM translate_reviews WHERE trr_revision >= 2130000000 GROUP BY trr_revision ORDER BY trr_revision ASC;
+--------------+----------+
| trr_revision | COUNT(*) |
+--------------+----------+
|   2131243224 |        1 |
|   2131243602 |        1 |
|   2131243677 |        1 |
|   2131243747 |        1 |
|   2134240427 |        1 |
|   2134249853 |        1 |
|   2136744814 |        1 |
|   2136746153 |        1 |
|   2138381191 |        1 |
|   2138382550 |        1 |
|   2140210428 |        2 |
|   2142160688 |        2 |
|   2147483647 |        4 |
+--------------+----------+
13 rows in set (0.032 sec)