User:Pathoschild/Translators by activity
From Meta, a Wikimedia project coordination wiki
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.
Contents
Lists[edit]
bg/Bulgarian[edit]
last update: 2008-03-28 (3080 days ago)
| Name | Last edit |
|---|---|
| Spiritia | 2008-03-20 (3088 days ago) |
| Timurberk | 2008-02-04 (3133 days ago) |
| Daggerstab | 2008-01-19 (3149 days ago) |
| 5ko | 2008-01-01 (3167 days ago) |
| Azimski | 2007-09-19 (3271 days ago) |
| Nk | 2007-06-28 (3354 days ago) |
| Vanka5 | 2007-05-25 (3388 days ago) |
| Sharkb | 2007-01-21 (3512 days ago) |
| Bggoldie | 2006-12-19 (3545 days ago) |
| DCLXVI | 2006-08-06 (3680 days ago) |
| Smartech | 2006-04-14 (3794 days ago) |
| Glimz | 2006-04-02 (3806 days ago) |
| Espetkov | 2005-06-05 (4107 days ago) |
13 rows in set (56.82 sec)
bn/Bengali[edit]
last update: 2008-03-28 (3080 days ago)
| Name | Last edit |
|---|---|
| Bellayet | 2008-03-26 (3082 days ago) |
| Aeetlrsk | 2008-02-04 (3132 days ago) |
| Frdayeen | 2008-01-08 (3160 days ago) |
| Hermitage17 | 2008-01-08 (3160 days ago) |
4 rows in set (9.26 sec)
fi/Finnish[edit]
last update: 2008-03-28 (3080 days ago)
| Name | Last edit |
|---|---|
| AtteL | 2008-03-25 (3083 days ago) |
| Str4nd | 2008-03-24 (3084 days ago) |
| Roosa | 2008-03-05 (3103 days ago) |
| Malhonen | 2008-02-13 (3124 days ago) |
| Ilaiho | 2007-12-25 (3174 days ago) |
| Argus | 2007-11-12 (3217 days ago) |
| Jariola | 2007-10-29 (3231 days ago) |
| Kyzyl | 2007-07-16 (3336 days ago) |
| Skuolfi | 2007-05-13 (3400 days ago) |
| Urvabara | 2007-02-08 (3494 days ago) |
| Jni | 2007-01-29 (3504 days ago) |
| NZ- | 2006-12-30 (3533 days ago) |
| Vilu | 2006-12-26 (3538 days ago) |
| Hartz | 2006-12-15 (3549 days ago) |
| Mzlla | 2006-12-07 (3557 days ago) |
| Inzulac | 2006-10-31 (3594 days ago) |
| Lauranen | 2006-10-02 (3623 days ago) |
| Totuus | 2006-09-05 (3650 days ago) |
| Anchjo | 2006-08-31 (3655 days ago) |
| Pwc | 2006-08-05 (3681 days ago) |
| Kouluhai | 2006-06-23 (3724 days ago) |
| Jniemenmaa | 2006-06-12 (3735 days ago) |
| Bobet | 2006-02-06 (3861 days ago) |
| Finlandia | 2005-12-28 (3901 days ago) |
| Hapsiainen | 2005-12-09 (3920 days ago) |
| Viznut | 2005-07-27 (4055 days ago) |
| Lanahard | 2005-07-21 (4061 days ago) |
| Rdnk | 2005-05-24 (4119 days ago) |
31 rows in set (55.17 sec)
es/Spanish[edit]
last update: 2008-03-28 (3080 days ago)
| Name | Last edit |
|---|---|
| Spacebirdy | 2008-03-27 (3081 days ago) |
| Bengoa | 2008-03-27 (3081 days ago) |
| Kylu | 2008-03-27 (3081 days ago) |
| Julie | 2008-03-26 (3082 days ago) |
| Taichi | 2008-03-26 (3082 days ago) |
| Ascánder | 2008-03-26 (3082 days ago) |
| Smeira | 2008-03-26 (3082 days ago) |
| SMP | 2008-03-26 (3082 days ago) |
| Drini | 2008-03-26 (3082 days ago) |
| Rdsmith4 | 2008-03-25 (3083 days ago) |
| Masterches | 2008-03-25 (3083 days ago) |
| Wikimistusik | 2008-03-25 (3083 days ago) |
| Mikel | 2008-03-25 (3083 days ago) |
| Willtron | 2008-03-24 (3084 days ago) |
| CHV | 2008-03-24 (3084 days ago) |
| Tosão | 2008-03-23 (3085 days ago) |
| Redux | 2008-03-21 (3087 days ago) |
| Xic667 | 2008-03-21 (3087 days ago) |
| LaosLos | 2008-03-20 (3088 days ago) |
| BetoCG | 2008-03-17 (3090 days ago) |
| DamianFinol | 2008-03-16 (3092 days ago) |
| Jurock | 2008-03-13 (3095 days ago) |
| Oswaldo2025 | 2008-03-13 (3095 days ago) |
| Damërung | 2008-03-08 (3100 days ago) |
| Alhen | 2008-03-06 (3102 days ago) |
| Fajro | 2008-03-04 (3104 days ago) |
| LadyInGrey | 2008-03-03 (3105 days ago) |
| Barcex | 2008-03-02 (3106 days ago) |
| Alpertron | 2008-02-29 (3108 days ago) |
| Cromwellt | 2008-02-29 (3108 days ago) |
| RedCoat | 2008-02-28 (3109 days ago) |
| Sapey | 2008-02-20 (3117 days ago) |
| Elisardojm | 2008-02-20 (3117 days ago) |
| Lascorz | 2008-02-19 (3118 days ago) |
| Rastrojo | 2008-02-19 (3118 days ago) |
| Cedric31 | 2008-02-19 (3118 days ago) |
| Prevert | 2008-02-16 (3121 days ago) |
| Aleator | 2008-02-15 (3122 days ago) |
| Zuirdj | 2008-02-15 (3122 days ago) |
| Orereta | 2008-02-15 (3122 days ago) |
| FrancoGG | 2008-02-11 (3126 days ago) |
| Loco085 | 2008-02-10 (3127 days ago) |
| Agüeybaná | 2008-02-10 (3127 days ago) |
| Mtmelendez | 2008-02-08 (3129 days ago) |
| TXiKi | 2008-02-08 (3129 days ago) |
| SCPS | 2008-02-07 (3129 days ago) |
| Toliño | 2008-02-07 (3130 days ago) |
| Theklan | 2008-02-07 (3130 days ago) |
| ReyBrujo | 2008-02-05 (3132 days ago) |
| Vilallonga | 2008-01-30 (3138 days ago) |
| Gaudio | 2008-01-25 (3143 days ago) |
| AlimanRuna | 2008-01-24 (3144 days ago) |
| Xtv | 2008-01-19 (3149 days ago) |
| Vriullop | 2008-01-18 (3150 days ago) |
| Desiphral | 2008-01-16 (3152 days ago) |
| DDarkfire | 2008-01-15 (3153 days ago) |
| Jove | 2008-01-08 (3160 days ago) |
| Pepelopex | 2008-01-07 (3161 days ago) |
| Esbardu | 2008-01-07 (3161 days ago) |
| Carles | 2007-12-30 (3169 days ago) |
| Celestianpower | 2007-12-30 (3169 days ago) |
| RRmeta | 2007-12-30 (3169 days ago) |
| Axxgreazz | 2007-12-23 (3176 days ago) |
| Sobreira | 2007-12-22 (3177 days ago) |
| Varano | 2007-12-18 (3181 days ago) |
| Chlewey | 2007-12-17 (3182 days ago) |
| Javierm | 2007-12-13 (3186 days ago) |
| Kipmaster | 2007-12-10 (3189 days ago) |
| Adalbertofrenesi | 2007-12-07 (3192 days ago) |
| JB82 | 2007-12-06 (3193 days ago) |
| Patstuart | 2007-12-04 (3195 days ago) |
| Subtiempo | 2007-11-30 (3199 days ago) |
| Jaranda | 2007-11-30 (3199 days ago) |
| Mac | 2007-11-29 (3200 days ago) |
| Lmbuga | 2007-11-28 (3201 days ago) |
| Janfri | 2007-11-28 (3201 days ago) |
| Banjo | 2007-11-24 (3205 days ago) |
| Malvenko | 2007-11-23 (3206 days ago) |
| Iradigalesc | 2007-11-23 (3206 days ago) |
| Llull | 2007-11-23 (3206 days ago) |
| Lohen11 | 2007-11-21 (3207 days ago) |
| Vibragiel | 2007-11-20 (3208 days ago) |
| Sanbec | 2007-11-20 (3209 days ago) |
| Yrithinnd | 2007-11-19 (3210 days ago) |
| Bdenk715 | 2007-11-14 (3215 days ago) |
| Marianocecowski | 2007-11-12 (3217 days ago) |
| Kuartas | 2007-11-10 (3219 days ago) |
| GlimmerPhoenix | 2007-11-09 (3220 days ago) |
| Fryant | 2007-11-08 (3221 days ago) |
| Edub | 2007-10-28 (3232 days ago) |
| Jynus | 2007-10-24 (3236 days ago) |
| Prietoquilmes | 2007-10-21 (3238 days ago) |
| Spangineer | 2007-10-14 (3246 days ago) |
| Pcongre | 2007-10-13 (3247 days ago) |
| Rodasmith | 2007-10-11 (3249 days ago) |
| JorgeGG | 2007-10-08 (3252 days ago) |
| Battroid | 2007-10-06 (3254 days ago) |
| Morza | 2007-09-30 (3260 days ago) |
| Albdallah | 2007-09-29 (3261 days ago) |
| Albeiror24 | 2007-09-29 (3261 days ago) |
100 rows in set (1 min 17.61 sec)
hi/Hindi[edit]
last update: 2008-03-28 (3080 days ago)
| Name | Last edit |
|---|---|
| Ashishbhatnagar | 2008-02-22 (3115 days ago) |
| Rajeevmass | 2008-02-07 (3130 days ago) |
| Eukesh | 2008-02-03 (3134 days ago) |
| Shyam | 2008-01-10 (3158 days ago) |
| Srikeit | 2007-12-06 (3193 days ago) |
| Sanjaybafnaji | 2007-07-26 (3326 days ago) |
| Mexxian | 2007-05-27 (3386 days ago) |
| Spundun | 2007-03-30 (3444 days ago) |
| Shreshth91 | 2007-02-16 (3486 days ago) |
| Jdas07 | 2006-09-12 (3643 days ago) |
| Dineshjk | 2005-08-05 (4046 days ago) |
| Abhishekbh | 2005-04-21 (4152 days ago) |
12 rows in set (43.28 sec)
ja/Japanese[edit]
last update: 2008-03-28 (3080 days ago)
| Name | Last edit |
|---|---|
| Tuinui | 2008-03-27 (3081 days ago) |
| Bookman | 2008-03-27 (3081 days ago) |
| Aphaia | 2008-03-27 (3081 days ago) |
| Kahusi | 2008-03-26 (3082 days ago) |
| Me2hero | 2008-03-26 (3082 days ago) |
| Genppy | 2008-03-26 (3082 days ago) |
| Kanjy | 2008-03-25 (3083 days ago) |
| Ninomy | 2008-03-25 (3083 days ago) |
| Kzhr | 2008-03-25 (3083 days ago) |
| LERK | 2008-03-25 (3083 days ago) |
| ZCU | 2008-03-24 (3084 days ago) |
| ゆいしあす | 2008-03-24 (3084 days ago) |
| Marine-Blue | 2008-03-22 (3086 days ago) |
| Courant | 2008-03-22 (3086 days ago) |
| Miya | 2008-03-20 (3088 days ago) |
| Mulukhiyya | 2008-03-12 (3096 days ago) |
| Mzm5zbC3 | 2008-03-11 (3097 days ago) |
| Bletilla | 2008-03-08 (3100 days ago) |
| Aotake | 2008-03-08 (3100 days ago) |
| Widehawk | 2008-03-04 (3104 days ago) |
| おはぐろ蜻蛉 | 2008-02-28 (3109 days ago) |
| ネッツ | 2008-02-27 (3110 days ago) |
| NJT | 2008-02-24 (3113 days ago) |
| 朝彦 | 2008-02-24 (3113 days ago) |
| Yassie | 2008-02-21 (3116 days ago) |
| 辞典の虫 | 2008-02-16 (3121 days ago) |
| Tommy6 | 2008-02-13 (3124 days ago) |
| Peccafly | 2008-02-10 (3127 days ago) |
| Uryah | 2008-02-10 (3127 days ago) |
| Kstigarbha | 2008-02-03 (3134 days ago) |
| Bukki | 2008-02-03 (3134 days ago) |
| Bellcricket | 2008-02-02 (3135 days ago) |
| Sylphie | 2008-02-01 (3136 days ago) |
| Pica | 2008-02-01 (3136 days ago) |
| Quatro | 2008-01-30 (3138 days ago) |
| Miya.m | 2008-01-29 (3139 days ago) |
| Londonbashi | 2008-01-28 (3140 days ago) |
| Kickaha | 2008-01-27 (3141 days ago) |
| Co.kyoto | 2008-01-27 (3141 days ago) |
| Hirokun | 2008-01-27 (3141 days ago) |
| Complex01 | 2008-01-27 (3141 days ago) |
| 千代林檎 | 2008-01-26 (3142 days ago) |
| Lonicera | 2008-01-25 (3143 days ago) |
| ZERBERUS | 2008-01-25 (3143 days ago) |
| Hyolee2 | 2008-01-25 (3143 days ago) |
| Tangotango | 2008-01-18 (3150 days ago) |
| Lemonsquash | 2008-01-16 (3152 days ago) |
| Knua | 2008-01-12 (3156 days ago) |
| Michey.M | 2008-01-05 (3163 days ago) |
| SS95 | 2007-12-27 (3172 days ago) |
| Suzuyoshinine | 2007-12-21 (3178 days ago) |
| Horlicks | 2007-12-21 (3178 days ago) |
| Volfgang | 2007-12-16 (3183 days ago) |
| Watermint | 2007-12-14 (3185 days ago) |
| Schu | 2007-12-14 (3185 days ago) |
| Tietew | 2007-12-10 (3189 days ago) |
| Dekimasu | 2007-12-04 (3195 days ago) |
| Swind | 2007-12-03 (3196 days ago) |
| Kareha | 2007-12-01 (3198 days ago) |
| Tamtarm | 2007-11-29 (3200 days ago) |
| Clarin | 2007-11-29 (3200 days ago) |
| Kasuga | 2007-11-28 (3201 days ago) |
| 11ChamOK | 2007-11-28 (3201 days ago) |
| Kurihaya | 2007-11-28 (3201 days ago) |
| Lusheeta | 2007-11-28 (3201 days ago) |
| Noraneko | 2007-11-28 (3201 days ago) |
| Kotodama-Reverse | 2007-11-26 (3203 days ago) |
| T-coco | 2007-11-26 (3203 days ago) |
| Numerike | 2007-11-26 (3203 days ago) |
| 霧木諒二 | 2007-11-26 (3203 days ago) |
| Takot | 2007-11-25 (3204 days ago) |
| Himetv | 2007-10-24 (3236 days ago) |
| Remington | 2007-10-20 (3240 days ago) |
| SantaClaus | 2007-09-25 (3265 days ago) |
| T.Saito | 2007-09-24 (3266 days ago) |
| Tiens | 2007-09-18 (3272 days ago) |
| Coryjp | 2007-09-05 (3285 days ago) |
| Muyo | 2007-09-03 (3287 days ago) |
| Ribbon | 2007-08-16 (3305 days ago) |
| Penpen | 2007-08-08 (3313 days ago) |
| PiaCarrot | 2007-08-04 (3317 days ago) |
| YouShow | 2007-07-27 (3325 days ago) |
| Chinneeb | 2007-07-03 (3349 days ago) |
| HALPHA | 2007-07-01 (3351 days ago) |
| Tonync | 2007-05-17 (3396 days ago) |
| Araisyohei | 2007-04-21 (3422 days ago) |
| 七星 | 2007-04-21 (3422 days ago) |
| LQVX | 2007-04-16 (3427 days ago) |
| Goncyan | 2007-04-05 (3438 days ago) |
| 端くれの錬金術師 | 2007-04-02 (3441 days ago) |
| Matsumomushi | 2007-03-25 (3449 days ago) |
| かんがへなし | 2007-03-17 (3457 days ago) |
| Rocky7 | 2007-03-16 (3458 days ago) |
| Lonchi** | 2007-03-09 (3465 days ago) |
| っ | 2007-02-17 (3485 days ago) |
| Kkkdc | 2007-02-16 (3486 days ago) |
| Diagraph01 | 2007-02-06 (3496 days ago) |
| Pachayachachic | 2007-02-03 (3499 days ago) |
| Adr6721 | 2007-02-01 (3501 days ago) |
| Su-no-G | 2007-02-01 (3501 days ago) |
100 rows in set (1 min 2.26 sec)
id/Bahasa Indonesian[edit]
last update: 2008-03-28 (3080 days ago)
| Name | Last edit |
|---|---|
| Azmi1995 | 2008-03-25 (3083 days ago) |
| IDRex | 2008-03-25 (3083 days ago) |
| IvanLanin | 2008-03-22 (3085 days ago) |
| Mimihitam | 2008-03-19 (3089 days ago) |
| Master2841 | 2008-03-08 (3100 days ago) |
| Chriswaterguy | 2008-03-07 (3101 days ago) |
| Borgx | 2008-03-04 (3104 days ago) |
| Kandar | 2008-02-18 (3119 days ago) |
| Meursault2004 | 2008-02-12 (3125 days ago) |
| Dragunova | 2008-02-08 (3129 days ago) |
| Hariadhi | 2007-08-03 (3318 days ago) |
| Irwangatot | 2007-06-12 (3370 days ago) |
| Anggoro | 2006-12-07 (3557 days ago) |
| Winana | 2006-11-22 (3572 days ago) |
| Anggreani | 2006-08-04 (3682 days ago) |
| HarisX | 2006-05-12 (3766 days ago) |
| Zaidpjd | 2005-11-20 (3939 days ago) |
| Widhiantoro | 2005-11-18 (3941 days ago) |
| Sudiryo | 2005-11-18 (3941 days ago) |
| *drew | 2005-11-08 (3951 days ago) |
20 rows in set (51.73 sec)
ro/Romanian[edit]
last update: 2008-03-28 (3080 days ago)
| Name | Last edit |
|---|---|
| SCriBu | 2008-02-24 (3113 days ago) |
| Cuman | 2008-01-25 (3143 days ago) |
| Desiphral | 2008-01-16 (3152 days ago) |
| IulianU | 2008-01-14 (3154 days ago) |
| AQUA | 2007-12-20 (3179 days ago) |
| Romihaitza | 2007-11-27 (3202 days ago) |
| BlueMonday | 2007-11-24 (3205 days ago) |
| Dorothea | 2007-11-19 (3210 days ago) |
| Bogdan | 2007-10-22 (3238 days ago) |
| Mocu | 2007-06-09 (3373 days ago) |
| Lorandka | 2007-01-05 (3527 days ago) |
| TSO1D | 2006-12-01 (3563 days ago) |
| Ronline | 2006-11-18 (3576 days ago) |
| Dmaftei | 2006-10-05 (3620 days ago) |
| Evosphere | 2006-07-14 (3703 days ago) |
| Orioane | 2006-06-29 (3718 days ago) |
| Victort | 2006-01-02 (3896 days ago) |
| NazismIsntCool | 2005-11-06 (3953 days ago) |
18 rows in set (55.09 sec)
sv/Swedish[edit]
last update: 2008-03-28 (3080 days ago)
| Name | Last edit |
|---|---|
| Micke | 2008-03-27 (3081 days ago) |
| Robertgreer | 2008-03-26 (3082 days ago) |
| M.M.S. | 2008-03-26 (3082 days ago) |
| Habj | 2008-03-25 (3083 days ago) |
| SvHannibal | 2008-03-24 (3084 days ago) |
| Moralist | 2008-03-24 (3084 days ago) |
| Boivie | 2008-03-14 (3094 days ago) |
| Mikez | 2008-03-04 (3104 days ago) |
| Riggwelter | 2008-02-16 (3121 days ago) |
| Malhonen | 2008-02-13 (3124 days ago) |
| LX | 2008-01-15 (3153 days ago) |
| Skomakarn | 2008-01-07 (3161 days ago) |
| Johngreen | 2007-12-04 (3195 days ago) |
| RaSten | 2007-10-21 (3239 days ago) |
| Pcongre | 2007-10-13 (3247 days ago) |
| Klibbnisse | 2007-08-27 (3294 days ago) |
| Edricson | 2007-08-09 (3312 days ago) |
| Smiddle | 2007-04-21 (3422 days ago) |
| Skagedal | 2007-04-01 (3442 days ago) |
| Yenx | 2007-01-08 (3525 days ago) |
| Kruosio | 2006-12-11 (3553 days ago) |
| NERIUM | 2006-06-29 (3718 days ago) |
| Jniemenmaa | 2006-06-12 (3735 days ago) |
| Marsve | 2006-05-05 (3773 days ago) |
| Aktalo | 2006-01-23 (3875 days ago) |
| Diyako | 2006-01-17 (3881 days ago) |
| Storpilot | 2005-12-12 (3917 days ago) |
| Scoo | 2005-12-08 (3921 days ago) |
| Qwm | 2005-11-16 (3943 days ago) |
| ShineB | 2005-09-29 (3991 days ago) |
| Tehvata | 2005-07-01 (4081 days ago) |
31 rows in set (3 min 51.74 sec)
uk/Ukrainian[edit]
last update: 2008-03-28 (3080 days ago)
| Name | Last edit |
|---|---|
| Ahonc | 2008-03-25 (3083 days ago) |
| Riwnodennyk | 2008-03-25 (3083 days ago) |
| A1 | 2008-02-11 (3126 days ago) |
| Ilyaroz | 2008-01-27 (3141 days ago) |
| Movses | 2008-01-23 (3145 days ago) |
| Yakudza | 2007-11-20 (3209 days ago) |
| Minia | 2007-11-18 (3211 days ago) |
| EvgenyGenkin | 2007-11-13 (3216 days ago) |
| DmRodionov | 2007-08-25 (3296 days ago) |
| Mikolasz | 2007-07-14 (3338 days ago) |
| Hayk | 2007-07-07 (3345 days ago) |
| Panas | 2007-07-01 (3351 days ago) |
| Yms | 2007-04-09 (3434 days ago) |
| Nevermind | 2006-12-18 (3546 days ago) |
| Angryxpeh | 2006-12-14 (3550 days ago) |
| AndriyK | 2006-11-24 (3570 days ago) |
| Martynenka | 2006-11-08 (3586 days ago) |
| Redsunrising | 2006-11-04 (3590 days ago) |
| Ornil | 2006-11-03 (3591 days ago) |
| Jan-ivan | 2005-11-14 (3945 days ago) |
| Inetd | 2005-03-26 (4178 days ago) |
21 rows in set (1 min 55.31 sec)
vi/Vietnamese[edit]
last update: 2008-03-28 (3080 days ago)
| Name | Last edit |
|---|---|
| Vinhtantran | 2008-03-27 (3081 days ago) |
| Neoneurone | 2007-11-15 (3214 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
}}
|
