Underlying SQL queries for the data published in this Mastodon post:
Total number of batches:
MariaDB [s53976__quickcategories]> SELECT COUNT(*) FROM batch;
+----------+
| COUNT(*) |
+----------+
| 10180 |
+----------+
1 row in set (0,021 sec)
Batches with at least one edit:
MariaDB [s53976__quickcategories]> SELECT COUNT(DISTINCT batch_id) FROM batch JOIN command ON command_batch = batch_id WHERE command_status = 1; -- DatabaseBatchStore._COMMAND_STATUS_EDIT
+--------------------------+
| COUNT(DISTINCT batch_id) |
+--------------------------+
| 9473 |
+--------------------------+
1 row in set (3,129 sec)
Total number of tool users creating batches:
MariaDB [s53976__quickcategories]> SELECT COUNT(DISTINCT localuser_global_user_id) FROM localuser;
+------------------------------------------+
| COUNT(DISTINCT localuser_global_user_id) |
+------------------------------------------+
| 135 |
+------------------------------------------+
1 row in set (0,001 sec)
Total number of edits:
MariaDB [s53976__quickcategories]> SELECT COUNT(*) FROM command WHERE command_status = 1; -- DatabaseBatchStore._COMMAND_STATUS_EDIT
+----------+
| COUNT(*) |
+----------+
| 1662775 |
+----------+
1 row in set (0,850 sec)
Total number of wikis:
MariaDB [s53976__quickcategories]> SELECT COUNT(*) FROM domain;
+----------+
| COUNT(*) |
+----------+
| 59 |
+----------+
1 row in set (0,002 sec)
Wikis with most edits:
MariaDB [s53976__quickcategories]> SELECT domain_name, COUNT(*) FROM batch JOIN command ON command_batch = batch_id JOIN domain ON batch_domain = domain_id WHERE command_status = 1 GROUP BY domain_name ORDER BY COUNT(*) DESC LIMIT 10;
+-------------------------+----------+
| domain_name | COUNT(*) |
+-------------------------+----------+
| commons.wikimedia.org | 666219 |
| ca.wikipedia.org | 524297 |
| eu.wikipedia.org | 200528 |
| es.wikipedia.org | 154409 |
| ro.wikipedia.org | 38960 |
| he.wikisource.org | 26590 |
| lv.wikipedia.org | 13894 |
| en.wikipedia.org | 8907 |
| incubator.wikimedia.org | 8025 |
| pt.wikipedia.org | 6114 |
+-------------------------+----------+
10 rows in set (3,600 sec)