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 (6087 days ago)
| Name | Last edit |
|---|---|
| Spiritia | 2008-03-20 (6094 days ago) |
| Timurberk | 2008-02-04 (6140 days ago) |
| Daggerstab | 2008-01-19 (6156 days ago) |
| 5ko | 2008-01-01 (6173 days ago) |
| Azimski | 2007-09-19 (6278 days ago) |
| Nk | 2007-06-28 (6361 days ago) |
| Vanka5 | 2007-05-25 (6395 days ago) |
| Sharkb | 2007-01-21 (6519 days ago) |
| Bggoldie | 2006-12-19 (6552 days ago) |
| DCLXVI | 2006-08-06 (6687 days ago) |
| Smartech | 2006-04-14 (6801 days ago) |
| Glimz | 2006-04-02 (6813 days ago) |
| Espetkov | 2005-06-05 (7114 days ago) |
13 rows in set (56.82 sec)
last update: 2008-03-28 (6087 days ago)
| Name | Last edit |
|---|---|
| Bellayet | 2008-03-26 (6088 days ago) |
| Aeetlrsk | 2008-02-04 (6139 days ago) |
| Frdayeen | 2008-01-08 (6167 days ago) |
| Hermitage17 | 2008-01-08 (6167 days ago) |
4 rows in set (9.26 sec)
last update: 2008-03-28 (6087 days ago)
| Name | Last edit |
|---|---|
| AtteL | 2008-03-25 (6090 days ago) |
| Str4nd | 2008-03-24 (6091 days ago) |
| Roosa | 2008-03-05 (6110 days ago) |
| Malhonen | 2008-02-13 (6130 days ago) |
| Ilaiho | 2007-12-25 (6180 days ago) |
| Argus | 2007-11-12 (6224 days ago) |
| Jariola | 2007-10-29 (6238 days ago) |
| Kyzyl | 2007-07-16 (6343 days ago) |
| Skuolfi | 2007-05-13 (6407 days ago) |
| Urvabara | 2007-02-08 (6501 days ago) |
| Jni | 2007-01-29 (6511 days ago) |
| NZ- | 2006-12-30 (6540 days ago) |
| Vilu | 2006-12-26 (6544 days ago) |
| Hartz | 2006-12-15 (6556 days ago) |
| Mzlla | 2006-12-07 (6564 days ago) |
| Inzulac | 2006-10-31 (6601 days ago) |
| Lauranen | 2006-10-02 (6630 days ago) |
| Totuus | 2006-09-05 (6657 days ago) |
| Anchjo | 2006-08-31 (6662 days ago) |
| Pwc | 2006-08-05 (6687 days ago) |
| Kouluhai | 2006-06-23 (6730 days ago) |
| Jniemenmaa | 2006-06-12 (6742 days ago) |
| Bobet | 2006-02-06 (6867 days ago) |
| Finlandia | 2005-12-28 (6908 days ago) |
| Hapsiainen | 2005-12-09 (6927 days ago) |
| Viznut | 2005-07-27 (7062 days ago) |
| Lanahard | 2005-07-21 (7067 days ago) |
| Rdnk | 2005-05-24 (7125 days ago) |
31 rows in set (55.17 sec)
last update: 2008-03-28 (6087 days ago)
| Name | Last edit |
|---|---|
| Spacebirdy | 2008-03-27 (6088 days ago) |
| Bengoa | 2008-03-27 (6088 days ago) |
| Kylu | 2008-03-27 (6088 days ago) |
| Julie | 2008-03-26 (6088 days ago) |
| Taichi | 2008-03-26 (6088 days ago) |
| Ascánder | 2008-03-26 (6088 days ago) |
| Smeira | 2008-03-26 (6088 days ago) |
| SMP | 2008-03-26 (6089 days ago) |
| Drini | 2008-03-26 (6089 days ago) |
| Rdsmith4 | 2008-03-25 (6089 days ago) |
| Masterches | 2008-03-25 (6090 days ago) |
| Wikimistusik | 2008-03-25 (6090 days ago) |
| Mikel | 2008-03-25 (6090 days ago) |
| Willtron | 2008-03-24 (6090 days ago) |
| CHV | 2008-03-24 (6090 days ago) |
| Tosão | 2008-03-23 (6091 days ago) |
| Redux | 2008-03-21 (6094 days ago) |
| Xic667 | 2008-03-21 (6094 days ago) |
| LaosLos | 2008-03-20 (6095 days ago) |
| BetoCG | 2008-03-17 (6097 days ago) |
| DamianFinol | 2008-03-16 (6099 days ago) |
| Jurock | 2008-03-13 (6101 days ago) |
| Oswaldo2025 | 2008-03-13 (6102 days ago) |
| Damërung | 2008-03-08 (6107 days ago) |
| Alhen | 2008-03-06 (6109 days ago) |
| Fajro | 2008-03-04 (6111 days ago) |
| LadyInGrey | 2008-03-03 (6111 days ago) |
| Barcex | 2008-03-02 (6113 days ago) |
| Alpertron | 2008-02-29 (6115 days ago) |
| Cromwellt | 2008-02-29 (6115 days ago) |
| RedCoat | 2008-02-28 (6116 days ago) |
| Sapey | 2008-02-20 (6123 days ago) |
| Elisardojm | 2008-02-20 (6124 days ago) |
| Lascorz | 2008-02-19 (6124 days ago) |
| Rastrojo | 2008-02-19 (6125 days ago) |
| Cedric31 | 2008-02-19 (6125 days ago) |
| Prevert | 2008-02-16 (6128 days ago) |
| Aleator | 2008-02-15 (6128 days ago) |
| Zuirdj | 2008-02-15 (6128 days ago) |
| Orereta | 2008-02-15 (6129 days ago) |
| FrancoGG | 2008-02-11 (6132 days ago) |
| Loco085 | 2008-02-10 (6134 days ago) |
| Agüeybaná | 2008-02-10 (6134 days ago) |
| Mtmelendez | 2008-02-08 (6136 days ago) |
| TXiKi | 2008-02-08 (6136 days ago) |
| SCPS | 2008-02-07 (6136 days ago) |
| Toliño | 2008-02-07 (6137 days ago) |
| Theklan | 2008-02-07 (6137 days ago) |
| ReyBrujo | 2008-02-05 (6139 days ago) |
| Vilallonga | 2008-01-30 (6145 days ago) |
| Gaudio | 2008-01-25 (6150 days ago) |
| AlimanRuna | 2008-01-24 (6151 days ago) |
| Xtv | 2008-01-19 (6155 days ago) |
| Vriullop | 2008-01-18 (6156 days ago) |
| Desiphral | 2008-01-16 (6159 days ago) |
| DDarkfire | 2008-01-15 (6160 days ago) |
| Jove | 2008-01-08 (6167 days ago) |
| Pepelopex | 2008-01-07 (6167 days ago) |
| Esbardu | 2008-01-07 (6168 days ago) |
| Carles | 2007-12-30 (6175 days ago) |
| Celestianpower | 2007-12-30 (6176 days ago) |
| RRmeta | 2007-12-30 (6176 days ago) |
| Axxgreazz | 2007-12-23 (6183 days ago) |
| Sobreira | 2007-12-22 (6184 days ago) |
| Varano | 2007-12-18 (6187 days ago) |
| Chlewey | 2007-12-17 (6189 days ago) |
| Javierm | 2007-12-13 (6192 days ago) |
| Kipmaster | 2007-12-10 (6195 days ago) |
| Adalbertofrenesi | 2007-12-07 (6198 days ago) |
| JB82 | 2007-12-06 (6200 days ago) |
| Patstuart | 2007-12-04 (6202 days ago) |
| Subtiempo | 2007-11-30 (6205 days ago) |
| Jaranda | 2007-11-30 (6206 days ago) |
| Mac | 2007-11-29 (6207 days ago) |
| Lmbuga | 2007-11-28 (6207 days ago) |
| Janfri | 2007-11-28 (6207 days ago) |
| Banjo | 2007-11-24 (6211 days ago) |
| Malvenko | 2007-11-23 (6212 days ago) |
| Iradigalesc | 2007-11-23 (6212 days ago) |
| Llull | 2007-11-23 (6213 days ago) |
| Lohen11 | 2007-11-21 (6214 days ago) |
| Vibragiel | 2007-11-20 (6215 days ago) |
| Sanbec | 2007-11-20 (6215 days ago) |
| Yrithinnd | 2007-11-19 (6216 days ago) |
| Bdenk715 | 2007-11-14 (6222 days ago) |
| Marianocecowski | 2007-11-12 (6223 days ago) |
| Kuartas | 2007-11-10 (6225 days ago) |
| GlimmerPhoenix | 2007-11-09 (6226 days ago) |
| Fryant | 2007-11-08 (6227 days ago) |
| Edub | 2007-10-28 (6239 days ago) |
| Jynus | 2007-10-24 (6243 days ago) |
| Prietoquilmes | 2007-10-21 (6245 days ago) |
| Spangineer | 2007-10-14 (6252 days ago) |
| Pcongre | 2007-10-13 (6254 days ago) |
| Rodasmith | 2007-10-11 (6256 days ago) |
| JorgeGG | 2007-10-08 (6259 days ago) |
| Battroid | 2007-10-06 (6261 days ago) |
| Morza | 2007-09-30 (6267 days ago) |
| Albdallah | 2007-09-29 (6267 days ago) |
| Albeiror24 | 2007-09-29 (6268 days ago) |
100 rows in set (1 min 17.61 sec)
last update: 2008-03-28 (6087 days ago)
| Name | Last edit |
|---|---|
| Ashishbhatnagar | 2008-02-22 (6122 days ago) |
| Rajeevmass | 2008-02-07 (6137 days ago) |
| Eukesh | 2008-02-03 (6140 days ago) |
| Shyam | 2008-01-10 (6165 days ago) |
| Srikeit | 2007-12-06 (6200 days ago) |
| Sanjaybafnaji | 2007-07-26 (6333 days ago) |
| Mexxian | 2007-05-27 (6392 days ago) |
| Spundun | 2007-03-30 (6451 days ago) |
| Shreshth91 | 2007-02-16 (6493 days ago) |
| Jdas07 | 2006-09-12 (6649 days ago) |
| Dineshjk | 2005-08-05 (7052 days ago) |
| Abhishekbh | 2005-04-21 (7159 days ago) |
12 rows in set (43.28 sec)
last update: 2008-03-28 (6087 days ago)
| Name | Last edit |
|---|---|
| Tuinui | 2008-03-27 (6088 days ago) |
| Bookman | 2008-03-27 (6088 days ago) |
| Aphaia | 2008-03-27 (6088 days ago) |
| Kahusi | 2008-03-26 (6089 days ago) |
| Me2hero | 2008-03-26 (6089 days ago) |
| Genppy | 2008-03-26 (6089 days ago) |
| Kanjy | 2008-03-25 (6090 days ago) |
| Ninomy | 2008-03-25 (6090 days ago) |
| Kzhr | 2008-03-25 (6090 days ago) |
| LERK | 2008-03-25 (6090 days ago) |
| ZCU | 2008-03-24 (6091 days ago) |
| ゆいしあす | 2008-03-24 (6091 days ago) |
| Marine-Blue | 2008-03-22 (6093 days ago) |
| Courant | 2008-03-22 (6093 days ago) |
| Miya | 2008-03-20 (6095 days ago) |
| Mulukhiyya | 2008-03-12 (6103 days ago) |
| Mzm5zbC3 | 2008-03-11 (6104 days ago) |
| Bletilla | 2008-03-08 (6107 days ago) |
| Aotake | 2008-03-08 (6107 days ago) |
| Widehawk | 2008-03-04 (6111 days ago) |
| おはぐろ蜻蛉 | 2008-02-28 (6116 days ago) |
| ネッツ | 2008-02-27 (6117 days ago) |
| NJT | 2008-02-24 (6120 days ago) |
| 朝彦 | 2008-02-24 (6120 days ago) |
| Yassie | 2008-02-21 (6123 days ago) |
| 辞典の虫 | 2008-02-16 (6128 days ago) |
| Tommy6 | 2008-02-13 (6131 days ago) |
| Peccafly | 2008-02-10 (6134 days ago) |
| Uryah | 2008-02-10 (6134 days ago) |
| Kstigarbha | 2008-02-03 (6141 days ago) |
| Bukki | 2008-02-03 (6141 days ago) |
| Bellcricket | 2008-02-02 (6141 days ago) |
| Sylphie | 2008-02-01 (6143 days ago) |
| Pica | 2008-02-01 (6143 days ago) |
| Quatro | 2008-01-30 (6145 days ago) |
| Miya.m | 2008-01-29 (6146 days ago) |
| Londonbashi | 2008-01-28 (6147 days ago) |
| Kickaha | 2008-01-27 (6148 days ago) |
| Co.kyoto | 2008-01-27 (6148 days ago) |
| Hirokun | 2008-01-27 (6148 days ago) |
| Complex01 | 2008-01-27 (6148 days ago) |
| 千代林檎 | 2008-01-26 (6149 days ago) |
| Lonicera | 2008-01-25 (6149 days ago) |
| ZERBERUS | 2008-01-25 (6150 days ago) |
| Hyolee2 | 2008-01-25 (6150 days ago) |
| Tangotango | 2008-01-18 (6156 days ago) |
| Lemonsquash | 2008-01-16 (6158 days ago) |
| Knua | 2008-01-12 (6163 days ago) |
| Michey.M | 2008-01-05 (6170 days ago) |
| SS95 | 2007-12-27 (6178 days ago) |
| Suzuyoshinine | 2007-12-21 (6185 days ago) |
| Horlicks | 2007-12-21 (6185 days ago) |
| Volfgang | 2007-12-16 (6190 days ago) |
| Watermint | 2007-12-14 (6192 days ago) |
| Schu | 2007-12-14 (6192 days ago) |
| Tietew | 2007-12-10 (6196 days ago) |
| Dekimasu | 2007-12-04 (6202 days ago) |
| Swind | 2007-12-03 (6203 days ago) |
| Kareha | 2007-12-01 (6205 days ago) |
| Tamtarm | 2007-11-29 (6207 days ago) |
| Clarin | 2007-11-29 (6207 days ago) |
| Kasuga | 2007-11-28 (6207 days ago) |
| 11ChamOK | 2007-11-28 (6208 days ago) |
| Kurihaya | 2007-11-28 (6208 days ago) |
| Lusheeta | 2007-11-28 (6208 days ago) |
| Noraneko | 2007-11-28 (6208 days ago) |
| Kotodama-Reverse | 2007-11-26 (6209 days ago) |
| T-coco | 2007-11-26 (6209 days ago) |
| Numerike | 2007-11-26 (6209 days ago) |
| 霧木諒二 | 2007-11-26 (6210 days ago) |
| Takot | 2007-11-25 (6211 days ago) |
| Himetv | 2007-10-24 (6243 days ago) |
| Remington | 2007-10-20 (6247 days ago) |
| SantaClaus | 2007-09-25 (6271 days ago) |
| T.Saito | 2007-09-24 (6273 days ago) |
| Tiens | 2007-09-18 (6279 days ago) |
| Coryjp | 2007-09-05 (6292 days ago) |
| Muyo | 2007-09-03 (6294 days ago) |
| Ribbon | 2007-08-16 (6312 days ago) |
| Penpen | 2007-08-08 (6320 days ago) |
| PiaCarrot | 2007-08-04 (6324 days ago) |
| YouShow | 2007-07-27 (6331 days ago) |
| Chinneeb | 2007-07-03 (6356 days ago) |
| HALPHA | 2007-07-01 (6358 days ago) |
| Tonync | 2007-05-17 (6403 days ago) |
| Araisyohei | 2007-04-21 (6429 days ago) |
| 七星 | 2007-04-21 (6429 days ago) |
| LQVX | 2007-04-16 (6434 days ago) |
| Goncyan | 2007-04-05 (6445 days ago) |
| 端くれの錬金術師 | 2007-04-02 (6448 days ago) |
| Matsumomushi | 2007-03-25 (6456 days ago) |
| かんがへなし | 2007-03-17 (6464 days ago) |
| Rocky7 | 2007-03-16 (6464 days ago) |
| Lonchi** | 2007-03-09 (6472 days ago) |
| っ | 2007-02-17 (6492 days ago) |
| Kkkdc | 2007-02-16 (6493 days ago) |
| Diagraph01 | 2007-02-06 (6503 days ago) |
| Pachayachachic | 2007-02-03 (6506 days ago) |
| Adr6721 | 2007-02-01 (6508 days ago) |
| Su-no-G | 2007-02-01 (6508 days ago) |
100 rows in set (1 min 2.26 sec)
last update: 2008-03-28 (6087 days ago)
| Name | Last edit |
|---|---|
| Azmi1995 | 2008-03-25 (6090 days ago) |
| IDRex | 2008-03-25 (6090 days ago) |
| IvanLanin | 2008-03-22 (6092 days ago) |
| Mimihitam | 2008-03-19 (6096 days ago) |
| Master2841 | 2008-03-08 (6107 days ago) |
| Chriswaterguy | 2008-03-07 (6108 days ago) |
| Borgx | 2008-03-04 (6111 days ago) |
| Kandar | 2008-02-18 (6126 days ago) |
| Meursault2004 | 2008-02-12 (6132 days ago) |
| Dragunova | 2008-02-08 (6136 days ago) |
| Hariadhi | 2007-08-03 (6325 days ago) |
| Irwangatot | 2007-06-12 (6376 days ago) |
| Anggoro | 2006-12-07 (6564 days ago) |
| Winana | 2006-11-22 (6578 days ago) |
| Anggreani | 2006-08-04 (6689 days ago) |
| HarisX | 2006-05-12 (6773 days ago) |
| Zaidpjd | 2005-11-20 (6946 days ago) |
| Widhiantoro | 2005-11-18 (6948 days ago) |
| Sudiryo | 2005-11-18 (6948 days ago) |
| *drew | 2005-11-08 (6958 days ago) |
20 rows in set (51.73 sec)
last update: 2008-03-28 (6087 days ago)
| Name | Last edit |
|---|---|
| SCriBu | 2008-02-24 (6119 days ago) |
| Cuman | 2008-01-25 (6150 days ago) |
| Desiphral | 2008-01-16 (6159 days ago) |
| IulianU | 2008-01-14 (6161 days ago) |
| AQUA | 2007-12-20 (6185 days ago) |
| Romihaitza | 2007-11-27 (6209 days ago) |
| BlueMonday | 2007-11-24 (6212 days ago) |
| Dorothea | 2007-11-19 (6217 days ago) |
| Bogdan | 2007-10-22 (6244 days ago) |
| Mocu | 2007-06-09 (6379 days ago) |
| Lorandka | 2007-01-05 (6534 days ago) |
| TSO1D | 2006-12-01 (6569 days ago) |
| Ronline | 2006-11-18 (6583 days ago) |
| Dmaftei | 2006-10-05 (6627 days ago) |
| Evosphere | 2006-07-14 (6710 days ago) |
| Orioane | 2006-06-29 (6725 days ago) |
| Victort | 2006-01-02 (6903 days ago) |
| NazismIsntCool | 2005-11-06 (6960 days ago) |
18 rows in set (55.09 sec)
last update: 2008-03-28 (6087 days ago)
| Name | Last edit |
|---|---|
| Micke | 2008-03-27 (6088 days ago) |
| Robertgreer | 2008-03-26 (6088 days ago) |
| M.M.S. | 2008-03-26 (6089 days ago) |
| Habj | 2008-03-25 (6090 days ago) |
| SvHannibal | 2008-03-24 (6090 days ago) |
| Moralist | 2008-03-24 (6091 days ago) |
| Boivie | 2008-03-14 (6101 days ago) |
| Mikez | 2008-03-04 (6111 days ago) |
| Riggwelter | 2008-02-16 (6128 days ago) |
| Malhonen | 2008-02-13 (6130 days ago) |
| LX | 2008-01-15 (6159 days ago) |
| Skomakarn | 2008-01-07 (6168 days ago) |
| Johngreen | 2007-12-04 (6202 days ago) |
| RaSten | 2007-10-21 (6246 days ago) |
| Pcongre | 2007-10-13 (6254 days ago) |
| Klibbnisse | 2007-08-27 (6301 days ago) |
| Edricson | 2007-08-09 (6319 days ago) |
| Smiddle | 2007-04-21 (6429 days ago) |
| Skagedal | 2007-04-01 (6448 days ago) |
| Yenx | 2007-01-08 (6532 days ago) |
| Kruosio | 2006-12-11 (6559 days ago) |
| NERIUM | 2006-06-29 (6725 days ago) |
| Jniemenmaa | 2006-06-12 (6742 days ago) |
| Marsve | 2006-05-05 (6779 days ago) |
| Aktalo | 2006-01-23 (6882 days ago) |
| Diyako | 2006-01-17 (6888 days ago) |
| Storpilot | 2005-12-12 (6924 days ago) |
| Scoo | 2005-12-08 (6928 days ago) |
| Qwm | 2005-11-16 (6950 days ago) |
| ShineB | 2005-09-29 (6998 days ago) |
| Tehvata | 2005-07-01 (7087 days ago) |
31 rows in set (3 min 51.74 sec)
last update: 2008-03-28 (6087 days ago)
| Name | Last edit |
|---|---|
| Ahonc | 2008-03-25 (6089 days ago) |
| Riwnodennyk | 2008-03-25 (6089 days ago) |
| A1 | 2008-02-11 (6132 days ago) |
| Ilyaroz | 2008-01-27 (6148 days ago) |
| Movses | 2008-01-23 (6152 days ago) |
| Yakudza | 2007-11-20 (6216 days ago) |
| Minia | 2007-11-18 (6218 days ago) |
| EvgenyGenkin | 2007-11-13 (6223 days ago) |
| DmRodionov | 2007-08-25 (6302 days ago) |
| Mikolasz | 2007-07-14 (6344 days ago) |
| Hayk | 2007-07-07 (6352 days ago) |
| Panas | 2007-07-01 (6358 days ago) |
| Yms | 2007-04-09 (6440 days ago) |
| Nevermind | 2006-12-18 (6553 days ago) |
| Angryxpeh | 2006-12-14 (6556 days ago) |
| AndriyK | 2006-11-24 (6576 days ago) |
| Martynenka | 2006-11-08 (6592 days ago) |
| Redsunrising | 2006-11-04 (6597 days ago) |
| Ornil | 2006-11-03 (6597 days ago) |
| Jan-ivan | 2005-11-14 (6951 days ago) |
| Inetd | 2005-03-26 (7184 days ago) |
21 rows in set (1 min 55.31 sec)
last update: 2008-03-28 (6087 days ago)
| Name | Last edit |
|---|---|
| Vinhtantran | 2008-03-27 (6088 days ago) |
| Neoneurone | 2007-11-15 (6221 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
}}
|