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[edit]
bg/Bulgarian[edit]
last update: 2008-03-28 (5935 days ago)
| Name | Last edit |
|---|---|
| Spiritia | 2008-03-20 (5942 days ago) |
| Timurberk | 2008-02-04 (5987 days ago) |
| Daggerstab | 2008-01-19 (6003 days ago) |
| 5ko | 2008-01-01 (6021 days ago) |
| Azimski | 2007-09-19 (6125 days ago) |
| Nk | 2007-06-28 (6208 days ago) |
| Vanka5 | 2007-05-25 (6243 days ago) |
| Sharkb | 2007-01-21 (6366 days ago) |
| Bggoldie | 2006-12-19 (6400 days ago) |
| DCLXVI | 2006-08-06 (6534 days ago) |
| Smartech | 2006-04-14 (6648 days ago) |
| Glimz | 2006-04-02 (6660 days ago) |
| Espetkov | 2005-06-05 (6961 days ago) |
13 rows in set (56.82 sec)
bn/Bengali[edit]
last update: 2008-03-28 (5935 days ago)
| Name | Last edit |
|---|---|
| Bellayet | 2008-03-26 (5936 days ago) |
| Aeetlrsk | 2008-02-04 (5987 days ago) |
| Frdayeen | 2008-01-08 (6014 days ago) |
| Hermitage17 | 2008-01-08 (6015 days ago) |
4 rows in set (9.26 sec)
fi/Finnish[edit]
last update: 2008-03-28 (5935 days ago)
| Name | Last edit |
|---|---|
| AtteL | 2008-03-25 (5937 days ago) |
| Str4nd | 2008-03-24 (5938 days ago) |
| Roosa | 2008-03-05 (5958 days ago) |
| Malhonen | 2008-02-13 (5978 days ago) |
| Ilaiho | 2007-12-25 (6028 days ago) |
| Argus | 2007-11-12 (6071 days ago) |
| Jariola | 2007-10-29 (6085 days ago) |
| Kyzyl | 2007-07-16 (6191 days ago) |
| Skuolfi | 2007-05-13 (6254 days ago) |
| Urvabara | 2007-02-08 (6348 days ago) |
| Jni | 2007-01-29 (6358 days ago) |
| NZ- | 2006-12-30 (6388 days ago) |
| Vilu | 2006-12-26 (6392 days ago) |
| Hartz | 2006-12-15 (6403 days ago) |
| Mzlla | 2006-12-07 (6411 days ago) |
| Inzulac | 2006-10-31 (6448 days ago) |
| Lauranen | 2006-10-02 (6477 days ago) |
| Totuus | 2006-09-05 (6504 days ago) |
| Anchjo | 2006-08-31 (6509 days ago) |
| Pwc | 2006-08-05 (6535 days ago) |
| Kouluhai | 2006-06-23 (6578 days ago) |
| Jniemenmaa | 2006-06-12 (6589 days ago) |
| Bobet | 2006-02-06 (6715 days ago) |
| Finlandia | 2005-12-28 (6755 days ago) |
| Hapsiainen | 2005-12-09 (6774 days ago) |
| Viznut | 2005-07-27 (6910 days ago) |
| Lanahard | 2005-07-21 (6915 days ago) |
| Rdnk | 2005-05-24 (6973 days ago) |
31 rows in set (55.17 sec)
es/Spanish[edit]
last update: 2008-03-28 (5935 days ago)
| Name | Last edit |
|---|---|
| Spacebirdy | 2008-03-27 (5935 days ago) |
| Bengoa | 2008-03-27 (5935 days ago) |
| Kylu | 2008-03-27 (5936 days ago) |
| Julie | 2008-03-26 (5936 days ago) |
| Taichi | 2008-03-26 (5936 days ago) |
| Ascánder | 2008-03-26 (5936 days ago) |
| Smeira | 2008-03-26 (5936 days ago) |
| SMP | 2008-03-26 (5936 days ago) |
| Drini | 2008-03-26 (5936 days ago) |
| Rdsmith4 | 2008-03-25 (5937 days ago) |
| Masterches | 2008-03-25 (5938 days ago) |
| Wikimistusik | 2008-03-25 (5938 days ago) |
| Mikel | 2008-03-25 (5938 days ago) |
| Willtron | 2008-03-24 (5938 days ago) |
| CHV | 2008-03-24 (5938 days ago) |
| Tosão | 2008-03-23 (5939 days ago) |
| Redux | 2008-03-21 (5941 days ago) |
| Xic667 | 2008-03-21 (5941 days ago) |
| LaosLos | 2008-03-20 (5942 days ago) |
| BetoCG | 2008-03-17 (5945 days ago) |
| DamianFinol | 2008-03-16 (5947 days ago) |
| Jurock | 2008-03-13 (5949 days ago) |
| Oswaldo2025 | 2008-03-13 (5950 days ago) |
| Damërung | 2008-03-08 (5954 days ago) |
| Alhen | 2008-03-06 (5956 days ago) |
| Fajro | 2008-03-04 (5959 days ago) |
| LadyInGrey | 2008-03-03 (5959 days ago) |
| Barcex | 2008-03-02 (5960 days ago) |
| Alpertron | 2008-02-29 (5962 days ago) |
| Cromwellt | 2008-02-29 (5963 days ago) |
| RedCoat | 2008-02-28 (5963 days ago) |
| Sapey | 2008-02-20 (5971 days ago) |
| Elisardojm | 2008-02-20 (5971 days ago) |
| Lascorz | 2008-02-19 (5972 days ago) |
| Rastrojo | 2008-02-19 (5972 days ago) |
| Cedric31 | 2008-02-19 (5972 days ago) |
| Prevert | 2008-02-16 (5975 days ago) |
| Aleator | 2008-02-15 (5976 days ago) |
| Zuirdj | 2008-02-15 (5976 days ago) |
| Orereta | 2008-02-15 (5976 days ago) |
| FrancoGG | 2008-02-11 (5980 days ago) |
| Loco085 | 2008-02-10 (5981 days ago) |
| Agüeybaná | 2008-02-10 (5981 days ago) |
| Mtmelendez | 2008-02-08 (5983 days ago) |
| TXiKi | 2008-02-08 (5984 days ago) |
| SCPS | 2008-02-07 (5984 days ago) |
| Toliño | 2008-02-07 (5984 days ago) |
| Theklan | 2008-02-07 (5984 days ago) |
| ReyBrujo | 2008-02-05 (5987 days ago) |
| Vilallonga | 2008-01-30 (5992 days ago) |
| Gaudio | 2008-01-25 (5997 days ago) |
| AlimanRuna | 2008-01-24 (5998 days ago) |
| Xtv | 2008-01-19 (6003 days ago) |
| Vriullop | 2008-01-18 (6004 days ago) |
| Desiphral | 2008-01-16 (6006 days ago) |
| DDarkfire | 2008-01-15 (6008 days ago) |
| Jove | 2008-01-08 (6015 days ago) |
| Pepelopex | 2008-01-07 (6015 days ago) |
| Esbardu | 2008-01-07 (6016 days ago) |
| Carles | 2007-12-30 (6023 days ago) |
| Celestianpower | 2007-12-30 (6023 days ago) |
| RRmeta | 2007-12-30 (6024 days ago) |
| Axxgreazz | 2007-12-23 (6031 days ago) |
| Sobreira | 2007-12-22 (6031 days ago) |
| Varano | 2007-12-18 (6035 days ago) |
| Chlewey | 2007-12-17 (6036 days ago) |
| Javierm | 2007-12-13 (6040 days ago) |
| Kipmaster | 2007-12-10 (6043 days ago) |
| Adalbertofrenesi | 2007-12-07 (6046 days ago) |
| JB82 | 2007-12-06 (6048 days ago) |
| Patstuart | 2007-12-04 (6050 days ago) |
| Subtiempo | 2007-11-30 (6053 days ago) |
| Jaranda | 2007-11-30 (6053 days ago) |
| Mac | 2007-11-29 (6054 days ago) |
| Lmbuga | 2007-11-28 (6055 days ago) |
| Janfri | 2007-11-28 (6055 days ago) |
| Banjo | 2007-11-24 (6059 days ago) |
| Malvenko | 2007-11-23 (6060 days ago) |
| Iradigalesc | 2007-11-23 (6060 days ago) |
| Llull | 2007-11-23 (6060 days ago) |
| Lohen11 | 2007-11-21 (6062 days ago) |
| Vibragiel | 2007-11-20 (6063 days ago) |
| Sanbec | 2007-11-20 (6063 days ago) |
| Yrithinnd | 2007-11-19 (6064 days ago) |
| Bdenk715 | 2007-11-14 (6070 days ago) |
| Marianocecowski | 2007-11-12 (6071 days ago) |
| Kuartas | 2007-11-10 (6073 days ago) |
| GlimmerPhoenix | 2007-11-09 (6074 days ago) |
| Fryant | 2007-11-08 (6075 days ago) |
| Edub | 2007-10-28 (6086 days ago) |
| Jynus | 2007-10-24 (6090 days ago) |
| Prietoquilmes | 2007-10-21 (6093 days ago) |
| Spangineer | 2007-10-14 (6100 days ago) |
| Pcongre | 2007-10-13 (6102 days ago) |
| Rodasmith | 2007-10-11 (6103 days ago) |
| JorgeGG | 2007-10-08 (6106 days ago) |
| Battroid | 2007-10-06 (6109 days ago) |
| Morza | 2007-09-30 (6114 days ago) |
| Albdallah | 2007-09-29 (6115 days ago) |
| Albeiror24 | 2007-09-29 (6116 days ago) |
100 rows in set (1 min 17.61 sec)
hi/Hindi[edit]
last update: 2008-03-28 (5935 days ago)
| Name | Last edit |
|---|---|
| Ashishbhatnagar | 2008-02-22 (5970 days ago) |
| Rajeevmass | 2008-02-07 (5984 days ago) |
| Eukesh | 2008-02-03 (5988 days ago) |
| Shyam | 2008-01-10 (6013 days ago) |
| Srikeit | 2007-12-06 (6047 days ago) |
| Sanjaybafnaji | 2007-07-26 (6180 days ago) |
| Mexxian | 2007-05-27 (6240 days ago) |
| Spundun | 2007-03-30 (6298 days ago) |
| Shreshth91 | 2007-02-16 (6341 days ago) |
| Jdas07 | 2006-09-12 (6497 days ago) |
| Dineshjk | 2005-08-05 (6900 days ago) |
| Abhishekbh | 2005-04-21 (7007 days ago) |
12 rows in set (43.28 sec)
ja/Japanese[edit]
last update: 2008-03-28 (5935 days ago)
| Name | Last edit |
|---|---|
| Tuinui | 2008-03-27 (5936 days ago) |
| Bookman | 2008-03-27 (5936 days ago) |
| Aphaia | 2008-03-27 (5936 days ago) |
| Kahusi | 2008-03-26 (5936 days ago) |
| Me2hero | 2008-03-26 (5936 days ago) |
| Genppy | 2008-03-26 (5937 days ago) |
| Kanjy | 2008-03-25 (5937 days ago) |
| Ninomy | 2008-03-25 (5937 days ago) |
| Kzhr | 2008-03-25 (5937 days ago) |
| LERK | 2008-03-25 (5937 days ago) |
| ZCU | 2008-03-24 (5938 days ago) |
| ゆいしあす | 2008-03-24 (5938 days ago) |
| Marine-Blue | 2008-03-22 (5941 days ago) |
| Courant | 2008-03-22 (5941 days ago) |
| Miya | 2008-03-20 (5943 days ago) |
| Mulukhiyya | 2008-03-12 (5950 days ago) |
| Mzm5zbC3 | 2008-03-11 (5951 days ago) |
| Bletilla | 2008-03-08 (5954 days ago) |
| Aotake | 2008-03-08 (5955 days ago) |
| Widehawk | 2008-03-04 (5959 days ago) |
| おはぐろ蜻蛉 | 2008-02-28 (5963 days ago) |
| ネッツ | 2008-02-27 (5964 days ago) |
| NJT | 2008-02-24 (5968 days ago) |
| 朝彦 | 2008-02-24 (5968 days ago) |
| Yassie | 2008-02-21 (5970 days ago) |
| 辞典の虫 | 2008-02-16 (5976 days ago) |
| Tommy6 | 2008-02-13 (5979 days ago) |
| Peccafly | 2008-02-10 (5981 days ago) |
| Uryah | 2008-02-10 (5982 days ago) |
| Kstigarbha | 2008-02-03 (5988 days ago) |
| Bukki | 2008-02-03 (5989 days ago) |
| Bellcricket | 2008-02-02 (5989 days ago) |
| Sylphie | 2008-02-01 (5990 days ago) |
| Pica | 2008-02-01 (5991 days ago) |
| Quatro | 2008-01-30 (5992 days ago) |
| Miya.m | 2008-01-29 (5993 days ago) |
| Londonbashi | 2008-01-28 (5994 days ago) |
| Kickaha | 2008-01-27 (5995 days ago) |
| Co.kyoto | 2008-01-27 (5995 days ago) |
| Hirokun | 2008-01-27 (5995 days ago) |
| Complex01 | 2008-01-27 (5996 days ago) |
| 千代林檎 | 2008-01-26 (5997 days ago) |
| Lonicera | 2008-01-25 (5997 days ago) |
| ZERBERUS | 2008-01-25 (5997 days ago) |
| Hyolee2 | 2008-01-25 (5998 days ago) |
| Tangotango | 2008-01-18 (6004 days ago) |
| Lemonsquash | 2008-01-16 (6006 days ago) |
| Knua | 2008-01-12 (6010 days ago) |
| Michey.M | 2008-01-05 (6017 days ago) |
| SS95 | 2007-12-27 (6026 days ago) |
| Suzuyoshinine | 2007-12-21 (6032 days ago) |
| Horlicks | 2007-12-21 (6033 days ago) |
| Volfgang | 2007-12-16 (6037 days ago) |
| Watermint | 2007-12-14 (6039 days ago) |
| Schu | 2007-12-14 (6040 days ago) |
| Tietew | 2007-12-10 (6044 days ago) |
| Dekimasu | 2007-12-04 (6050 days ago) |
| Swind | 2007-12-03 (6051 days ago) |
| Kareha | 2007-12-01 (6052 days ago) |
| Tamtarm | 2007-11-29 (6054 days ago) |
| Clarin | 2007-11-29 (6055 days ago) |
| Kasuga | 2007-11-28 (6055 days ago) |
| 11ChamOK | 2007-11-28 (6055 days ago) |
| Kurihaya | 2007-11-28 (6055 days ago) |
| Lusheeta | 2007-11-28 (6055 days ago) |
| Noraneko | 2007-11-28 (6056 days ago) |
| Kotodama-Reverse | 2007-11-26 (6057 days ago) |
| T-coco | 2007-11-26 (6057 days ago) |
| Numerike | 2007-11-26 (6057 days ago) |
| 霧木諒二 | 2007-11-26 (6057 days ago) |
| Takot | 2007-11-25 (6058 days ago) |
| Himetv | 2007-10-24 (6091 days ago) |
| Remington | 2007-10-20 (6094 days ago) |
| SantaClaus | 2007-09-25 (6119 days ago) |
| T.Saito | 2007-09-24 (6120 days ago) |
| Tiens | 2007-09-18 (6127 days ago) |
| Coryjp | 2007-09-05 (6139 days ago) |
| Muyo | 2007-09-03 (6141 days ago) |
| Ribbon | 2007-08-16 (6160 days ago) |
| Penpen | 2007-08-08 (6168 days ago) |
| PiaCarrot | 2007-08-04 (6171 days ago) |
| YouShow | 2007-07-27 (6179 days ago) |
| Chinneeb | 2007-07-03 (6204 days ago) |
| HALPHA | 2007-07-01 (6205 days ago) |
| Tonync | 2007-05-17 (6250 days ago) |
| Araisyohei | 2007-04-21 (6276 days ago) |
| 七星 | 2007-04-21 (6277 days ago) |
| LQVX | 2007-04-16 (6282 days ago) |
| Goncyan | 2007-04-05 (6293 days ago) |
| 端くれの錬金術師 | 2007-04-02 (6295 days ago) |
| Matsumomushi | 2007-03-25 (6304 days ago) |
| かんがへなし | 2007-03-17 (6312 days ago) |
| Rocky7 | 2007-03-16 (6312 days ago) |
| Lonchi** | 2007-03-09 (6320 days ago) |
| っ | 2007-02-17 (6339 days ago) |
| Kkkdc | 2007-02-16 (6340 days ago) |
| Diagraph01 | 2007-02-06 (6351 days ago) |
| Pachayachachic | 2007-02-03 (6354 days ago) |
| Adr6721 | 2007-02-01 (6356 days ago) |
| Su-no-G | 2007-02-01 (6356 days ago) |
100 rows in set (1 min 2.26 sec)
id/Bahasa Indonesian[edit]
last update: 2008-03-28 (5935 days ago)
| Name | Last edit |
|---|---|
| Azmi1995 | 2008-03-25 (5938 days ago) |
| IDRex | 2008-03-25 (5938 days ago) |
| IvanLanin | 2008-03-22 (5940 days ago) |
| Mimihitam | 2008-03-19 (5943 days ago) |
| Master2841 | 2008-03-08 (5954 days ago) |
| Chriswaterguy | 2008-03-07 (5956 days ago) |
| Borgx | 2008-03-04 (5959 days ago) |
| Kandar | 2008-02-18 (5973 days ago) |
| Meursault2004 | 2008-02-12 (5979 days ago) |
| Dragunova | 2008-02-08 (5984 days ago) |
| Hariadhi | 2007-08-03 (6173 days ago) |
| Irwangatot | 2007-06-12 (6224 days ago) |
| Anggoro | 2006-12-07 (6412 days ago) |
| Winana | 2006-11-22 (6426 days ago) |
| Anggreani | 2006-08-04 (6537 days ago) |
| HarisX | 2006-05-12 (6621 days ago) |
| Zaidpjd | 2005-11-20 (6793 days ago) |
| Widhiantoro | 2005-11-18 (6796 days ago) |
| Sudiryo | 2005-11-18 (6796 days ago) |
| *drew | 2005-11-08 (6806 days ago) |
20 rows in set (51.73 sec)
ro/Romanian[edit]
last update: 2008-03-28 (5935 days ago)
| Name | Last edit |
|---|---|
| SCriBu | 2008-02-24 (5967 days ago) |
| Cuman | 2008-01-25 (5997 days ago) |
| Desiphral | 2008-01-16 (6006 days ago) |
| IulianU | 2008-01-14 (6008 days ago) |
| AQUA | 2007-12-20 (6033 days ago) |
| Romihaitza | 2007-11-27 (6056 days ago) |
| BlueMonday | 2007-11-24 (6059 days ago) |
| Dorothea | 2007-11-19 (6064 days ago) |
| Bogdan | 2007-10-22 (6092 days ago) |
| Mocu | 2007-06-09 (6227 days ago) |
| Lorandka | 2007-01-05 (6382 days ago) |
| TSO1D | 2006-12-01 (6417 days ago) |
| Ronline | 2006-11-18 (6431 days ago) |
| Dmaftei | 2006-10-05 (6475 days ago) |
| Evosphere | 2006-07-14 (6557 days ago) |
| Orioane | 2006-06-29 (6572 days ago) |
| Victort | 2006-01-02 (6751 days ago) |
| NazismIsntCool | 2005-11-06 (6808 days ago) |
18 rows in set (55.09 sec)
sv/Swedish[edit]
last update: 2008-03-28 (5935 days ago)
| Name | Last edit |
|---|---|
| Micke | 2008-03-27 (5935 days ago) |
| Robertgreer | 2008-03-26 (5936 days ago) |
| M.M.S. | 2008-03-26 (5936 days ago) |
| Habj | 2008-03-25 (5937 days ago) |
| SvHannibal | 2008-03-24 (5938 days ago) |
| Moralist | 2008-03-24 (5938 days ago) |
| Boivie | 2008-03-14 (5948 days ago) |
| Mikez | 2008-03-04 (5959 days ago) |
| Riggwelter | 2008-02-16 (5975 days ago) |
| Malhonen | 2008-02-13 (5978 days ago) |
| LX | 2008-01-15 (6007 days ago) |
| Skomakarn | 2008-01-07 (6016 days ago) |
| Johngreen | 2007-12-04 (6049 days ago) |
| RaSten | 2007-10-21 (6093 days ago) |
| Pcongre | 2007-10-13 (6102 days ago) |
| Klibbnisse | 2007-08-27 (6148 days ago) |
| Edricson | 2007-08-09 (6166 days ago) |
| Smiddle | 2007-04-21 (6276 days ago) |
| Skagedal | 2007-04-01 (6296 days ago) |
| Yenx | 2007-01-08 (6379 days ago) |
| Kruosio | 2006-12-11 (6407 days ago) |
| NERIUM | 2006-06-29 (6573 days ago) |
| Jniemenmaa | 2006-06-12 (6589 days ago) |
| Marsve | 2006-05-05 (6627 days ago) |
| Aktalo | 2006-01-23 (6729 days ago) |
| Diyako | 2006-01-17 (6736 days ago) |
| Storpilot | 2005-12-12 (6771 days ago) |
| Scoo | 2005-12-08 (6775 days ago) |
| Qwm | 2005-11-16 (6798 days ago) |
| ShineB | 2005-09-29 (6845 days ago) |
| Tehvata | 2005-07-01 (6935 days ago) |
31 rows in set (3 min 51.74 sec)
uk/Ukrainian[edit]
last update: 2008-03-28 (5935 days ago)
| Name | Last edit |
|---|---|
| Ahonc | 2008-03-25 (5937 days ago) |
| Riwnodennyk | 2008-03-25 (5937 days ago) |
| A1 | 2008-02-11 (5980 days ago) |
| Ilyaroz | 2008-01-27 (5996 days ago) |
| Movses | 2008-01-23 (5999 days ago) |
| Yakudza | 2007-11-20 (6063 days ago) |
| Minia | 2007-11-18 (6065 days ago) |
| EvgenyGenkin | 2007-11-13 (6070 days ago) |
| DmRodionov | 2007-08-25 (6150 days ago) |
| Mikolasz | 2007-07-14 (6192 days ago) |
| Hayk | 2007-07-07 (6199 days ago) |
| Panas | 2007-07-01 (6205 days ago) |
| Yms | 2007-04-09 (6288 days ago) |
| Nevermind | 2006-12-18 (6400 days ago) |
| Angryxpeh | 2006-12-14 (6404 days ago) |
| AndriyK | 2006-11-24 (6424 days ago) |
| Martynenka | 2006-11-08 (6440 days ago) |
| Redsunrising | 2006-11-04 (6444 days ago) |
| Ornil | 2006-11-03 (6445 days ago) |
| Jan-ivan | 2005-11-14 (6799 days ago) |
| Inetd | 2005-03-26 (7032 days ago) |
21 rows in set (1 min 55.31 sec)
vi/Vietnamese[edit]
last update: 2008-03-28 (5935 days ago)
| Name | Last edit |
|---|---|
| Vinhtantran | 2008-03-27 (5936 days ago) |
| Neoneurone | 2007-11-15 (6069 days ago) |
2 rows in set (11.40 sec)
Generating[edit]
Structure[edit]
This 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[edit]
The 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[edit]
The 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[edit]
SSH output can be converted to wiki table syntax using the following regex:
| search | \| (.+?)\s+\| (\d+) \| (?:\r\n)? |
|---|---|
| replace | {{/user
|1= $1
|2= $2
}}
|