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 (3366 days ago)
| Name | Last edit |
|---|---|
| Spiritia | 2008-03-20 (3373 days ago) |
| Timurberk | 2008-02-04 (3419 days ago) |
| Daggerstab | 2008-01-19 (3435 days ago) |
| 5ko | 2008-01-01 (3452 days ago) |
| Azimski | 2007-09-19 (3557 days ago) |
| Nk | 2007-06-28 (3640 days ago) |
| Vanka5 | 2007-05-25 (3674 days ago) |
| Sharkb | 2007-01-21 (3798 days ago) |
| Bggoldie | 2006-12-19 (3831 days ago) |
| DCLXVI | 2006-08-06 (3966 days ago) |
| Smartech | 2006-04-14 (4080 days ago) |
| Glimz | 2006-04-02 (4092 days ago) |
| Espetkov | 2005-06-05 (4393 days ago) |
13 rows in set (56.82 sec)
bn/Bengali[edit]
last update: 2008-03-28 (3366 days ago)
| Name | Last edit |
|---|---|
| Bellayet | 2008-03-26 (3367 days ago) |
| Aeetlrsk | 2008-02-04 (3418 days ago) |
| Frdayeen | 2008-01-08 (3446 days ago) |
| Hermitage17 | 2008-01-08 (3446 days ago) |
4 rows in set (9.26 sec)
fi/Finnish[edit]
last update: 2008-03-28 (3366 days ago)
| Name | Last edit |
|---|---|
| AtteL | 2008-03-25 (3369 days ago) |
| Str4nd | 2008-03-24 (3369 days ago) |
| Roosa | 2008-03-05 (3389 days ago) |
| Malhonen | 2008-02-13 (3409 days ago) |
| Ilaiho | 2007-12-25 (3459 days ago) |
| Argus | 2007-11-12 (3503 days ago) |
| Jariola | 2007-10-29 (3517 days ago) |
| Kyzyl | 2007-07-16 (3622 days ago) |
| Skuolfi | 2007-05-13 (3686 days ago) |
| Urvabara | 2007-02-08 (3780 days ago) |
| Jni | 2007-01-29 (3790 days ago) |
| NZ- | 2006-12-30 (3819 days ago) |
| Vilu | 2006-12-26 (3823 days ago) |
| Hartz | 2006-12-15 (3834 days ago) |
| Mzlla | 2006-12-07 (3843 days ago) |
| Inzulac | 2006-10-31 (3879 days ago) |
| Lauranen | 2006-10-02 (3909 days ago) |
| Totuus | 2006-09-05 (3935 days ago) |
| Anchjo | 2006-08-31 (3941 days ago) |
| Pwc | 2006-08-05 (3966 days ago) |
| Kouluhai | 2006-06-23 (4009 days ago) |
| Jniemenmaa | 2006-06-12 (4021 days ago) |
| Bobet | 2006-02-06 (4146 days ago) |
| Finlandia | 2005-12-28 (4187 days ago) |
| Hapsiainen | 2005-12-09 (4205 days ago) |
| Viznut | 2005-07-27 (4341 days ago) |
| Lanahard | 2005-07-21 (4346 days ago) |
| Rdnk | 2005-05-24 (4404 days ago) |
31 rows in set (55.17 sec)
es/Spanish[edit]
last update: 2008-03-28 (3366 days ago)
| Name | Last edit |
|---|---|
| Spacebirdy | 2008-03-27 (3367 days ago) |
| Bengoa | 2008-03-27 (3367 days ago) |
| Kylu | 2008-03-27 (3367 days ago) |
| Julie | 2008-03-26 (3367 days ago) |
| Taichi | 2008-03-26 (3367 days ago) |
| Ascánder | 2008-03-26 (3367 days ago) |
| Smeira | 2008-03-26 (3367 days ago) |
| SMP | 2008-03-26 (3367 days ago) |
| Drini | 2008-03-26 (3368 days ago) |
| Rdsmith4 | 2008-03-25 (3368 days ago) |
| Masterches | 2008-03-25 (3369 days ago) |
| Wikimistusik | 2008-03-25 (3369 days ago) |
| Mikel | 2008-03-25 (3369 days ago) |
| Willtron | 2008-03-24 (3369 days ago) |
| CHV | 2008-03-24 (3369 days ago) |
| Tosão | 2008-03-23 (3370 days ago) |
| Redux | 2008-03-21 (3373 days ago) |
| Xic667 | 2008-03-21 (3373 days ago) |
| LaosLos | 2008-03-20 (3374 days ago) |
| BetoCG | 2008-03-17 (3376 days ago) |
| DamianFinol | 2008-03-16 (3378 days ago) |
| Jurock | 2008-03-13 (3380 days ago) |
| Oswaldo2025 | 2008-03-13 (3381 days ago) |
| Damërung | 2008-03-08 (3386 days ago) |
| Alhen | 2008-03-06 (3388 days ago) |
| Fajro | 2008-03-04 (3390 days ago) |
| LadyInGrey | 2008-03-03 (3390 days ago) |
| Barcex | 2008-03-02 (3392 days ago) |
| Alpertron | 2008-02-29 (3393 days ago) |
| Cromwellt | 2008-02-29 (3394 days ago) |
| RedCoat | 2008-02-28 (3395 days ago) |
| Sapey | 2008-02-20 (3402 days ago) |
| Elisardojm | 2008-02-20 (3403 days ago) |
| Lascorz | 2008-02-19 (3403 days ago) |
| Rastrojo | 2008-02-19 (3404 days ago) |
| Cedric31 | 2008-02-19 (3404 days ago) |
| Prevert | 2008-02-16 (3406 days ago) |
| Aleator | 2008-02-15 (3407 days ago) |
| Zuirdj | 2008-02-15 (3407 days ago) |
| Orereta | 2008-02-15 (3408 days ago) |
| FrancoGG | 2008-02-11 (3411 days ago) |
| Loco085 | 2008-02-10 (3413 days ago) |
| Agüeybaná | 2008-02-10 (3413 days ago) |
| Mtmelendez | 2008-02-08 (3415 days ago) |
| TXiKi | 2008-02-08 (3415 days ago) |
| SCPS | 2008-02-07 (3415 days ago) |
| Toliño | 2008-02-07 (3415 days ago) |
| Theklan | 2008-02-07 (3416 days ago) |
| ReyBrujo | 2008-02-05 (3418 days ago) |
| Vilallonga | 2008-01-30 (3424 days ago) |
| Gaudio | 2008-01-25 (3429 days ago) |
| AlimanRuna | 2008-01-24 (3429 days ago) |
| Xtv | 2008-01-19 (3434 days ago) |
| Vriullop | 2008-01-18 (3435 days ago) |
| Desiphral | 2008-01-16 (3438 days ago) |
| DDarkfire | 2008-01-15 (3439 days ago) |
| Jove | 2008-01-08 (3446 days ago) |
| Pepelopex | 2008-01-07 (3446 days ago) |
| Esbardu | 2008-01-07 (3447 days ago) |
| Carles | 2007-12-30 (3454 days ago) |
| Celestianpower | 2007-12-30 (3455 days ago) |
| RRmeta | 2007-12-30 (3455 days ago) |
| Axxgreazz | 2007-12-23 (3462 days ago) |
| Sobreira | 2007-12-22 (3463 days ago) |
| Varano | 2007-12-18 (3466 days ago) |
| Chlewey | 2007-12-17 (3468 days ago) |
| Javierm | 2007-12-13 (3471 days ago) |
| Kipmaster | 2007-12-10 (3474 days ago) |
| Adalbertofrenesi | 2007-12-07 (3477 days ago) |
| JB82 | 2007-12-06 (3479 days ago) |
| Patstuart | 2007-12-04 (3481 days ago) |
| Subtiempo | 2007-11-30 (3484 days ago) |
| Jaranda | 2007-11-30 (3484 days ago) |
| Mac | 2007-11-29 (3486 days ago) |
| Lmbuga | 2007-11-28 (3486 days ago) |
| Janfri | 2007-11-28 (3486 days ago) |
| Banjo | 2007-11-24 (3490 days ago) |
| Malvenko | 2007-11-23 (3491 days ago) |
| Iradigalesc | 2007-11-23 (3491 days ago) |
| Llull | 2007-11-23 (3492 days ago) |
| Lohen11 | 2007-11-21 (3493 days ago) |
| Vibragiel | 2007-11-20 (3494 days ago) |
| Sanbec | 2007-11-20 (3494 days ago) |
| Yrithinnd | 2007-11-19 (3495 days ago) |
| Bdenk715 | 2007-11-14 (3501 days ago) |
| Marianocecowski | 2007-11-12 (3502 days ago) |
| Kuartas | 2007-11-10 (3504 days ago) |
| GlimmerPhoenix | 2007-11-09 (3505 days ago) |
| Fryant | 2007-11-08 (3506 days ago) |
| Edub | 2007-10-28 (3518 days ago) |
| Jynus | 2007-10-24 (3522 days ago) |
| Prietoquilmes | 2007-10-21 (3524 days ago) |
| Spangineer | 2007-10-14 (3531 days ago) |
| Pcongre | 2007-10-13 (3533 days ago) |
| Rodasmith | 2007-10-11 (3534 days ago) |
| JorgeGG | 2007-10-08 (3538 days ago) |
| Battroid | 2007-10-06 (3540 days ago) |
| Morza | 2007-09-30 (3546 days ago) |
| Albdallah | 2007-09-29 (3546 days ago) |
| Albeiror24 | 2007-09-29 (3547 days ago) |
100 rows in set (1 min 17.61 sec)
hi/Hindi[edit]
last update: 2008-03-28 (3366 days ago)
| Name | Last edit |
|---|---|
| Ashishbhatnagar | 2008-02-22 (3401 days ago) |
| Rajeevmass | 2008-02-07 (3416 days ago) |
| Eukesh | 2008-02-03 (3419 days ago) |
| Shyam | 2008-01-10 (3444 days ago) |
| Srikeit | 2007-12-06 (3478 days ago) |
| Sanjaybafnaji | 2007-07-26 (3612 days ago) |
| Mexxian | 2007-05-27 (3671 days ago) |
| Spundun | 2007-03-30 (3730 days ago) |
| Shreshth91 | 2007-02-16 (3772 days ago) |
| Jdas07 | 2006-09-12 (3928 days ago) |
| Dineshjk | 2005-08-05 (4331 days ago) |
| Abhishekbh | 2005-04-21 (4438 days ago) |
12 rows in set (43.28 sec)
ja/Japanese[edit]
last update: 2008-03-28 (3366 days ago)
| Name | Last edit |
|---|---|
| Tuinui | 2008-03-27 (3367 days ago) |
| Bookman | 2008-03-27 (3367 days ago) |
| Aphaia | 2008-03-27 (3367 days ago) |
| Kahusi | 2008-03-26 (3368 days ago) |
| Me2hero | 2008-03-26 (3368 days ago) |
| Genppy | 2008-03-26 (3368 days ago) |
| Kanjy | 2008-03-25 (3368 days ago) |
| Ninomy | 2008-03-25 (3369 days ago) |
| Kzhr | 2008-03-25 (3369 days ago) |
| LERK | 2008-03-25 (3369 days ago) |
| ZCU | 2008-03-24 (3370 days ago) |
| ゆいしあす | 2008-03-24 (3370 days ago) |
| Marine-Blue | 2008-03-22 (3372 days ago) |
| Courant | 2008-03-22 (3372 days ago) |
| Miya | 2008-03-20 (3374 days ago) |
| Mulukhiyya | 2008-03-12 (3382 days ago) |
| Mzm5zbC3 | 2008-03-11 (3383 days ago) |
| Bletilla | 2008-03-08 (3386 days ago) |
| Aotake | 2008-03-08 (3386 days ago) |
| Widehawk | 2008-03-04 (3390 days ago) |
| おはぐろ蜻蛉 | 2008-02-28 (3395 days ago) |
| ネッツ | 2008-02-27 (3395 days ago) |
| NJT | 2008-02-24 (3399 days ago) |
| 朝彦 | 2008-02-24 (3399 days ago) |
| Yassie | 2008-02-21 (3402 days ago) |
| 辞典の虫 | 2008-02-16 (3407 days ago) |
| Tommy6 | 2008-02-13 (3410 days ago) |
| Peccafly | 2008-02-10 (3413 days ago) |
| Uryah | 2008-02-10 (3413 days ago) |
| Kstigarbha | 2008-02-03 (3420 days ago) |
| Bukki | 2008-02-03 (3420 days ago) |
| Bellcricket | 2008-02-02 (3420 days ago) |
| Sylphie | 2008-02-01 (3422 days ago) |
| Pica | 2008-02-01 (3422 days ago) |
| Quatro | 2008-01-30 (3424 days ago) |
| Miya.m | 2008-01-29 (3425 days ago) |
| Londonbashi | 2008-01-28 (3426 days ago) |
| Kickaha | 2008-01-27 (3427 days ago) |
| Co.kyoto | 2008-01-27 (3427 days ago) |
| Hirokun | 2008-01-27 (3427 days ago) |
| Complex01 | 2008-01-27 (3427 days ago) |
| 千代林檎 | 2008-01-26 (3428 days ago) |
| Lonicera | 2008-01-25 (3428 days ago) |
| ZERBERUS | 2008-01-25 (3429 days ago) |
| Hyolee2 | 2008-01-25 (3429 days ago) |
| Tangotango | 2008-01-18 (3435 days ago) |
| Lemonsquash | 2008-01-16 (3437 days ago) |
| Knua | 2008-01-12 (3442 days ago) |
| Michey.M | 2008-01-05 (3449 days ago) |
| SS95 | 2007-12-27 (3457 days ago) |
| Suzuyoshinine | 2007-12-21 (3464 days ago) |
| Horlicks | 2007-12-21 (3464 days ago) |
| Volfgang | 2007-12-16 (3469 days ago) |
| Watermint | 2007-12-14 (3471 days ago) |
| Schu | 2007-12-14 (3471 days ago) |
| Tietew | 2007-12-10 (3475 days ago) |
| Dekimasu | 2007-12-04 (3481 days ago) |
| Swind | 2007-12-03 (3482 days ago) |
| Kareha | 2007-12-01 (3484 days ago) |
| Tamtarm | 2007-11-29 (3486 days ago) |
| Clarin | 2007-11-29 (3486 days ago) |
| Kasuga | 2007-11-28 (3486 days ago) |
| 11ChamOK | 2007-11-28 (3486 days ago) |
| Kurihaya | 2007-11-28 (3487 days ago) |
| Lusheeta | 2007-11-28 (3487 days ago) |
| Noraneko | 2007-11-28 (3487 days ago) |
| Kotodama-Reverse | 2007-11-26 (3488 days ago) |
| T-coco | 2007-11-26 (3488 days ago) |
| Numerike | 2007-11-26 (3488 days ago) |
| 霧木諒二 | 2007-11-26 (3489 days ago) |
| Takot | 2007-11-25 (3489 days ago) |
| Himetv | 2007-10-24 (3522 days ago) |
| Remington | 2007-10-20 (3526 days ago) |
| SantaClaus | 2007-09-25 (3550 days ago) |
| T.Saito | 2007-09-24 (3552 days ago) |
| Tiens | 2007-09-18 (3558 days ago) |
| Coryjp | 2007-09-05 (3571 days ago) |
| Muyo | 2007-09-03 (3572 days ago) |
| Ribbon | 2007-08-16 (3591 days ago) |
| Penpen | 2007-08-08 (3599 days ago) |
| PiaCarrot | 2007-08-04 (3603 days ago) |
| YouShow | 2007-07-27 (3610 days ago) |
| Chinneeb | 2007-07-03 (3635 days ago) |
| HALPHA | 2007-07-01 (3637 days ago) |
| Tonync | 2007-05-17 (3682 days ago) |
| Araisyohei | 2007-04-21 (3708 days ago) |
| 七星 | 2007-04-21 (3708 days ago) |
| LQVX | 2007-04-16 (3713 days ago) |
| Goncyan | 2007-04-05 (3724 days ago) |
| 端くれの錬金術師 | 2007-04-02 (3727 days ago) |
| Matsumomushi | 2007-03-25 (3735 days ago) |
| かんがへなし | 2007-03-17 (3743 days ago) |
| Rocky7 | 2007-03-16 (3743 days ago) |
| Lonchi** | 2007-03-09 (3751 days ago) |
| っ | 2007-02-17 (3771 days ago) |
| Kkkdc | 2007-02-16 (3772 days ago) |
| Diagraph01 | 2007-02-06 (3782 days ago) |
| Pachayachachic | 2007-02-03 (3785 days ago) |
| Adr6721 | 2007-02-01 (3787 days ago) |
| Su-no-G | 2007-02-01 (3787 days ago) |
100 rows in set (1 min 2.26 sec)
id/Bahasa Indonesian[edit]
last update: 2008-03-28 (3366 days ago)
| Name | Last edit |
|---|---|
| Azmi1995 | 2008-03-25 (3369 days ago) |
| IDRex | 2008-03-25 (3369 days ago) |
| IvanLanin | 2008-03-22 (3371 days ago) |
| Mimihitam | 2008-03-19 (3375 days ago) |
| Master2841 | 2008-03-08 (3385 days ago) |
| Chriswaterguy | 2008-03-07 (3387 days ago) |
| Borgx | 2008-03-04 (3390 days ago) |
| Kandar | 2008-02-18 (3405 days ago) |
| Meursault2004 | 2008-02-12 (3410 days ago) |
| Dragunova | 2008-02-08 (3415 days ago) |
| Hariadhi | 2007-08-03 (3604 days ago) |
| Irwangatot | 2007-06-12 (3655 days ago) |
| Anggoro | 2006-12-07 (3843 days ago) |
| Winana | 2006-11-22 (3857 days ago) |
| Anggreani | 2006-08-04 (3968 days ago) |
| HarisX | 2006-05-12 (4052 days ago) |
| Zaidpjd | 2005-11-20 (4224 days ago) |
| Widhiantoro | 2005-11-18 (4227 days ago) |
| Sudiryo | 2005-11-18 (4227 days ago) |
| *drew | 2005-11-08 (4237 days ago) |
20 rows in set (51.73 sec)
ro/Romanian[edit]
last update: 2008-03-28 (3366 days ago)
| Name | Last edit |
|---|---|
| SCriBu | 2008-02-24 (3398 days ago) |
| Cuman | 2008-01-25 (3429 days ago) |
| Desiphral | 2008-01-16 (3438 days ago) |
| IulianU | 2008-01-14 (3440 days ago) |
| AQUA | 2007-12-20 (3464 days ago) |
| Romihaitza | 2007-11-27 (3487 days ago) |
| BlueMonday | 2007-11-24 (3491 days ago) |
| Dorothea | 2007-11-19 (3496 days ago) |
| Bogdan | 2007-10-22 (3523 days ago) |
| Mocu | 2007-06-09 (3658 days ago) |
| Lorandka | 2007-01-05 (3813 days ago) |
| TSO1D | 2006-12-01 (3848 days ago) |
| Ronline | 2006-11-18 (3862 days ago) |
| Dmaftei | 2006-10-05 (3906 days ago) |
| Evosphere | 2006-07-14 (3989 days ago) |
| Orioane | 2006-06-29 (4004 days ago) |
| Victort | 2006-01-02 (4182 days ago) |
| NazismIsntCool | 2005-11-06 (4239 days ago) |
18 rows in set (55.09 sec)
sv/Swedish[edit]
last update: 2008-03-28 (3366 days ago)
| Name | Last edit |
|---|---|
| Micke | 2008-03-27 (3367 days ago) |
| Robertgreer | 2008-03-26 (3367 days ago) |
| M.M.S. | 2008-03-26 (3368 days ago) |
| Habj | 2008-03-25 (3369 days ago) |
| SvHannibal | 2008-03-24 (3369 days ago) |
| Moralist | 2008-03-24 (3369 days ago) |
| Boivie | 2008-03-14 (3380 days ago) |
| Mikez | 2008-03-04 (3390 days ago) |
| Riggwelter | 2008-02-16 (3407 days ago) |
| Malhonen | 2008-02-13 (3409 days ago) |
| LX | 2008-01-15 (3438 days ago) |
| Skomakarn | 2008-01-07 (3447 days ago) |
| Johngreen | 2007-12-04 (3480 days ago) |
| RaSten | 2007-10-21 (3525 days ago) |
| Pcongre | 2007-10-13 (3533 days ago) |
| Klibbnisse | 2007-08-27 (3580 days ago) |
| Edricson | 2007-08-09 (3598 days ago) |
| Smiddle | 2007-04-21 (3708 days ago) |
| Skagedal | 2007-04-01 (3727 days ago) |
| Yenx | 2007-01-08 (3811 days ago) |
| Kruosio | 2006-12-11 (3838 days ago) |
| NERIUM | 2006-06-29 (4004 days ago) |
| Jniemenmaa | 2006-06-12 (4021 days ago) |
| Marsve | 2006-05-05 (4058 days ago) |
| Aktalo | 2006-01-23 (4161 days ago) |
| Diyako | 2006-01-17 (4167 days ago) |
| Storpilot | 2005-12-12 (4203 days ago) |
| Scoo | 2005-12-08 (4207 days ago) |
| Qwm | 2005-11-16 (4229 days ago) |
| ShineB | 2005-09-29 (4277 days ago) |
| Tehvata | 2005-07-01 (4366 days ago) |
31 rows in set (3 min 51.74 sec)
uk/Ukrainian[edit]
last update: 2008-03-28 (3366 days ago)
| Name | Last edit |
|---|---|
| Ahonc | 2008-03-25 (3368 days ago) |
| Riwnodennyk | 2008-03-25 (3368 days ago) |
| A1 | 2008-02-11 (3411 days ago) |
| Ilyaroz | 2008-01-27 (3427 days ago) |
| Movses | 2008-01-23 (3431 days ago) |
| Yakudza | 2007-11-20 (3495 days ago) |
| Minia | 2007-11-18 (3496 days ago) |
| EvgenyGenkin | 2007-11-13 (3501 days ago) |
| DmRodionov | 2007-08-25 (3581 days ago) |
| Mikolasz | 2007-07-14 (3623 days ago) |
| Hayk | 2007-07-07 (3630 days ago) |
| Panas | 2007-07-01 (3637 days ago) |
| Yms | 2007-04-09 (3719 days ago) |
| Nevermind | 2006-12-18 (3832 days ago) |
| Angryxpeh | 2006-12-14 (3835 days ago) |
| AndriyK | 2006-11-24 (3855 days ago) |
| Martynenka | 2006-11-08 (3871 days ago) |
| Redsunrising | 2006-11-04 (3876 days ago) |
| Ornil | 2006-11-03 (3876 days ago) |
| Jan-ivan | 2005-11-14 (4230 days ago) |
| Inetd | 2005-03-26 (4463 days ago) |
21 rows in set (1 min 55.31 sec)
vi/Vietnamese[edit]
last update: 2008-03-28 (3366 days ago)
| Name | Last edit |
|---|---|
| Vinhtantran | 2008-03-27 (3367 days ago) |
| Neoneurone | 2007-11-15 (3500 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
}}
|
