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 (5906 days ago)
| Name | Last edit |
|---|---|
| Spiritia | 2008-03-20 (5913 days ago) |
| Timurberk | 2008-02-04 (5958 days ago) |
| Daggerstab | 2008-01-19 (5975 days ago) |
| 5ko | 2008-01-01 (5992 days ago) |
| Azimski | 2007-09-19 (6096 days ago) |
| Nk | 2007-06-28 (6180 days ago) |
| Vanka5 | 2007-05-25 (6214 days ago) |
| Sharkb | 2007-01-21 (6338 days ago) |
| Bggoldie | 2006-12-19 (6371 days ago) |
| DCLXVI | 2006-08-06 (6506 days ago) |
| Smartech | 2006-04-14 (6620 days ago) |
| Glimz | 2006-04-02 (6632 days ago) |
| Espetkov | 2005-06-05 (6933 days ago) |
13 rows in set (56.82 sec)
bn/Bengali[edit]
last update: 2008-03-28 (5906 days ago)
| Name | Last edit |
|---|---|
| Bellayet | 2008-03-26 (5907 days ago) |
| Aeetlrsk | 2008-02-04 (5958 days ago) |
| Frdayeen | 2008-01-08 (5986 days ago) |
| Hermitage17 | 2008-01-08 (5986 days ago) |
4 rows in set (9.26 sec)
fi/Finnish[edit]
last update: 2008-03-28 (5906 days ago)
| Name | Last edit |
|---|---|
| AtteL | 2008-03-25 (5909 days ago) |
| Str4nd | 2008-03-24 (5909 days ago) |
| Roosa | 2008-03-05 (5929 days ago) |
| Malhonen | 2008-02-13 (5949 days ago) |
| Ilaiho | 2007-12-25 (5999 days ago) |
| Argus | 2007-11-12 (6043 days ago) |
| Jariola | 2007-10-29 (6057 days ago) |
| Kyzyl | 2007-07-16 (6162 days ago) |
| Skuolfi | 2007-05-13 (6226 days ago) |
| Urvabara | 2007-02-08 (6319 days ago) |
| Jni | 2007-01-29 (6330 days ago) |
| NZ- | 2006-12-30 (6359 days ago) |
| Vilu | 2006-12-26 (6363 days ago) |
| Hartz | 2006-12-15 (6374 days ago) |
| Mzlla | 2006-12-07 (6382 days ago) |
| Inzulac | 2006-10-31 (6419 days ago) |
| Lauranen | 2006-10-02 (6449 days ago) |
| Totuus | 2006-09-05 (6475 days ago) |
| Anchjo | 2006-08-31 (6481 days ago) |
| Pwc | 2006-08-05 (6506 days ago) |
| Kouluhai | 2006-06-23 (6549 days ago) |
| Jniemenmaa | 2006-06-12 (6561 days ago) |
| Bobet | 2006-02-06 (6686 days ago) |
| Finlandia | 2005-12-28 (6726 days ago) |
| Hapsiainen | 2005-12-09 (6745 days ago) |
| Viznut | 2005-07-27 (6881 days ago) |
| Lanahard | 2005-07-21 (6886 days ago) |
| Rdnk | 2005-05-24 (6944 days ago) |
31 rows in set (55.17 sec)
es/Spanish[edit]
last update: 2008-03-28 (5906 days ago)
| Name | Last edit |
|---|---|
| Spacebirdy | 2008-03-27 (5907 days ago) |
| Bengoa | 2008-03-27 (5907 days ago) |
| Kylu | 2008-03-27 (5907 days ago) |
| Julie | 2008-03-26 (5907 days ago) |
| Taichi | 2008-03-26 (5907 days ago) |
| Ascánder | 2008-03-26 (5907 days ago) |
| Smeira | 2008-03-26 (5907 days ago) |
| SMP | 2008-03-26 (5907 days ago) |
| Drini | 2008-03-26 (5907 days ago) |
| Rdsmith4 | 2008-03-25 (5908 days ago) |
| Masterches | 2008-03-25 (5909 days ago) |
| Wikimistusik | 2008-03-25 (5909 days ago) |
| Mikel | 2008-03-25 (5909 days ago) |
| Willtron | 2008-03-24 (5909 days ago) |
| CHV | 2008-03-24 (5909 days ago) |
| Tosão | 2008-03-23 (5910 days ago) |
| Redux | 2008-03-21 (5913 days ago) |
| Xic667 | 2008-03-21 (5913 days ago) |
| LaosLos | 2008-03-20 (5914 days ago) |
| BetoCG | 2008-03-17 (5916 days ago) |
| DamianFinol | 2008-03-16 (5918 days ago) |
| Jurock | 2008-03-13 (5920 days ago) |
| Oswaldo2025 | 2008-03-13 (5921 days ago) |
| Damërung | 2008-03-08 (5926 days ago) |
| Alhen | 2008-03-06 (5928 days ago) |
| Fajro | 2008-03-04 (5930 days ago) |
| LadyInGrey | 2008-03-03 (5930 days ago) |
| Barcex | 2008-03-02 (5931 days ago) |
| Alpertron | 2008-02-29 (5933 days ago) |
| Cromwellt | 2008-02-29 (5934 days ago) |
| RedCoat | 2008-02-28 (5934 days ago) |
| Sapey | 2008-02-20 (5942 days ago) |
| Elisardojm | 2008-02-20 (5943 days ago) |
| Lascorz | 2008-02-19 (5943 days ago) |
| Rastrojo | 2008-02-19 (5944 days ago) |
| Cedric31 | 2008-02-19 (5944 days ago) |
| Prevert | 2008-02-16 (5946 days ago) |
| Aleator | 2008-02-15 (5947 days ago) |
| Zuirdj | 2008-02-15 (5947 days ago) |
| Orereta | 2008-02-15 (5948 days ago) |
| FrancoGG | 2008-02-11 (5951 days ago) |
| Loco085 | 2008-02-10 (5952 days ago) |
| Agüeybaná | 2008-02-10 (5953 days ago) |
| Mtmelendez | 2008-02-08 (5955 days ago) |
| TXiKi | 2008-02-08 (5955 days ago) |
| SCPS | 2008-02-07 (5955 days ago) |
| Toliño | 2008-02-07 (5955 days ago) |
| Theklan | 2008-02-07 (5955 days ago) |
| ReyBrujo | 2008-02-05 (5958 days ago) |
| Vilallonga | 2008-01-30 (5964 days ago) |
| Gaudio | 2008-01-25 (5969 days ago) |
| AlimanRuna | 2008-01-24 (5969 days ago) |
| Xtv | 2008-01-19 (5974 days ago) |
| Vriullop | 2008-01-18 (5975 days ago) |
| Desiphral | 2008-01-16 (5978 days ago) |
| DDarkfire | 2008-01-15 (5979 days ago) |
| Jove | 2008-01-08 (5986 days ago) |
| Pepelopex | 2008-01-07 (5986 days ago) |
| Esbardu | 2008-01-07 (5987 days ago) |
| Carles | 2007-12-30 (5994 days ago) |
| Celestianpower | 2007-12-30 (5994 days ago) |
| RRmeta | 2007-12-30 (5995 days ago) |
| Axxgreazz | 2007-12-23 (6002 days ago) |
| Sobreira | 2007-12-22 (6003 days ago) |
| Varano | 2007-12-18 (6006 days ago) |
| Chlewey | 2007-12-17 (6007 days ago) |
| Javierm | 2007-12-13 (6011 days ago) |
| Kipmaster | 2007-12-10 (6014 days ago) |
| Adalbertofrenesi | 2007-12-07 (6017 days ago) |
| JB82 | 2007-12-06 (6019 days ago) |
| Patstuart | 2007-12-04 (6021 days ago) |
| Subtiempo | 2007-11-30 (6024 days ago) |
| Jaranda | 2007-11-30 (6024 days ago) |
| Mac | 2007-11-29 (6026 days ago) |
| Lmbuga | 2007-11-28 (6026 days ago) |
| Janfri | 2007-11-28 (6026 days ago) |
| Banjo | 2007-11-24 (6030 days ago) |
| Malvenko | 2007-11-23 (6031 days ago) |
| Iradigalesc | 2007-11-23 (6031 days ago) |
| Llull | 2007-11-23 (6031 days ago) |
| Lohen11 | 2007-11-21 (6033 days ago) |
| Vibragiel | 2007-11-20 (6034 days ago) |
| Sanbec | 2007-11-20 (6034 days ago) |
| Yrithinnd | 2007-11-19 (6035 days ago) |
| Bdenk715 | 2007-11-14 (6041 days ago) |
| Marianocecowski | 2007-11-12 (6042 days ago) |
| Kuartas | 2007-11-10 (6044 days ago) |
| GlimmerPhoenix | 2007-11-09 (6045 days ago) |
| Fryant | 2007-11-08 (6046 days ago) |
| Edub | 2007-10-28 (6058 days ago) |
| Jynus | 2007-10-24 (6062 days ago) |
| Prietoquilmes | 2007-10-21 (6064 days ago) |
| Spangineer | 2007-10-14 (6071 days ago) |
| Pcongre | 2007-10-13 (6073 days ago) |
| Rodasmith | 2007-10-11 (6074 days ago) |
| JorgeGG | 2007-10-08 (6078 days ago) |
| Battroid | 2007-10-06 (6080 days ago) |
| Morza | 2007-09-30 (6086 days ago) |
| Albdallah | 2007-09-29 (6086 days ago) |
| Albeiror24 | 2007-09-29 (6087 days ago) |
100 rows in set (1 min 17.61 sec)
hi/Hindi[edit]
last update: 2008-03-28 (5906 days ago)
| Name | Last edit |
|---|---|
| Ashishbhatnagar | 2008-02-22 (5941 days ago) |
| Rajeevmass | 2008-02-07 (5955 days ago) |
| Eukesh | 2008-02-03 (5959 days ago) |
| Shyam | 2008-01-10 (5984 days ago) |
| Srikeit | 2007-12-06 (6018 days ago) |
| Sanjaybafnaji | 2007-07-26 (6152 days ago) |
| Mexxian | 2007-05-27 (6211 days ago) |
| Spundun | 2007-03-30 (6270 days ago) |
| Shreshth91 | 2007-02-16 (6312 days ago) |
| Jdas07 | 2006-09-12 (6468 days ago) |
| Dineshjk | 2005-08-05 (6871 days ago) |
| Abhishekbh | 2005-04-21 (6978 days ago) |
12 rows in set (43.28 sec)
ja/Japanese[edit]
last update: 2008-03-28 (5906 days ago)
| Name | Last edit |
|---|---|
| Tuinui | 2008-03-27 (5907 days ago) |
| Bookman | 2008-03-27 (5907 days ago) |
| Aphaia | 2008-03-27 (5907 days ago) |
| Kahusi | 2008-03-26 (5908 days ago) |
| Me2hero | 2008-03-26 (5908 days ago) |
| Genppy | 2008-03-26 (5908 days ago) |
| Kanjy | 2008-03-25 (5908 days ago) |
| Ninomy | 2008-03-25 (5909 days ago) |
| Kzhr | 2008-03-25 (5909 days ago) |
| LERK | 2008-03-25 (5909 days ago) |
| ZCU | 2008-03-24 (5909 days ago) |
| ゆいしあす | 2008-03-24 (5910 days ago) |
| Marine-Blue | 2008-03-22 (5912 days ago) |
| Courant | 2008-03-22 (5912 days ago) |
| Miya | 2008-03-20 (5914 days ago) |
| Mulukhiyya | 2008-03-12 (5922 days ago) |
| Mzm5zbC3 | 2008-03-11 (5922 days ago) |
| Bletilla | 2008-03-08 (5926 days ago) |
| Aotake | 2008-03-08 (5926 days ago) |
| Widehawk | 2008-03-04 (5930 days ago) |
| おはぐろ蜻蛉 | 2008-02-28 (5935 days ago) |
| ネッツ | 2008-02-27 (5935 days ago) |
| NJT | 2008-02-24 (5939 days ago) |
| 朝彦 | 2008-02-24 (5939 days ago) |
| Yassie | 2008-02-21 (5942 days ago) |
| 辞典の虫 | 2008-02-16 (5947 days ago) |
| Tommy6 | 2008-02-13 (5950 days ago) |
| Peccafly | 2008-02-10 (5953 days ago) |
| Uryah | 2008-02-10 (5953 days ago) |
| Kstigarbha | 2008-02-03 (5959 days ago) |
| Bukki | 2008-02-03 (5960 days ago) |
| Bellcricket | 2008-02-02 (5960 days ago) |
| Sylphie | 2008-02-01 (5962 days ago) |
| Pica | 2008-02-01 (5962 days ago) |
| Quatro | 2008-01-30 (5963 days ago) |
| Miya.m | 2008-01-29 (5965 days ago) |
| Londonbashi | 2008-01-28 (5965 days ago) |
| Kickaha | 2008-01-27 (5967 days ago) |
| Co.kyoto | 2008-01-27 (5967 days ago) |
| Hirokun | 2008-01-27 (5967 days ago) |
| Complex01 | 2008-01-27 (5967 days ago) |
| 千代林檎 | 2008-01-26 (5968 days ago) |
| Lonicera | 2008-01-25 (5968 days ago) |
| ZERBERUS | 2008-01-25 (5969 days ago) |
| Hyolee2 | 2008-01-25 (5969 days ago) |
| Tangotango | 2008-01-18 (5975 days ago) |
| Lemonsquash | 2008-01-16 (5977 days ago) |
| Knua | 2008-01-12 (5981 days ago) |
| Michey.M | 2008-01-05 (5989 days ago) |
| SS95 | 2007-12-27 (5997 days ago) |
| Suzuyoshinine | 2007-12-21 (6004 days ago) |
| Horlicks | 2007-12-21 (6004 days ago) |
| Volfgang | 2007-12-16 (6009 days ago) |
| Watermint | 2007-12-14 (6011 days ago) |
| Schu | 2007-12-14 (6011 days ago) |
| Tietew | 2007-12-10 (6015 days ago) |
| Dekimasu | 2007-12-04 (6021 days ago) |
| Swind | 2007-12-03 (6022 days ago) |
| Kareha | 2007-12-01 (6024 days ago) |
| Tamtarm | 2007-11-29 (6026 days ago) |
| Clarin | 2007-11-29 (6026 days ago) |
| Kasuga | 2007-11-28 (6026 days ago) |
| 11ChamOK | 2007-11-28 (6026 days ago) |
| Kurihaya | 2007-11-28 (6027 days ago) |
| Lusheeta | 2007-11-28 (6027 days ago) |
| Noraneko | 2007-11-28 (6027 days ago) |
| Kotodama-Reverse | 2007-11-26 (6028 days ago) |
| T-coco | 2007-11-26 (6028 days ago) |
| Numerike | 2007-11-26 (6028 days ago) |
| 霧木諒二 | 2007-11-26 (6029 days ago) |
| Takot | 2007-11-25 (6029 days ago) |
| Himetv | 2007-10-24 (6062 days ago) |
| Remington | 2007-10-20 (6065 days ago) |
| SantaClaus | 2007-09-25 (6090 days ago) |
| T.Saito | 2007-09-24 (6092 days ago) |
| Tiens | 2007-09-18 (6098 days ago) |
| Coryjp | 2007-09-05 (6111 days ago) |
| Muyo | 2007-09-03 (6112 days ago) |
| Ribbon | 2007-08-16 (6131 days ago) |
| Penpen | 2007-08-08 (6139 days ago) |
| PiaCarrot | 2007-08-04 (6143 days ago) |
| YouShow | 2007-07-27 (6150 days ago) |
| Chinneeb | 2007-07-03 (6175 days ago) |
| HALPHA | 2007-07-01 (6177 days ago) |
| Tonync | 2007-05-17 (6222 days ago) |
| Araisyohei | 2007-04-21 (6248 days ago) |
| 七星 | 2007-04-21 (6248 days ago) |
| LQVX | 2007-04-16 (6253 days ago) |
| Goncyan | 2007-04-05 (6264 days ago) |
| 端くれの錬金術師 | 2007-04-02 (6267 days ago) |
| Matsumomushi | 2007-03-25 (6275 days ago) |
| かんがへなし | 2007-03-17 (6283 days ago) |
| Rocky7 | 2007-03-16 (6283 days ago) |
| Lonchi** | 2007-03-09 (6291 days ago) |
| っ | 2007-02-17 (6311 days ago) |
| Kkkdc | 2007-02-16 (6312 days ago) |
| Diagraph01 | 2007-02-06 (6322 days ago) |
| Pachayachachic | 2007-02-03 (6325 days ago) |
| Adr6721 | 2007-02-01 (6327 days ago) |
| Su-no-G | 2007-02-01 (6327 days ago) |
100 rows in set (1 min 2.26 sec)
id/Bahasa Indonesian[edit]
last update: 2008-03-28 (5906 days ago)
| Name | Last edit |
|---|---|
| Azmi1995 | 2008-03-25 (5909 days ago) |
| IDRex | 2008-03-25 (5909 days ago) |
| IvanLanin | 2008-03-22 (5911 days ago) |
| Mimihitam | 2008-03-19 (5915 days ago) |
| Master2841 | 2008-03-08 (5925 days ago) |
| Chriswaterguy | 2008-03-07 (5927 days ago) |
| Borgx | 2008-03-04 (5930 days ago) |
| Kandar | 2008-02-18 (5945 days ago) |
| Meursault2004 | 2008-02-12 (5950 days ago) |
| Dragunova | 2008-02-08 (5955 days ago) |
| Hariadhi | 2007-08-03 (6144 days ago) |
| Irwangatot | 2007-06-12 (6195 days ago) |
| Anggoro | 2006-12-07 (6383 days ago) |
| Winana | 2006-11-22 (6397 days ago) |
| Anggreani | 2006-08-04 (6508 days ago) |
| HarisX | 2006-05-12 (6592 days ago) |
| Zaidpjd | 2005-11-20 (6764 days ago) |
| Widhiantoro | 2005-11-18 (6767 days ago) |
| Sudiryo | 2005-11-18 (6767 days ago) |
| *drew | 2005-11-08 (6777 days ago) |
20 rows in set (51.73 sec)
ro/Romanian[edit]
last update: 2008-03-28 (5906 days ago)
| Name | Last edit |
|---|---|
| SCriBu | 2008-02-24 (5938 days ago) |
| Cuman | 2008-01-25 (5968 days ago) |
| Desiphral | 2008-01-16 (5978 days ago) |
| IulianU | 2008-01-14 (5979 days ago) |
| AQUA | 2007-12-20 (6004 days ago) |
| Romihaitza | 2007-11-27 (6027 days ago) |
| BlueMonday | 2007-11-24 (6031 days ago) |
| Dorothea | 2007-11-19 (6035 days ago) |
| Bogdan | 2007-10-22 (6063 days ago) |
| Mocu | 2007-06-09 (6198 days ago) |
| Lorandka | 2007-01-05 (6353 days ago) |
| TSO1D | 2006-12-01 (6388 days ago) |
| Ronline | 2006-11-18 (6402 days ago) |
| Dmaftei | 2006-10-05 (6446 days ago) |
| Evosphere | 2006-07-14 (6528 days ago) |
| Orioane | 2006-06-29 (6544 days ago) |
| Victort | 2006-01-02 (6722 days ago) |
| NazismIsntCool | 2005-11-06 (6779 days ago) |
18 rows in set (55.09 sec)
sv/Swedish[edit]
last update: 2008-03-28 (5906 days ago)
| Name | Last edit |
|---|---|
| Micke | 2008-03-27 (5907 days ago) |
| Robertgreer | 2008-03-26 (5907 days ago) |
| M.M.S. | 2008-03-26 (5908 days ago) |
| Habj | 2008-03-25 (5909 days ago) |
| SvHannibal | 2008-03-24 (5909 days ago) |
| Moralist | 2008-03-24 (5909 days ago) |
| Boivie | 2008-03-14 (5920 days ago) |
| Mikez | 2008-03-04 (5930 days ago) |
| Riggwelter | 2008-02-16 (5947 days ago) |
| Malhonen | 2008-02-13 (5949 days ago) |
| LX | 2008-01-15 (5978 days ago) |
| Skomakarn | 2008-01-07 (5987 days ago) |
| Johngreen | 2007-12-04 (6020 days ago) |
| RaSten | 2007-10-21 (6065 days ago) |
| Pcongre | 2007-10-13 (6073 days ago) |
| Klibbnisse | 2007-08-27 (6120 days ago) |
| Edricson | 2007-08-09 (6138 days ago) |
| Smiddle | 2007-04-21 (6248 days ago) |
| Skagedal | 2007-04-01 (6267 days ago) |
| Yenx | 2007-01-08 (6351 days ago) |
| Kruosio | 2006-12-11 (6378 days ago) |
| NERIUM | 2006-06-29 (6544 days ago) |
| Jniemenmaa | 2006-06-12 (6561 days ago) |
| Marsve | 2006-05-05 (6598 days ago) |
| Aktalo | 2006-01-23 (6701 days ago) |
| Diyako | 2006-01-17 (6707 days ago) |
| Storpilot | 2005-12-12 (6742 days ago) |
| Scoo | 2005-12-08 (6747 days ago) |
| Qwm | 2005-11-16 (6769 days ago) |
| ShineB | 2005-09-29 (6816 days ago) |
| Tehvata | 2005-07-01 (6906 days ago) |
31 rows in set (3 min 51.74 sec)
uk/Ukrainian[edit]
last update: 2008-03-28 (5906 days ago)
| Name | Last edit |
|---|---|
| Ahonc | 2008-03-25 (5908 days ago) |
| Riwnodennyk | 2008-03-25 (5908 days ago) |
| A1 | 2008-02-11 (5951 days ago) |
| Ilyaroz | 2008-01-27 (5967 days ago) |
| Movses | 2008-01-23 (5971 days ago) |
| Yakudza | 2007-11-20 (6035 days ago) |
| Minia | 2007-11-18 (6036 days ago) |
| EvgenyGenkin | 2007-11-13 (6041 days ago) |
| DmRodionov | 2007-08-25 (6121 days ago) |
| Mikolasz | 2007-07-14 (6163 days ago) |
| Hayk | 2007-07-07 (6170 days ago) |
| Panas | 2007-07-01 (6176 days ago) |
| Yms | 2007-04-09 (6259 days ago) |
| Nevermind | 2006-12-18 (6372 days ago) |
| Angryxpeh | 2006-12-14 (6375 days ago) |
| AndriyK | 2006-11-24 (6395 days ago) |
| Martynenka | 2006-11-08 (6411 days ago) |
| Redsunrising | 2006-11-04 (6415 days ago) |
| Ornil | 2006-11-03 (6416 days ago) |
| Jan-ivan | 2005-11-14 (6770 days ago) |
| Inetd | 2005-03-26 (7003 days ago) |
21 rows in set (1 min 55.31 sec)
vi/Vietnamese[edit]
last update: 2008-03-28 (5906 days ago)
| Name | Last edit |
|---|---|
| Vinhtantran | 2008-03-27 (5907 days ago) |
| Neoneurone | 2007-11-15 (6040 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
}}
|