While looking into T111605 I saw that, at least on de.wiki, there are multiple revisions where rev_user_text doesn't agree with user_name. They seem to be renamed users, no idea whether it has to do with import or not.
Cf. {T47746}
```
MariaDB [dewiki_p]> SELECT rev_id, rev_user_text, user_name FROM revision JOIN logging ON rev_page = log_page AND log_type = 'import' JOIN user ON user_id = rev_user AND user_name <> rev_user_text WHERE rev_user > 0 AND rev_user_text NOT RLIKE '(^([0-9]{1,3}[.]){3}[0-9]{1,3}$|^([[:alnum:]]{1,4}[:]){7})' AND rev_page > 0 AND rev_timestamp < log_timestamp;
+----------+------------------+----------------+
| rev_id | rev_user_text | user_name |
+----------+------------------+----------------+
| 65704381 | Justbridge | Justus Brücke |
| 65704381 | Justbridge | Justus Brücke |
| 70359432 | Daniele Pugliesi | Aushulz |
| 71300545 | Justbridge | Justus Brücke |
| 71055673 | Onee | O.Koslowski |
| 71552070 | Wolf32at | DerGraueWolf |
| 71565974 | Justbridge | Justus Brücke |
| 72031462 | Schomynv | Mme Mim |
| 71521249 | Wolf32at | DerGraueWolf |
| 72188986 | Justbridge | Justus Brücke |
| 72189041 | Justbridge | Justus Brücke |
| 76268012 | Daniele Pugliesi | Aushulz |
| 80066897 | Wolf32at | DerGraueWolf |
| 80104475 | Wolf32at | DerGraueWolf |
| 80104490 | Wolf32at | DerGraueWolf |
| 80275224 | Wolf32at | DerGraueWolf |
| 81711131 | Schomynv | Mme Mim |
| 82198242 | Wolf32at | DerGraueWolf |
| 82696379 | Onee | O.Koslowski |
| 82161477 | Wolf32at | DerGraueWolf |
| 83372859 | Schomynv | Mme Mim |
| 84881377 | Daniele Pugliesi | Aushulz |
| 84881378 | Daniele Pugliesi | Aushulz |
| 71243433 | Wolf32at | DerGraueWolf |
| 88657167 | Wolf32at | DerGraueWolf |
| 88657167 | Wolf32at | DerGraueWolf |
| 88657167 | Wolf32at | DerGraueWolf |
| 88657167 | Wolf32at | DerGraueWolf |
| 88657167 | Wolf32at | DerGraueWolf |
| 88657167 | Wolf32at | DerGraueWolf |
| 88657167 | Wolf32at | DerGraueWolf |
| 88838955 | Wolf32at | DerGraueWolf |
| 88838955 | Wolf32at | DerGraueWolf |
| 88914751 | Wolf32at | DerGraueWolf |
| 88914751 | Wolf32at | DerGraueWolf |
| 88914751 | Wolf32at | DerGraueWolf |
| 88914751 | Wolf32at | DerGraueWolf |
| 88914751 | Wolf32at | DerGraueWolf |
| 88914751 | Wolf32at | DerGraueWolf |
| 88914751 | Wolf32at | DerGraueWolf |
| 89043632 | Wolf32at | DerGraueWolf |
| 89043632 | Wolf32at | DerGraueWolf |
| 89043632 | Wolf32at | DerGraueWolf |
| 89043632 | Wolf32at | DerGraueWolf |
| 89043632 | Wolf32at | DerGraueWolf |
| 89043632 | Wolf32at | DerGraueWolf |
| 89043632 | Wolf32at | DerGraueWolf |
| 89043632 | Wolf32at | DerGraueWolf |
| 89093460 | Wolf32at | DerGraueWolf |
| 89093460 | Wolf32at | DerGraueWolf |
| 89093460 | Wolf32at | DerGraueWolf |
| 89093460 | Wolf32at | DerGraueWolf |
| 89093460 | Wolf32at | DerGraueWolf |
| 89093460 | Wolf32at | DerGraueWolf |
| 89093460 | Wolf32at | DerGraueWolf |
| 89093460 | Wolf32at | DerGraueWolf |
| 89142041 | Wolf32at | DerGraueWolf |
| 89142041 | Wolf32at | DerGraueWolf |
| 89142041 | Wolf32at | DerGraueWolf |
| 89142041 | Wolf32at | DerGraueWolf |
| 89142041 | Wolf32at | DerGraueWolf |
| 89142041 | Wolf32at | DerGraueWolf |
| 89142041 | Wolf32at | DerGraueWolf |
| 89142041 | Wolf32at | DerGraueWolf |
| 89178635 | Wolf32at | DerGraueWolf |
| 89178635 | Wolf32at | DerGraueWolf |
| 89178635 | Wolf32at | DerGraueWolf |
| 89178635 | Wolf32at | DerGraueWolf |
| 89178635 | Wolf32at | DerGraueWolf |
| 89178635 | Wolf32at | DerGraueWolf |
| 89178635 | Wolf32at | DerGraueWolf |
| 89178635 | Wolf32at | DerGraueWolf |
| 90316474 | Wolf32at | DerGraueWolf |
| 90316474 | Wolf32at | DerGraueWolf |
| 90316474 | Wolf32at | DerGraueWolf |
| 90316474 | Wolf32at | DerGraueWolf |
| 90392157 | Wolf32at | DerGraueWolf |
| 90392157 | Wolf32at | DerGraueWolf |
| 90392157 | Wolf32at | DerGraueWolf |
| 90392157 | Wolf32at | DerGraueWolf |
| 90452954 | Wolf32at | DerGraueWolf |
| 90452954 | Wolf32at | DerGraueWolf |
| 90452954 | Wolf32at | DerGraueWolf |
| 90452954 | Wolf32at | DerGraueWolf |
| 90470725 | Wolf32at | DerGraueWolf |
| 90470725 | Wolf32at | DerGraueWolf |
| 71309622 | Justbridge | Justus Brücke |
| 94168877 | Wolf32at | DerGraueWolf |
| 94168879 | Wolf32at | DerGraueWolf |
| 94169816 | Wolf32at | DerGraueWolf |
| 94169818 | Wolf32at | DerGraueWolf |
| 94751417 | Wolf32at | DerGraueWolf |
| 95715586 | GoAvs | Avaholic |
| 98491034 | Schomynv | Mme Mim |
| 99800361 | Daniele Pugliesi | Aushulz |
| 99800362 | Daniele Pugliesi | Aushulz |
| 99800365 | Daniele Pugliesi | Aushulz |
| 70093631 | Justbridge | Justus Brücke |
| 70093644 | Justbridge | Justus Brücke |
| 70093693 | Justbridge | Justus Brücke |
| 70093739 | Justbridge | Justus Brücke |
| 80124540 | Wolf32at | DerGraueWolf |
+----------+------------------+----------------+
102 rows in set (1 min 3.93 sec)
```
Query too slow to run:
```SELECT rev_id, rev_user_text, user_name
-> FROM revision
-> JOIN user
-> ON user_id = rev_user
-> AND user_name <> rev_user_text;```