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.
Contents
Lists[edit]
bg/Bulgarian[edit]
last update: 2008-03-28 (3416 days ago)
| Name | Last edit |
|---|---|
| Spiritia | 2008-03-20 (3423 days ago) |
| Timurberk | 2008-02-04 (3468 days ago) |
| Daggerstab | 2008-01-19 (3484 days ago) |
| 5ko | 2008-01-01 (3502 days ago) |
| Azimski | 2007-09-19 (3606 days ago) |
| Nk | 2007-06-28 (3689 days ago) |
| Vanka5 | 2007-05-25 (3723 days ago) |
| Sharkb | 2007-01-21 (3847 days ago) |
| Bggoldie | 2006-12-19 (3880 days ago) |
| DCLXVI | 2006-08-06 (4015 days ago) |
| Smartech | 2006-04-14 (4129 days ago) |
| Glimz | 2006-04-02 (4141 days ago) |
| Espetkov | 2005-06-05 (4442 days ago) |
13 rows in set (56.82 sec)
bn/Bengali[edit]
last update: 2008-03-28 (3416 days ago)
| Name | Last edit |
|---|---|
| Bellayet | 2008-03-26 (3417 days ago) |
| Aeetlrsk | 2008-02-04 (3468 days ago) |
| Frdayeen | 2008-01-08 (3495 days ago) |
| Hermitage17 | 2008-01-08 (3495 days ago) |
4 rows in set (9.26 sec)
fi/Finnish[edit]
last update: 2008-03-28 (3416 days ago)
| Name | Last edit |
|---|---|
| AtteL | 2008-03-25 (3418 days ago) |
| Str4nd | 2008-03-24 (3419 days ago) |
| Roosa | 2008-03-05 (3439 days ago) |
| Malhonen | 2008-02-13 (3459 days ago) |
| Ilaiho | 2007-12-25 (3509 days ago) |
| Argus | 2007-11-12 (3552 days ago) |
| Jariola | 2007-10-29 (3566 days ago) |
| Kyzyl | 2007-07-16 (3671 days ago) |
| Skuolfi | 2007-05-13 (3735 days ago) |
| Urvabara | 2007-02-08 (3829 days ago) |
| Jni | 2007-01-29 (3839 days ago) |
| NZ- | 2006-12-30 (3869 days ago) |
| Vilu | 2006-12-26 (3873 days ago) |
| Hartz | 2006-12-15 (3884 days ago) |
| Mzlla | 2006-12-07 (3892 days ago) |
| Inzulac | 2006-10-31 (3929 days ago) |
| Lauranen | 2006-10-02 (3958 days ago) |
| Totuus | 2006-09-05 (3985 days ago) |
| Anchjo | 2006-08-31 (3990 days ago) |
| Pwc | 2006-08-05 (4016 days ago) |
| Kouluhai | 2006-06-23 (4059 days ago) |
| Jniemenmaa | 2006-06-12 (4070 days ago) |
| Bobet | 2006-02-06 (4196 days ago) |
| Finlandia | 2005-12-28 (4236 days ago) |
| Hapsiainen | 2005-12-09 (4255 days ago) |
| Viznut | 2005-07-27 (4390 days ago) |
| Lanahard | 2005-07-21 (4396 days ago) |
| Rdnk | 2005-05-24 (4454 days ago) |
31 rows in set (55.17 sec)
es/Spanish[edit]
last update: 2008-03-28 (3416 days ago)
| Name | Last edit |
|---|---|
| Spacebirdy | 2008-03-27 (3416 days ago) |
| Bengoa | 2008-03-27 (3416 days ago) |
| Kylu | 2008-03-27 (3416 days ago) |
| Julie | 2008-03-26 (3417 days ago) |
| Taichi | 2008-03-26 (3417 days ago) |
| Ascánder | 2008-03-26 (3417 days ago) |
| Smeira | 2008-03-26 (3417 days ago) |
| SMP | 2008-03-26 (3417 days ago) |
| Drini | 2008-03-26 (3417 days ago) |
| Rdsmith4 | 2008-03-25 (3418 days ago) |
| Masterches | 2008-03-25 (3418 days ago) |
| Wikimistusik | 2008-03-25 (3418 days ago) |
| Mikel | 2008-03-25 (3418 days ago) |
| Willtron | 2008-03-24 (3419 days ago) |
| CHV | 2008-03-24 (3419 days ago) |
| Tosão | 2008-03-23 (3420 days ago) |
| Redux | 2008-03-21 (3422 days ago) |
| Xic667 | 2008-03-21 (3422 days ago) |
| LaosLos | 2008-03-20 (3423 days ago) |
| BetoCG | 2008-03-17 (3426 days ago) |
| DamianFinol | 2008-03-16 (3427 days ago) |
| Jurock | 2008-03-13 (3430 days ago) |
| Oswaldo2025 | 2008-03-13 (3431 days ago) |
| Damërung | 2008-03-08 (3435 days ago) |
| Alhen | 2008-03-06 (3437 days ago) |
| Fajro | 2008-03-04 (3439 days ago) |
| LadyInGrey | 2008-03-03 (3440 days ago) |
| Barcex | 2008-03-02 (3441 days ago) |
| Alpertron | 2008-02-29 (3443 days ago) |
| Cromwellt | 2008-02-29 (3443 days ago) |
| RedCoat | 2008-02-28 (3444 days ago) |
| Sapey | 2008-02-20 (3452 days ago) |
| Elisardojm | 2008-02-20 (3452 days ago) |
| Lascorz | 2008-02-19 (3453 days ago) |
| Rastrojo | 2008-02-19 (3453 days ago) |
| Cedric31 | 2008-02-19 (3453 days ago) |
| Prevert | 2008-02-16 (3456 days ago) |
| Aleator | 2008-02-15 (3457 days ago) |
| Zuirdj | 2008-02-15 (3457 days ago) |
| Orereta | 2008-02-15 (3457 days ago) |
| FrancoGG | 2008-02-11 (3461 days ago) |
| Loco085 | 2008-02-10 (3462 days ago) |
| Agüeybaná | 2008-02-10 (3462 days ago) |
| Mtmelendez | 2008-02-08 (3464 days ago) |
| TXiKi | 2008-02-08 (3464 days ago) |
| SCPS | 2008-02-07 (3465 days ago) |
| Toliño | 2008-02-07 (3465 days ago) |
| Theklan | 2008-02-07 (3465 days ago) |
| ReyBrujo | 2008-02-05 (3467 days ago) |
| Vilallonga | 2008-01-30 (3473 days ago) |
| Gaudio | 2008-01-25 (3478 days ago) |
| AlimanRuna | 2008-01-24 (3479 days ago) |
| Xtv | 2008-01-19 (3484 days ago) |
| Vriullop | 2008-01-18 (3485 days ago) |
| Desiphral | 2008-01-16 (3487 days ago) |
| DDarkfire | 2008-01-15 (3488 days ago) |
| Jove | 2008-01-08 (3495 days ago) |
| Pepelopex | 2008-01-07 (3496 days ago) |
| Esbardu | 2008-01-07 (3496 days ago) |
| Carles | 2007-12-30 (3504 days ago) |
| Celestianpower | 2007-12-30 (3504 days ago) |
| RRmeta | 2007-12-30 (3504 days ago) |
| Axxgreazz | 2007-12-23 (3511 days ago) |
| Sobreira | 2007-12-22 (3512 days ago) |
| Varano | 2007-12-18 (3516 days ago) |
| Chlewey | 2007-12-17 (3517 days ago) |
| Javierm | 2007-12-13 (3521 days ago) |
| Kipmaster | 2007-12-10 (3524 days ago) |
| Adalbertofrenesi | 2007-12-07 (3527 days ago) |
| JB82 | 2007-12-06 (3528 days ago) |
| Patstuart | 2007-12-04 (3530 days ago) |
| Subtiempo | 2007-11-30 (3534 days ago) |
| Jaranda | 2007-11-30 (3534 days ago) |
| Mac | 2007-11-29 (3535 days ago) |
| Lmbuga | 2007-11-28 (3536 days ago) |
| Janfri | 2007-11-28 (3536 days ago) |
| Banjo | 2007-11-24 (3540 days ago) |
| Malvenko | 2007-11-23 (3541 days ago) |
| Iradigalesc | 2007-11-23 (3541 days ago) |
| Llull | 2007-11-23 (3541 days ago) |
| Lohen11 | 2007-11-21 (3543 days ago) |
| Vibragiel | 2007-11-20 (3544 days ago) |
| Sanbec | 2007-11-20 (3544 days ago) |
| Yrithinnd | 2007-11-19 (3545 days ago) |
| Bdenk715 | 2007-11-14 (3550 days ago) |
| Marianocecowski | 2007-11-12 (3552 days ago) |
| Kuartas | 2007-11-10 (3554 days ago) |
| GlimmerPhoenix | 2007-11-09 (3555 days ago) |
| Fryant | 2007-11-08 (3556 days ago) |
| Edub | 2007-10-28 (3567 days ago) |
| Jynus | 2007-10-24 (3571 days ago) |
| Prietoquilmes | 2007-10-21 (3574 days ago) |
| Spangineer | 2007-10-14 (3581 days ago) |
| Pcongre | 2007-10-13 (3582 days ago) |
| Rodasmith | 2007-10-11 (3584 days ago) |
| JorgeGG | 2007-10-08 (3587 days ago) |
| Battroid | 2007-10-06 (3589 days ago) |
| Morza | 2007-09-30 (3595 days ago) |
| Albdallah | 2007-09-29 (3596 days ago) |
| Albeiror24 | 2007-09-29 (3596 days ago) |
100 rows in set (1 min 17.61 sec)
hi/Hindi[edit]
last update: 2008-03-28 (3416 days ago)
| Name | Last edit |
|---|---|
| Ashishbhatnagar | 2008-02-22 (3450 days ago) |
| Rajeevmass | 2008-02-07 (3465 days ago) |
| Eukesh | 2008-02-03 (3469 days ago) |
| Shyam | 2008-01-10 (3493 days ago) |
| Srikeit | 2007-12-06 (3528 days ago) |
| Sanjaybafnaji | 2007-07-26 (3661 days ago) |
| Mexxian | 2007-05-27 (3721 days ago) |
| Spundun | 2007-03-30 (3779 days ago) |
| Shreshth91 | 2007-02-16 (3821 days ago) |
| Jdas07 | 2006-09-12 (3978 days ago) |
| Dineshjk | 2005-08-05 (4381 days ago) |
| Abhishekbh | 2005-04-21 (4487 days ago) |
12 rows in set (43.28 sec)
ja/Japanese[edit]
last update: 2008-03-28 (3416 days ago)
| Name | Last edit |
|---|---|
| Tuinui | 2008-03-27 (3416 days ago) |
| Bookman | 2008-03-27 (3416 days ago) |
| Aphaia | 2008-03-27 (3416 days ago) |
| Kahusi | 2008-03-26 (3417 days ago) |
| Me2hero | 2008-03-26 (3417 days ago) |
| Genppy | 2008-03-26 (3417 days ago) |
| Kanjy | 2008-03-25 (3418 days ago) |
| Ninomy | 2008-03-25 (3418 days ago) |
| Kzhr | 2008-03-25 (3418 days ago) |
| LERK | 2008-03-25 (3418 days ago) |
| ZCU | 2008-03-24 (3419 days ago) |
| ゆいしあす | 2008-03-24 (3419 days ago) |
| Marine-Blue | 2008-03-22 (3421 days ago) |
| Courant | 2008-03-22 (3421 days ago) |
| Miya | 2008-03-20 (3423 days ago) |
| Mulukhiyya | 2008-03-12 (3431 days ago) |
| Mzm5zbC3 | 2008-03-11 (3432 days ago) |
| Bletilla | 2008-03-08 (3435 days ago) |
| Aotake | 2008-03-08 (3435 days ago) |
| Widehawk | 2008-03-04 (3439 days ago) |
| おはぐろ蜻蛉 | 2008-02-28 (3444 days ago) |
| ネッツ | 2008-02-27 (3445 days ago) |
| NJT | 2008-02-24 (3448 days ago) |
| 朝彦 | 2008-02-24 (3448 days ago) |
| Yassie | 2008-02-21 (3451 days ago) |
| 辞典の虫 | 2008-02-16 (3456 days ago) |
| Tommy6 | 2008-02-13 (3459 days ago) |
| Peccafly | 2008-02-10 (3462 days ago) |
| Uryah | 2008-02-10 (3462 days ago) |
| Kstigarbha | 2008-02-03 (3469 days ago) |
| Bukki | 2008-02-03 (3470 days ago) |
| Bellcricket | 2008-02-02 (3470 days ago) |
| Sylphie | 2008-02-01 (3471 days ago) |
| Pica | 2008-02-01 (3471 days ago) |
| Quatro | 2008-01-30 (3473 days ago) |
| Miya.m | 2008-01-29 (3474 days ago) |
| Londonbashi | 2008-01-28 (3475 days ago) |
| Kickaha | 2008-01-27 (3476 days ago) |
| Co.kyoto | 2008-01-27 (3476 days ago) |
| Hirokun | 2008-01-27 (3476 days ago) |
| Complex01 | 2008-01-27 (3476 days ago) |
| 千代林檎 | 2008-01-26 (3477 days ago) |
| Lonicera | 2008-01-25 (3478 days ago) |
| ZERBERUS | 2008-01-25 (3478 days ago) |
| Hyolee2 | 2008-01-25 (3478 days ago) |
| Tangotango | 2008-01-18 (3485 days ago) |
| Lemonsquash | 2008-01-16 (3487 days ago) |
| Knua | 2008-01-12 (3491 days ago) |
| Michey.M | 2008-01-05 (3498 days ago) |
| SS95 | 2007-12-27 (3507 days ago) |
| Suzuyoshinine | 2007-12-21 (3513 days ago) |
| Horlicks | 2007-12-21 (3513 days ago) |
| Volfgang | 2007-12-16 (3518 days ago) |
| Watermint | 2007-12-14 (3520 days ago) |
| Schu | 2007-12-14 (3520 days ago) |
| Tietew | 2007-12-10 (3524 days ago) |
| Dekimasu | 2007-12-04 (3530 days ago) |
| Swind | 2007-12-03 (3531 days ago) |
| Kareha | 2007-12-01 (3533 days ago) |
| Tamtarm | 2007-11-29 (3535 days ago) |
| Clarin | 2007-11-29 (3535 days ago) |
| Kasuga | 2007-11-28 (3536 days ago) |
| 11ChamOK | 2007-11-28 (3536 days ago) |
| Kurihaya | 2007-11-28 (3536 days ago) |
| Lusheeta | 2007-11-28 (3536 days ago) |
| Noraneko | 2007-11-28 (3537 days ago) |
| Kotodama-Reverse | 2007-11-26 (3538 days ago) |
| T-coco | 2007-11-26 (3538 days ago) |
| Numerike | 2007-11-26 (3538 days ago) |
| 霧木諒二 | 2007-11-26 (3538 days ago) |
| Takot | 2007-11-25 (3539 days ago) |
| Himetv | 2007-10-24 (3571 days ago) |
| Remington | 2007-10-20 (3575 days ago) |
| SantaClaus | 2007-09-25 (3600 days ago) |
| T.Saito | 2007-09-24 (3601 days ago) |
| Tiens | 2007-09-18 (3607 days ago) |
| Coryjp | 2007-09-05 (3620 days ago) |
| Muyo | 2007-09-03 (3622 days ago) |
| Ribbon | 2007-08-16 (3640 days ago) |
| Penpen | 2007-08-08 (3648 days ago) |
| PiaCarrot | 2007-08-04 (3652 days ago) |
| YouShow | 2007-07-27 (3660 days ago) |
| Chinneeb | 2007-07-03 (3684 days ago) |
| HALPHA | 2007-07-01 (3686 days ago) |
| Tonync | 2007-05-17 (3731 days ago) |
| Araisyohei | 2007-04-21 (3757 days ago) |
| 七星 | 2007-04-21 (3757 days ago) |
| LQVX | 2007-04-16 (3762 days ago) |
| Goncyan | 2007-04-05 (3773 days ago) |
| 端くれの錬金術師 | 2007-04-02 (3776 days ago) |
| Matsumomushi | 2007-03-25 (3784 days ago) |
| かんがへなし | 2007-03-17 (3792 days ago) |
| Rocky7 | 2007-03-16 (3793 days ago) |
| Lonchi** | 2007-03-09 (3800 days ago) |
| っ | 2007-02-17 (3820 days ago) |
| Kkkdc | 2007-02-16 (3821 days ago) |
| Diagraph01 | 2007-02-06 (3831 days ago) |
| Pachayachachic | 2007-02-03 (3834 days ago) |
| Adr6721 | 2007-02-01 (3836 days ago) |
| Su-no-G | 2007-02-01 (3836 days ago) |
100 rows in set (1 min 2.26 sec)
id/Bahasa Indonesian[edit]
last update: 2008-03-28 (3416 days ago)
| Name | Last edit |
|---|---|
| Azmi1995 | 2008-03-25 (3418 days ago) |
| IDRex | 2008-03-25 (3418 days ago) |
| IvanLanin | 2008-03-22 (3421 days ago) |
| Mimihitam | 2008-03-19 (3424 days ago) |
| Master2841 | 2008-03-08 (3435 days ago) |
| Chriswaterguy | 2008-03-07 (3436 days ago) |
| Borgx | 2008-03-04 (3439 days ago) |
| Kandar | 2008-02-18 (3454 days ago) |
| Meursault2004 | 2008-02-12 (3460 days ago) |
| Dragunova | 2008-02-08 (3464 days ago) |
| Hariadhi | 2007-08-03 (3653 days ago) |
| Irwangatot | 2007-06-12 (3705 days ago) |
| Anggoro | 2006-12-07 (3892 days ago) |
| Winana | 2006-11-22 (3907 days ago) |
| Anggreani | 2006-08-04 (4017 days ago) |
| HarisX | 2006-05-12 (4101 days ago) |
| Zaidpjd | 2005-11-20 (4274 days ago) |
| Widhiantoro | 2005-11-18 (4276 days ago) |
| Sudiryo | 2005-11-18 (4276 days ago) |
| *drew | 2005-11-08 (4286 days ago) |
20 rows in set (51.73 sec)
ro/Romanian[edit]
last update: 2008-03-28 (3416 days ago)
| Name | Last edit |
|---|---|
| SCriBu | 2008-02-24 (3448 days ago) |
| Cuman | 2008-01-25 (3478 days ago) |
| Desiphral | 2008-01-16 (3487 days ago) |
| IulianU | 2008-01-14 (3489 days ago) |
| AQUA | 2007-12-20 (3514 days ago) |
| Romihaitza | 2007-11-27 (3537 days ago) |
| BlueMonday | 2007-11-24 (3540 days ago) |
| Dorothea | 2007-11-19 (3545 days ago) |
| Bogdan | 2007-10-22 (3573 days ago) |
| Mocu | 2007-06-09 (3708 days ago) |
| Lorandka | 2007-01-05 (3863 days ago) |
| TSO1D | 2006-12-01 (3898 days ago) |
| Ronline | 2006-11-18 (3911 days ago) |
| Dmaftei | 2006-10-05 (3956 days ago) |
| Evosphere | 2006-07-14 (4038 days ago) |
| Orioane | 2006-06-29 (4053 days ago) |
| Victort | 2006-01-02 (4231 days ago) |
| NazismIsntCool | 2005-11-06 (4288 days ago) |
18 rows in set (55.09 sec)
sv/Swedish[edit]
last update: 2008-03-28 (3416 days ago)
| Name | Last edit |
|---|---|
| Micke | 2008-03-27 (3416 days ago) |
| Robertgreer | 2008-03-26 (3417 days ago) |
| M.M.S. | 2008-03-26 (3417 days ago) |
| Habj | 2008-03-25 (3418 days ago) |
| SvHannibal | 2008-03-24 (3419 days ago) |
| Moralist | 2008-03-24 (3419 days ago) |
| Boivie | 2008-03-14 (3429 days ago) |
| Mikez | 2008-03-04 (3440 days ago) |
| Riggwelter | 2008-02-16 (3456 days ago) |
| Malhonen | 2008-02-13 (3459 days ago) |
| LX | 2008-01-15 (3488 days ago) |
| Skomakarn | 2008-01-07 (3496 days ago) |
| Johngreen | 2007-12-04 (3530 days ago) |
| RaSten | 2007-10-21 (3574 days ago) |
| Pcongre | 2007-10-13 (3582 days ago) |
| Klibbnisse | 2007-08-27 (3629 days ago) |
| Edricson | 2007-08-09 (3647 days ago) |
| Smiddle | 2007-04-21 (3757 days ago) |
| Skagedal | 2007-04-01 (3777 days ago) |
| Yenx | 2007-01-08 (3860 days ago) |
| Kruosio | 2006-12-11 (3888 days ago) |
| NERIUM | 2006-06-29 (4053 days ago) |
| Jniemenmaa | 2006-06-12 (4070 days ago) |
| Marsve | 2006-05-05 (4108 days ago) |
| Aktalo | 2006-01-23 (4210 days ago) |
| Diyako | 2006-01-17 (4216 days ago) |
| Storpilot | 2005-12-12 (4252 days ago) |
| Scoo | 2005-12-08 (4256 days ago) |
| Qwm | 2005-11-16 (4278 days ago) |
| ShineB | 2005-09-29 (4326 days ago) |
| Tehvata | 2005-07-01 (4416 days ago) |
31 rows in set (3 min 51.74 sec)
uk/Ukrainian[edit]
last update: 2008-03-28 (3416 days ago)
| Name | Last edit |
|---|---|
| Ahonc | 2008-03-25 (3418 days ago) |
| Riwnodennyk | 2008-03-25 (3418 days ago) |
| A1 | 2008-02-11 (3461 days ago) |
| Ilyaroz | 2008-01-27 (3476 days ago) |
| Movses | 2008-01-23 (3480 days ago) |
| Yakudza | 2007-11-20 (3544 days ago) |
| Minia | 2007-11-18 (3546 days ago) |
| EvgenyGenkin | 2007-11-13 (3551 days ago) |
| DmRodionov | 2007-08-25 (3631 days ago) |
| Mikolasz | 2007-07-14 (3673 days ago) |
| Hayk | 2007-07-07 (3680 days ago) |
| Panas | 2007-07-01 (3686 days ago) |
| Yms | 2007-04-09 (3769 days ago) |
| Nevermind | 2006-12-18 (3881 days ago) |
| Angryxpeh | 2006-12-14 (3885 days ago) |
| AndriyK | 2006-11-24 (3905 days ago) |
| Martynenka | 2006-11-08 (3921 days ago) |
| Redsunrising | 2006-11-04 (3925 days ago) |
| Ornil | 2006-11-03 (3926 days ago) |
| Jan-ivan | 2005-11-14 (4280 days ago) |
| Inetd | 2005-03-26 (4513 days ago) |
21 rows in set (1 min 55.31 sec)
vi/Vietnamese[edit]
last update: 2008-03-28 (3416 days ago)
| Name | Last edit |
|---|---|
| Vinhtantran | 2008-03-27 (3416 days ago) |
| Neoneurone | 2007-11-15 (3549 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
}}
|
