mysql:research@x1-analytics-slave [flowdb]> SELECT COUNT(*), rev_user_wiki FROM flow_revision WHERE rev_flags = 'external' GROUP BY rev_user_wiki;
+----------+---------------+
| COUNT(*) | rev_user_wiki |
+----------+---------------+
|        1 | cawiki        |
|       21 | enwiki        |
|       13 | frwiki        |
|        1 | hewiki        |
|        2 | mediawikiwiki |
|        6 | metawiki      |
|    42385 | test2wiki     |
|       84 | testwiki      |
+----------+---------------+
8 rows in set (0.18 sec)