User:Pathoschild/Translators by activity
These lists sorts fluent speakers of each language by the date of their last edit, limited to the 100 last active. These lists are based on Meta's standard language categories. "Fluent" speakers are those with self-assessed levels 3, 4, or N.
Lists
editlast update: 2008-03-28 (6128 days ago)
| Name | Last edit |
|---|---|
| Spiritia | 2008-03-20 (6135 days ago) |
| Timurberk | 2008-02-04 (6180 days ago) |
| Daggerstab | 2008-01-19 (6196 days ago) |
| 5ko | 2008-01-01 (6214 days ago) |
| Azimski | 2007-09-19 (6318 days ago) |
| Nk | 2007-06-28 (6401 days ago) |
| Vanka5 | 2007-05-25 (6435 days ago) |
| Sharkb | 2007-01-21 (6559 days ago) |
| Bggoldie | 2006-12-19 (6592 days ago) |
| DCLXVI | 2006-08-06 (6727 days ago) |
| Smartech | 2006-04-14 (6841 days ago) |
| Glimz | 2006-04-02 (6853 days ago) |
| Espetkov | 2005-06-05 (7154 days ago) |
13 rows in set (56.82 sec)
last update: 2008-03-28 (6128 days ago)
| Name | Last edit |
|---|---|
| Bellayet | 2008-03-26 (6129 days ago) |
| Aeetlrsk | 2008-02-04 (6180 days ago) |
| Frdayeen | 2008-01-08 (6207 days ago) |
| Hermitage17 | 2008-01-08 (6207 days ago) |
4 rows in set (9.26 sec)
last update: 2008-03-28 (6128 days ago)
| Name | Last edit |
|---|---|
| AtteL | 2008-03-25 (6130 days ago) |
| Str4nd | 2008-03-24 (6131 days ago) |
| Roosa | 2008-03-05 (6151 days ago) |
| Malhonen | 2008-02-13 (6171 days ago) |
| Ilaiho | 2007-12-25 (6221 days ago) |
| Argus | 2007-11-12 (6264 days ago) |
| Jariola | 2007-10-29 (6278 days ago) |
| Kyzyl | 2007-07-16 (6383 days ago) |
| Skuolfi | 2007-05-13 (6447 days ago) |
| Urvabara | 2007-02-08 (6541 days ago) |
| Jni | 2007-01-29 (6551 days ago) |
| NZ- | 2006-12-30 (6581 days ago) |
| Vilu | 2006-12-26 (6585 days ago) |
| Hartz | 2006-12-15 (6596 days ago) |
| Mzlla | 2006-12-07 (6604 days ago) |
| Inzulac | 2006-10-31 (6641 days ago) |
| Lauranen | 2006-10-02 (6670 days ago) |
| Totuus | 2006-09-05 (6697 days ago) |
| Anchjo | 2006-08-31 (6702 days ago) |
| Pwc | 2006-08-05 (6728 days ago) |
| Kouluhai | 2006-06-23 (6771 days ago) |
| Jniemenmaa | 2006-06-12 (6782 days ago) |
| Bobet | 2006-02-06 (6908 days ago) |
| Finlandia | 2005-12-28 (6948 days ago) |
| Hapsiainen | 2005-12-09 (6967 days ago) |
| Viznut | 2005-07-27 (7102 days ago) |
| Lanahard | 2005-07-21 (7108 days ago) |
| Rdnk | 2005-05-24 (7166 days ago) |
31 rows in set (55.17 sec)
last update: 2008-03-28 (6128 days ago)
| Name | Last edit |
|---|---|
| Spacebirdy | 2008-03-27 (6128 days ago) |
| Bengoa | 2008-03-27 (6128 days ago) |
| Kylu | 2008-03-27 (6128 days ago) |
| Julie | 2008-03-26 (6129 days ago) |
| Taichi | 2008-03-26 (6129 days ago) |
| Ascánder | 2008-03-26 (6129 days ago) |
| Smeira | 2008-03-26 (6129 days ago) |
| SMP | 2008-03-26 (6129 days ago) |
| Drini | 2008-03-26 (6129 days ago) |
| Rdsmith4 | 2008-03-25 (6130 days ago) |
| Masterches | 2008-03-25 (6130 days ago) |
| Wikimistusik | 2008-03-25 (6130 days ago) |
| Mikel | 2008-03-25 (6130 days ago) |
| Willtron | 2008-03-24 (6131 days ago) |
| CHV | 2008-03-24 (6131 days ago) |
| Tosão | 2008-03-23 (6132 days ago) |
| Redux | 2008-03-21 (6134 days ago) |
| Xic667 | 2008-03-21 (6134 days ago) |
| LaosLos | 2008-03-20 (6135 days ago) |
| BetoCG | 2008-03-17 (6138 days ago) |
| DamianFinol | 2008-03-16 (6139 days ago) |
| Jurock | 2008-03-13 (6142 days ago) |
| Oswaldo2025 | 2008-03-13 (6143 days ago) |
| Damërung | 2008-03-08 (6147 days ago) |
| Alhen | 2008-03-06 (6149 days ago) |
| Fajro | 2008-03-04 (6151 days ago) |
| LadyInGrey | 2008-03-03 (6152 days ago) |
| Barcex | 2008-03-02 (6153 days ago) |
| Alpertron | 2008-02-29 (6155 days ago) |
| Cromwellt | 2008-02-29 (6156 days ago) |
| RedCoat | 2008-02-28 (6156 days ago) |
| Sapey | 2008-02-20 (6164 days ago) |
| Elisardojm | 2008-02-20 (6164 days ago) |
| Lascorz | 2008-02-19 (6165 days ago) |
| Rastrojo | 2008-02-19 (6165 days ago) |
| Cedric31 | 2008-02-19 (6165 days ago) |
| Prevert | 2008-02-16 (6168 days ago) |
| Aleator | 2008-02-15 (6169 days ago) |
| Zuirdj | 2008-02-15 (6169 days ago) |
| Orereta | 2008-02-15 (6169 days ago) |
| FrancoGG | 2008-02-11 (6173 days ago) |
| Loco085 | 2008-02-10 (6174 days ago) |
| Agüeybaná | 2008-02-10 (6174 days ago) |
| Mtmelendez | 2008-02-08 (6176 days ago) |
| TXiKi | 2008-02-08 (6176 days ago) |
| SCPS | 2008-02-07 (6177 days ago) |
| Toliño | 2008-02-07 (6177 days ago) |
| Theklan | 2008-02-07 (6177 days ago) |
| ReyBrujo | 2008-02-05 (6179 days ago) |
| Vilallonga | 2008-01-30 (6185 days ago) |
| Gaudio | 2008-01-25 (6190 days ago) |
| AlimanRuna | 2008-01-24 (6191 days ago) |
| Xtv | 2008-01-19 (6196 days ago) |
| Vriullop | 2008-01-18 (6197 days ago) |
| Desiphral | 2008-01-16 (6199 days ago) |
| DDarkfire | 2008-01-15 (6201 days ago) |
| Jove | 2008-01-08 (6208 days ago) |
| Pepelopex | 2008-01-07 (6208 days ago) |
| Esbardu | 2008-01-07 (6208 days ago) |
| Carles | 2007-12-30 (6216 days ago) |
| Celestianpower | 2007-12-30 (6216 days ago) |
| RRmeta | 2007-12-30 (6217 days ago) |
| Axxgreazz | 2007-12-23 (6223 days ago) |
| Sobreira | 2007-12-22 (6224 days ago) |
| Varano | 2007-12-18 (6228 days ago) |
| Chlewey | 2007-12-17 (6229 days ago) |
| Javierm | 2007-12-13 (6233 days ago) |
| Kipmaster | 2007-12-10 (6236 days ago) |
| Adalbertofrenesi | 2007-12-07 (6239 days ago) |
| JB82 | 2007-12-06 (6241 days ago) |
| Patstuart | 2007-12-04 (6242 days ago) |
| Subtiempo | 2007-11-30 (6246 days ago) |
| Jaranda | 2007-11-30 (6246 days ago) |
| Mac | 2007-11-29 (6247 days ago) |
| Lmbuga | 2007-11-28 (6248 days ago) |
| Janfri | 2007-11-28 (6248 days ago) |
| Banjo | 2007-11-24 (6252 days ago) |
| Malvenko | 2007-11-23 (6253 days ago) |
| Iradigalesc | 2007-11-23 (6253 days ago) |
| Llull | 2007-11-23 (6253 days ago) |
| Lohen11 | 2007-11-21 (6255 days ago) |
| Vibragiel | 2007-11-20 (6256 days ago) |
| Sanbec | 2007-11-20 (6256 days ago) |
| Yrithinnd | 2007-11-19 (6257 days ago) |
| Bdenk715 | 2007-11-14 (6262 days ago) |
| Marianocecowski | 2007-11-12 (6264 days ago) |
| Kuartas | 2007-11-10 (6266 days ago) |
| GlimmerPhoenix | 2007-11-09 (6267 days ago) |
| Fryant | 2007-11-08 (6268 days ago) |
| Edub | 2007-10-28 (6279 days ago) |
| Jynus | 2007-10-24 (6283 days ago) |
| Prietoquilmes | 2007-10-21 (6286 days ago) |
| Spangineer | 2007-10-14 (6293 days ago) |
| Pcongre | 2007-10-13 (6294 days ago) |
| Rodasmith | 2007-10-11 (6296 days ago) |
| JorgeGG | 2007-10-08 (6299 days ago) |
| Battroid | 2007-10-06 (6302 days ago) |
| Morza | 2007-09-30 (6307 days ago) |
| Albdallah | 2007-09-29 (6308 days ago) |
| Albeiror24 | 2007-09-29 (6308 days ago) |
100 rows in set (1 min 17.61 sec)
last update: 2008-03-28 (6128 days ago)
| Name | Last edit |
|---|---|
| Ashishbhatnagar | 2008-02-22 (6162 days ago) |
| Rajeevmass | 2008-02-07 (6177 days ago) |
| Eukesh | 2008-02-03 (6181 days ago) |
| Shyam | 2008-01-10 (6205 days ago) |
| Srikeit | 2007-12-06 (6240 days ago) |
| Sanjaybafnaji | 2007-07-26 (6373 days ago) |
| Mexxian | 2007-05-27 (6433 days ago) |
| Spundun | 2007-03-30 (6491 days ago) |
| Shreshth91 | 2007-02-16 (6533 days ago) |
| Jdas07 | 2006-09-12 (6690 days ago) |
| Dineshjk | 2005-08-05 (7093 days ago) |
| Abhishekbh | 2005-04-21 (7199 days ago) |
12 rows in set (43.28 sec)
last update: 2008-03-28 (6128 days ago)
| Name | Last edit |
|---|---|
| Tuinui | 2008-03-27 (6128 days ago) |
| Bookman | 2008-03-27 (6128 days ago) |
| Aphaia | 2008-03-27 (6128 days ago) |
| Kahusi | 2008-03-26 (6129 days ago) |
| Me2hero | 2008-03-26 (6129 days ago) |
| Genppy | 2008-03-26 (6129 days ago) |
| Kanjy | 2008-03-25 (6130 days ago) |
| Ninomy | 2008-03-25 (6130 days ago) |
| Kzhr | 2008-03-25 (6130 days ago) |
| LERK | 2008-03-25 (6130 days ago) |
| ZCU | 2008-03-24 (6131 days ago) |
| ゆいしあす | 2008-03-24 (6131 days ago) |
| Marine-Blue | 2008-03-22 (6133 days ago) |
| Courant | 2008-03-22 (6133 days ago) |
| Miya | 2008-03-20 (6135 days ago) |
| Mulukhiyya | 2008-03-12 (6143 days ago) |
| Mzm5zbC3 | 2008-03-11 (6144 days ago) |
| Bletilla | 2008-03-08 (6147 days ago) |
| Aotake | 2008-03-08 (6147 days ago) |
| Widehawk | 2008-03-04 (6152 days ago) |
| おはぐろ蜻蛉 | 2008-02-28 (6156 days ago) |
| ネッツ | 2008-02-27 (6157 days ago) |
| NJT | 2008-02-24 (6160 days ago) |
| 朝彦 | 2008-02-24 (6161 days ago) |
| Yassie | 2008-02-21 (6163 days ago) |
| 辞典の虫 | 2008-02-16 (6169 days ago) |
| Tommy6 | 2008-02-13 (6171 days ago) |
| Peccafly | 2008-02-10 (6174 days ago) |
| Uryah | 2008-02-10 (6174 days ago) |
| Kstigarbha | 2008-02-03 (6181 days ago) |
| Bukki | 2008-02-03 (6182 days ago) |
| Bellcricket | 2008-02-02 (6182 days ago) |
| Sylphie | 2008-02-01 (6183 days ago) |
| Pica | 2008-02-01 (6183 days ago) |
| Quatro | 2008-01-30 (6185 days ago) |
| Miya.m | 2008-01-29 (6186 days ago) |
| Londonbashi | 2008-01-28 (6187 days ago) |
| Kickaha | 2008-01-27 (6188 days ago) |
| Co.kyoto | 2008-01-27 (6188 days ago) |
| Hirokun | 2008-01-27 (6188 days ago) |
| Complex01 | 2008-01-27 (6188 days ago) |
| 千代林檎 | 2008-01-26 (6189 days ago) |
| Lonicera | 2008-01-25 (6190 days ago) |
| ZERBERUS | 2008-01-25 (6190 days ago) |
| Hyolee2 | 2008-01-25 (6190 days ago) |
| Tangotango | 2008-01-18 (6197 days ago) |
| Lemonsquash | 2008-01-16 (6199 days ago) |
| Knua | 2008-01-12 (6203 days ago) |
| Michey.M | 2008-01-05 (6210 days ago) |
| SS95 | 2007-12-27 (6219 days ago) |
| Suzuyoshinine | 2007-12-21 (6225 days ago) |
| Horlicks | 2007-12-21 (6225 days ago) |
| Volfgang | 2007-12-16 (6230 days ago) |
| Watermint | 2007-12-14 (6232 days ago) |
| Schu | 2007-12-14 (6232 days ago) |
| Tietew | 2007-12-10 (6236 days ago) |
| Dekimasu | 2007-12-04 (6243 days ago) |
| Swind | 2007-12-03 (6243 days ago) |
| Kareha | 2007-12-01 (6245 days ago) |
| Tamtarm | 2007-11-29 (6247 days ago) |
| Clarin | 2007-11-29 (6247 days ago) |
| Kasuga | 2007-11-28 (6248 days ago) |
| 11ChamOK | 2007-11-28 (6248 days ago) |
| Kurihaya | 2007-11-28 (6248 days ago) |
| Lusheeta | 2007-11-28 (6248 days ago) |
| Noraneko | 2007-11-28 (6249 days ago) |
| Kotodama-Reverse | 2007-11-26 (6250 days ago) |
| T-coco | 2007-11-26 (6250 days ago) |
| Numerike | 2007-11-26 (6250 days ago) |
| 霧木諒二 | 2007-11-26 (6250 days ago) |
| Takot | 2007-11-25 (6251 days ago) |
| Himetv | 2007-10-24 (6283 days ago) |
| Remington | 2007-10-20 (6287 days ago) |
| SantaClaus | 2007-09-25 (6312 days ago) |
| T.Saito | 2007-09-24 (6313 days ago) |
| Tiens | 2007-09-18 (6319 days ago) |
| Coryjp | 2007-09-05 (6332 days ago) |
| Muyo | 2007-09-03 (6334 days ago) |
| Ribbon | 2007-08-16 (6352 days ago) |
| Penpen | 2007-08-08 (6361 days ago) |
| PiaCarrot | 2007-08-04 (6364 days ago) |
| YouShow | 2007-07-27 (6372 days ago) |
| Chinneeb | 2007-07-03 (6396 days ago) |
| HALPHA | 2007-07-01 (6398 days ago) |
| Tonync | 2007-05-17 (6443 days ago) |
| Araisyohei | 2007-04-21 (6469 days ago) |
| 七星 | 2007-04-21 (6469 days ago) |
| LQVX | 2007-04-16 (6475 days ago) |
| Goncyan | 2007-04-05 (6485 days ago) |
| 端くれの錬金術師 | 2007-04-02 (6488 days ago) |
| Matsumomushi | 2007-03-25 (6496 days ago) |
| かんがへなし | 2007-03-17 (6504 days ago) |
| Rocky7 | 2007-03-16 (6505 days ago) |
| Lonchi** | 2007-03-09 (6512 days ago) |
| っ | 2007-02-17 (6532 days ago) |
| Kkkdc | 2007-02-16 (6533 days ago) |
| Diagraph01 | 2007-02-06 (6543 days ago) |
| Pachayachachic | 2007-02-03 (6546 days ago) |
| Adr6721 | 2007-02-01 (6548 days ago) |
| Su-no-G | 2007-02-01 (6548 days ago) |
100 rows in set (1 min 2.26 sec)
last update: 2008-03-28 (6128 days ago)
| Name | Last edit |
|---|---|
| Azmi1995 | 2008-03-25 (6130 days ago) |
| IDRex | 2008-03-25 (6130 days ago) |
| IvanLanin | 2008-03-22 (6133 days ago) |
| Mimihitam | 2008-03-19 (6136 days ago) |
| Master2841 | 2008-03-08 (6147 days ago) |
| Chriswaterguy | 2008-03-07 (6149 days ago) |
| Borgx | 2008-03-04 (6152 days ago) |
| Kandar | 2008-02-18 (6166 days ago) |
| Meursault2004 | 2008-02-12 (6172 days ago) |
| Dragunova | 2008-02-08 (6176 days ago) |
| Hariadhi | 2007-08-03 (6365 days ago) |
| Irwangatot | 2007-06-12 (6417 days ago) |
| Anggoro | 2006-12-07 (6604 days ago) |
| Winana | 2006-11-22 (6619 days ago) |
| Anggreani | 2006-08-04 (6729 days ago) |
| HarisX | 2006-05-12 (6813 days ago) |
| Zaidpjd | 2005-11-20 (6986 days ago) |
| Widhiantoro | 2005-11-18 (6988 days ago) |
| Sudiryo | 2005-11-18 (6988 days ago) |
| *drew | 2005-11-08 (6998 days ago) |
20 rows in set (51.73 sec)
last update: 2008-03-28 (6128 days ago)
| Name | Last edit |
|---|---|
| SCriBu | 2008-02-24 (6160 days ago) |
| Cuman | 2008-01-25 (6190 days ago) |
| Desiphral | 2008-01-16 (6199 days ago) |
| IulianU | 2008-01-14 (6201 days ago) |
| AQUA | 2007-12-20 (6226 days ago) |
| Romihaitza | 2007-11-27 (6249 days ago) |
| BlueMonday | 2007-11-24 (6252 days ago) |
| Dorothea | 2007-11-19 (6257 days ago) |
| Bogdan | 2007-10-22 (6285 days ago) |
| Mocu | 2007-06-09 (6420 days ago) |
| Lorandka | 2007-01-05 (6575 days ago) |
| TSO1D | 2006-12-01 (6610 days ago) |
| Ronline | 2006-11-18 (6624 days ago) |
| Dmaftei | 2006-10-05 (6668 days ago) |
| Evosphere | 2006-07-14 (6750 days ago) |
| Orioane | 2006-06-29 (6765 days ago) |
| Victort | 2006-01-02 (6943 days ago) |
| NazismIsntCool | 2005-11-06 (7000 days ago) |
18 rows in set (55.09 sec)
last update: 2008-03-28 (6128 days ago)
| Name | Last edit |
|---|---|
| Micke | 2008-03-27 (6128 days ago) |
| Robertgreer | 2008-03-26 (6129 days ago) |
| M.M.S. | 2008-03-26 (6129 days ago) |
| Habj | 2008-03-25 (6130 days ago) |
| SvHannibal | 2008-03-24 (6131 days ago) |
| Moralist | 2008-03-24 (6131 days ago) |
| Boivie | 2008-03-14 (6141 days ago) |
| Mikez | 2008-03-04 (6152 days ago) |
| Riggwelter | 2008-02-16 (6168 days ago) |
| Malhonen | 2008-02-13 (6171 days ago) |
| LX | 2008-01-15 (6200 days ago) |
| Skomakarn | 2008-01-07 (6209 days ago) |
| Johngreen | 2007-12-04 (6242 days ago) |
| RaSten | 2007-10-21 (6286 days ago) |
| Pcongre | 2007-10-13 (6294 days ago) |
| Klibbnisse | 2007-08-27 (6341 days ago) |
| Edricson | 2007-08-09 (6359 days ago) |
| Smiddle | 2007-04-21 (6469 days ago) |
| Skagedal | 2007-04-01 (6489 days ago) |
| Yenx | 2007-01-08 (6572 days ago) |
| Kruosio | 2006-12-11 (6600 days ago) |
| NERIUM | 2006-06-29 (6766 days ago) |
| Jniemenmaa | 2006-06-12 (6782 days ago) |
| Marsve | 2006-05-05 (6820 days ago) |
| Aktalo | 2006-01-23 (6922 days ago) |
| Diyako | 2006-01-17 (6928 days ago) |
| Storpilot | 2005-12-12 (6964 days ago) |
| Scoo | 2005-12-08 (6968 days ago) |
| Qwm | 2005-11-16 (6991 days ago) |
| ShineB | 2005-09-29 (7038 days ago) |
| Tehvata | 2005-07-01 (7128 days ago) |
31 rows in set (3 min 51.74 sec)
last update: 2008-03-28 (6128 days ago)
| Name | Last edit |
|---|---|
| Ahonc | 2008-03-25 (6130 days ago) |
| Riwnodennyk | 2008-03-25 (6130 days ago) |
| A1 | 2008-02-11 (6173 days ago) |
| Ilyaroz | 2008-01-27 (6188 days ago) |
| Movses | 2008-01-23 (6192 days ago) |
| Yakudza | 2007-11-20 (6256 days ago) |
| Minia | 2007-11-18 (6258 days ago) |
| EvgenyGenkin | 2007-11-13 (6263 days ago) |
| DmRodionov | 2007-08-25 (6343 days ago) |
| Mikolasz | 2007-07-14 (6385 days ago) |
| Hayk | 2007-07-07 (6392 days ago) |
| Panas | 2007-07-01 (6398 days ago) |
| Yms | 2007-04-09 (6481 days ago) |
| Nevermind | 2006-12-18 (6593 days ago) |
| Angryxpeh | 2006-12-14 (6597 days ago) |
| AndriyK | 2006-11-24 (6617 days ago) |
| Martynenka | 2006-11-08 (6633 days ago) |
| Redsunrising | 2006-11-04 (6637 days ago) |
| Ornil | 2006-11-03 (6638 days ago) |
| Jan-ivan | 2005-11-14 (6992 days ago) |
| Inetd | 2005-03-26 (7225 days ago) |
21 rows in set (1 min 55.31 sec)
last update: 2008-03-28 (6128 days ago)
| Name | Last edit |
|---|---|
| Vinhtantran | 2008-03-27 (6128 days ago) |
| Neoneurone | 2007-11-15 (6261 days ago) |
2 rows in set (11.40 sec)
Generating
editStructure
editThis information is derived from a database table with the following structure:
| user_id | user_pageid | user_talkpageid | user_name | user_lastedit |
|---|---|---|---|---|
| int(5) unsigned | int(8) unsigned | int(8) unsigned | varchar(255) | varchar(14) |
| UNIQUE INDEX |
Create or update table
editThe table is created and populated or updated using the following SQL:
CREATE DATABASE u_pathoschild;
DROP TABLE u_pathoschild.user;
CREATE TABLE u_pathoschild.user (
user_id int(5) unsigned UNIQUE,
user_pageid int(8) unsigned,
user_talkpageid int(8) unsigned,
user_name varchar(255),
user_lastedit varchar(14)
);
ALTER TABLE u_pathoschild.user
ADD INDEX(user_id);
INSERT INTO u_pathoschild.user (user_id, user_name)
SELECT user_id, user_name
FROM metawiki_p.user
ORDER BY user_id;
UPDATE u_pathoschild.user
SET user_lastedit=(
SELECT rev_timestamp
FROM revision
WHERE rev_user=u_pathoschild.user.user_id
GROUP BY rev_user DESC
);
UPDATE u_pathoschild.user
SET user_pageid=(
SELECT page_id
FROM page
WHERE page_title=u_pathoschild.user.user_name
AND page_namespace=2
);
UPDATE u_pathoschild.user
SET user_talkpageid=(
SELECT page_id
FROM page
WHERE page_title=u_pathoschild.user.user_name
AND page_namespace=3
);
Search users
editThe table can then be crossindexed with the following SQL:
SELECT user_name,user_lastedit FROM u_pathoschild.user
JOIN categorylinks
ON cl_from=user_pageid OR cl_from=user_name
WHERE cl_to='User_sv'
AND cl_sortkey REGEXP '^[123]'
ORDER BY user_lastedit DESC
LIMIT 100;
Parse into table
editSSH output can be converted to wiki table syntax using the following regex:
| search | \| (.+?)\s+\| (\d+) \| (?:\r\n)? |
|---|---|
| replace | {{/user
|1= $1
|2= $2
}}
|