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 (3691 days ago)
| Name | Last edit |
|---|---|
| Spiritia | 2008-03-20 (3698 days ago) |
| Timurberk | 2008-02-04 (3743 days ago) |
| Daggerstab | 2008-01-19 (3759 days ago) |
| 5ko | 2008-01-01 (3777 days ago) |
| Azimski | 2007-09-19 (3881 days ago) |
| Nk | 2007-06-28 (3964 days ago) |
| Vanka5 | 2007-05-25 (3999 days ago) |
| Sharkb | 2007-01-21 (4122 days ago) |
| Bggoldie | 2006-12-19 (4156 days ago) |
| DCLXVI | 2006-08-06 (4290 days ago) |
| Smartech | 2006-04-14 (4404 days ago) |
| Glimz | 2006-04-02 (4416 days ago) |
| Espetkov | 2005-06-05 (4717 days ago) |
13 rows in set (56.82 sec)
bn/Bengali[edit]
last update: 2008-03-28 (3691 days ago)
| Name | Last edit |
|---|---|
| Bellayet | 2008-03-26 (3692 days ago) |
| Aeetlrsk | 2008-02-04 (3743 days ago) |
| Frdayeen | 2008-01-08 (3770 days ago) |
| Hermitage17 | 2008-01-08 (3771 days ago) |
4 rows in set (9.26 sec)
fi/Finnish[edit]
last update: 2008-03-28 (3691 days ago)
| Name | Last edit |
|---|---|
| AtteL | 2008-03-25 (3693 days ago) |
| Str4nd | 2008-03-24 (3694 days ago) |
| Roosa | 2008-03-05 (3714 days ago) |
| Malhonen | 2008-02-13 (3734 days ago) |
| Ilaiho | 2007-12-25 (3784 days ago) |
| Argus | 2007-11-12 (3827 days ago) |
| Jariola | 2007-10-29 (3841 days ago) |
| Kyzyl | 2007-07-16 (3947 days ago) |
| Skuolfi | 2007-05-13 (4010 days ago) |
| Urvabara | 2007-02-08 (4104 days ago) |
| Jni | 2007-01-29 (4114 days ago) |
| NZ- | 2006-12-30 (4144 days ago) |
| Vilu | 2006-12-26 (4148 days ago) |
| Hartz | 2006-12-15 (4159 days ago) |
| Mzlla | 2006-12-07 (4167 days ago) |
| Inzulac | 2006-10-31 (4204 days ago) |
| Lauranen | 2006-10-02 (4233 days ago) |
| Totuus | 2006-09-05 (4260 days ago) |
| Anchjo | 2006-08-31 (4265 days ago) |
| Pwc | 2006-08-05 (4291 days ago) |
| Kouluhai | 2006-06-23 (4334 days ago) |
| Jniemenmaa | 2006-06-12 (4345 days ago) |
| Bobet | 2006-02-06 (4471 days ago) |
| Finlandia | 2005-12-28 (4511 days ago) |
| Hapsiainen | 2005-12-09 (4530 days ago) |
| Viznut | 2005-07-27 (4666 days ago) |
| Lanahard | 2005-07-21 (4671 days ago) |
| Rdnk | 2005-05-24 (4729 days ago) |
31 rows in set (55.17 sec)
es/Spanish[edit]
last update: 2008-03-28 (3691 days ago)
| Name | Last edit |
|---|---|
| Spacebirdy | 2008-03-27 (3691 days ago) |
| Bengoa | 2008-03-27 (3691 days ago) |
| Kylu | 2008-03-27 (3692 days ago) |
| Julie | 2008-03-26 (3692 days ago) |
| Taichi | 2008-03-26 (3692 days ago) |
| Ascánder | 2008-03-26 (3692 days ago) |
| Smeira | 2008-03-26 (3692 days ago) |
| SMP | 2008-03-26 (3692 days ago) |
| Drini | 2008-03-26 (3692 days ago) |
| Rdsmith4 | 2008-03-25 (3693 days ago) |
| Masterches | 2008-03-25 (3694 days ago) |
| Wikimistusik | 2008-03-25 (3694 days ago) |
| Mikel | 2008-03-25 (3694 days ago) |
| Willtron | 2008-03-24 (3694 days ago) |
| CHV | 2008-03-24 (3694 days ago) |
| Tosão | 2008-03-23 (3695 days ago) |
| Redux | 2008-03-21 (3697 days ago) |
| Xic667 | 2008-03-21 (3697 days ago) |
| LaosLos | 2008-03-20 (3698 days ago) |
| BetoCG | 2008-03-17 (3701 days ago) |
| DamianFinol | 2008-03-16 (3703 days ago) |
| Jurock | 2008-03-13 (3705 days ago) |
| Oswaldo2025 | 2008-03-13 (3706 days ago) |
| Damërung | 2008-03-08 (3710 days ago) |
| Alhen | 2008-03-06 (3712 days ago) |
| Fajro | 2008-03-04 (3715 days ago) |
| LadyInGrey | 2008-03-03 (3715 days ago) |
| Barcex | 2008-03-02 (3716 days ago) |
| Alpertron | 2008-02-29 (3718 days ago) |
| Cromwellt | 2008-02-29 (3719 days ago) |
| RedCoat | 2008-02-28 (3719 days ago) |
| Sapey | 2008-02-20 (3727 days ago) |
| Elisardojm | 2008-02-20 (3727 days ago) |
| Lascorz | 2008-02-19 (3728 days ago) |
| Rastrojo | 2008-02-19 (3728 days ago) |
| Cedric31 | 2008-02-19 (3728 days ago) |
| Prevert | 2008-02-16 (3731 days ago) |
| Aleator | 2008-02-15 (3732 days ago) |
| Zuirdj | 2008-02-15 (3732 days ago) |
| Orereta | 2008-02-15 (3732 days ago) |
| FrancoGG | 2008-02-11 (3736 days ago) |
| Loco085 | 2008-02-10 (3737 days ago) |
| Agüeybaná | 2008-02-10 (3737 days ago) |
| Mtmelendez | 2008-02-08 (3739 days ago) |
| TXiKi | 2008-02-08 (3740 days ago) |
| SCPS | 2008-02-07 (3740 days ago) |
| Toliño | 2008-02-07 (3740 days ago) |
| Theklan | 2008-02-07 (3740 days ago) |
| ReyBrujo | 2008-02-05 (3743 days ago) |
| Vilallonga | 2008-01-30 (3748 days ago) |
| Gaudio | 2008-01-25 (3753 days ago) |
| AlimanRuna | 2008-01-24 (3754 days ago) |
| Xtv | 2008-01-19 (3759 days ago) |
| Vriullop | 2008-01-18 (3760 days ago) |
| Desiphral | 2008-01-16 (3762 days ago) |
| DDarkfire | 2008-01-15 (3764 days ago) |
| Jove | 2008-01-08 (3771 days ago) |
| Pepelopex | 2008-01-07 (3771 days ago) |
| Esbardu | 2008-01-07 (3772 days ago) |
| Carles | 2007-12-30 (3779 days ago) |
| Celestianpower | 2007-12-30 (3779 days ago) |
| RRmeta | 2007-12-30 (3780 days ago) |
| Axxgreazz | 2007-12-23 (3787 days ago) |
| Sobreira | 2007-12-22 (3787 days ago) |
| Varano | 2007-12-18 (3791 days ago) |
| Chlewey | 2007-12-17 (3792 days ago) |
| Javierm | 2007-12-13 (3796 days ago) |
| Kipmaster | 2007-12-10 (3799 days ago) |
| Adalbertofrenesi | 2007-12-07 (3802 days ago) |
| JB82 | 2007-12-06 (3804 days ago) |
| Patstuart | 2007-12-04 (3806 days ago) |
| Subtiempo | 2007-11-30 (3809 days ago) |
| Jaranda | 2007-11-30 (3809 days ago) |
| Mac | 2007-11-29 (3810 days ago) |
| Lmbuga | 2007-11-28 (3811 days ago) |
| Janfri | 2007-11-28 (3811 days ago) |
| Banjo | 2007-11-24 (3815 days ago) |
| Malvenko | 2007-11-23 (3816 days ago) |
| Iradigalesc | 2007-11-23 (3816 days ago) |
| Llull | 2007-11-23 (3816 days ago) |
| Lohen11 | 2007-11-21 (3818 days ago) |
| Vibragiel | 2007-11-20 (3819 days ago) |
| Sanbec | 2007-11-20 (3819 days ago) |
| Yrithinnd | 2007-11-19 (3820 days ago) |
| Bdenk715 | 2007-11-14 (3826 days ago) |
| Marianocecowski | 2007-11-12 (3827 days ago) |
| Kuartas | 2007-11-10 (3829 days ago) |
| GlimmerPhoenix | 2007-11-09 (3830 days ago) |
| Fryant | 2007-11-08 (3831 days ago) |
| Edub | 2007-10-28 (3842 days ago) |
| Jynus | 2007-10-24 (3846 days ago) |
| Prietoquilmes | 2007-10-21 (3849 days ago) |
| Spangineer | 2007-10-14 (3856 days ago) |
| Pcongre | 2007-10-13 (3858 days ago) |
| Rodasmith | 2007-10-11 (3859 days ago) |
| JorgeGG | 2007-10-08 (3862 days ago) |
| Battroid | 2007-10-06 (3865 days ago) |
| Morza | 2007-09-30 (3870 days ago) |
| Albdallah | 2007-09-29 (3871 days ago) |
| Albeiror24 | 2007-09-29 (3872 days ago) |
100 rows in set (1 min 17.61 sec)
hi/Hindi[edit]
last update: 2008-03-28 (3691 days ago)
| Name | Last edit |
|---|---|
| Ashishbhatnagar | 2008-02-22 (3726 days ago) |
| Rajeevmass | 2008-02-07 (3740 days ago) |
| Eukesh | 2008-02-03 (3744 days ago) |
| Shyam | 2008-01-10 (3769 days ago) |
| Srikeit | 2007-12-06 (3803 days ago) |
| Sanjaybafnaji | 2007-07-26 (3936 days ago) |
| Mexxian | 2007-05-27 (3996 days ago) |
| Spundun | 2007-03-30 (4054 days ago) |
| Shreshth91 | 2007-02-16 (4097 days ago) |
| Jdas07 | 2006-09-12 (4253 days ago) |
| Dineshjk | 2005-08-05 (4656 days ago) |
| Abhishekbh | 2005-04-21 (4763 days ago) |
12 rows in set (43.28 sec)
ja/Japanese[edit]
last update: 2008-03-28 (3691 days ago)
| Name | Last edit |
|---|---|
| Tuinui | 2008-03-27 (3692 days ago) |
| Bookman | 2008-03-27 (3692 days ago) |
| Aphaia | 2008-03-27 (3692 days ago) |
| Kahusi | 2008-03-26 (3692 days ago) |
| Me2hero | 2008-03-26 (3692 days ago) |
| Genppy | 2008-03-26 (3693 days ago) |
| Kanjy | 2008-03-25 (3693 days ago) |
| Ninomy | 2008-03-25 (3693 days ago) |
| Kzhr | 2008-03-25 (3693 days ago) |
| LERK | 2008-03-25 (3693 days ago) |
| ZCU | 2008-03-24 (3694 days ago) |
| ゆいしあす | 2008-03-24 (3694 days ago) |
| Marine-Blue | 2008-03-22 (3697 days ago) |
| Courant | 2008-03-22 (3697 days ago) |
| Miya | 2008-03-20 (3699 days ago) |
| Mulukhiyya | 2008-03-12 (3706 days ago) |
| Mzm5zbC3 | 2008-03-11 (3707 days ago) |
| Bletilla | 2008-03-08 (3710 days ago) |
| Aotake | 2008-03-08 (3711 days ago) |
| Widehawk | 2008-03-04 (3715 days ago) |
| おはぐろ蜻蛉 | 2008-02-28 (3719 days ago) |
| ネッツ | 2008-02-27 (3720 days ago) |
| NJT | 2008-02-24 (3724 days ago) |
| 朝彦 | 2008-02-24 (3724 days ago) |
| Yassie | 2008-02-21 (3726 days ago) |
| 辞典の虫 | 2008-02-16 (3732 days ago) |
| Tommy6 | 2008-02-13 (3735 days ago) |
| Peccafly | 2008-02-10 (3737 days ago) |
| Uryah | 2008-02-10 (3738 days ago) |
| Kstigarbha | 2008-02-03 (3744 days ago) |
| Bukki | 2008-02-03 (3745 days ago) |
| Bellcricket | 2008-02-02 (3745 days ago) |
| Sylphie | 2008-02-01 (3746 days ago) |
| Pica | 2008-02-01 (3747 days ago) |
| Quatro | 2008-01-30 (3748 days ago) |
| Miya.m | 2008-01-29 (3749 days ago) |
| Londonbashi | 2008-01-28 (3750 days ago) |
| Kickaha | 2008-01-27 (3751 days ago) |
| Co.kyoto | 2008-01-27 (3751 days ago) |
| Hirokun | 2008-01-27 (3751 days ago) |
| Complex01 | 2008-01-27 (3752 days ago) |
| 千代林檎 | 2008-01-26 (3753 days ago) |
| Lonicera | 2008-01-25 (3753 days ago) |
| ZERBERUS | 2008-01-25 (3753 days ago) |
| Hyolee2 | 2008-01-25 (3754 days ago) |
| Tangotango | 2008-01-18 (3760 days ago) |
| Lemonsquash | 2008-01-16 (3762 days ago) |
| Knua | 2008-01-12 (3766 days ago) |
| Michey.M | 2008-01-05 (3773 days ago) |
| SS95 | 2007-12-27 (3782 days ago) |
| Suzuyoshinine | 2007-12-21 (3788 days ago) |
| Horlicks | 2007-12-21 (3789 days ago) |
| Volfgang | 2007-12-16 (3793 days ago) |
| Watermint | 2007-12-14 (3795 days ago) |
| Schu | 2007-12-14 (3796 days ago) |
| Tietew | 2007-12-10 (3800 days ago) |
| Dekimasu | 2007-12-04 (3806 days ago) |
| Swind | 2007-12-03 (3807 days ago) |
| Kareha | 2007-12-01 (3808 days ago) |
| Tamtarm | 2007-11-29 (3810 days ago) |
| Clarin | 2007-11-29 (3811 days ago) |
| Kasuga | 2007-11-28 (3811 days ago) |
| 11ChamOK | 2007-11-28 (3811 days ago) |
| Kurihaya | 2007-11-28 (3811 days ago) |
| Lusheeta | 2007-11-28 (3811 days ago) |
| Noraneko | 2007-11-28 (3812 days ago) |
| Kotodama-Reverse | 2007-11-26 (3813 days ago) |
| T-coco | 2007-11-26 (3813 days ago) |
| Numerike | 2007-11-26 (3813 days ago) |
| 霧木諒二 | 2007-11-26 (3813 days ago) |
| Takot | 2007-11-25 (3814 days ago) |
| Himetv | 2007-10-24 (3847 days ago) |
| Remington | 2007-10-20 (3850 days ago) |
| SantaClaus | 2007-09-25 (3875 days ago) |
| T.Saito | 2007-09-24 (3876 days ago) |
| Tiens | 2007-09-18 (3883 days ago) |
| Coryjp | 2007-09-05 (3895 days ago) |
| Muyo | 2007-09-03 (3897 days ago) |
| Ribbon | 2007-08-16 (3916 days ago) |
| Penpen | 2007-08-08 (3924 days ago) |
| PiaCarrot | 2007-08-04 (3927 days ago) |
| YouShow | 2007-07-27 (3935 days ago) |
| Chinneeb | 2007-07-03 (3960 days ago) |
| HALPHA | 2007-07-01 (3961 days ago) |
| Tonync | 2007-05-17 (4006 days ago) |
| Araisyohei | 2007-04-21 (4032 days ago) |
| 七星 | 2007-04-21 (4033 days ago) |
| LQVX | 2007-04-16 (4038 days ago) |
| Goncyan | 2007-04-05 (4049 days ago) |
| 端くれの錬金術師 | 2007-04-02 (4051 days ago) |
| Matsumomushi | 2007-03-25 (4060 days ago) |
| かんがへなし | 2007-03-17 (4068 days ago) |
| Rocky7 | 2007-03-16 (4068 days ago) |
| Lonchi** | 2007-03-09 (4076 days ago) |
| っ | 2007-02-17 (4095 days ago) |
| Kkkdc | 2007-02-16 (4096 days ago) |
| Diagraph01 | 2007-02-06 (4106 days ago) |
| Pachayachachic | 2007-02-03 (4110 days ago) |
| Adr6721 | 2007-02-01 (4112 days ago) |
| Su-no-G | 2007-02-01 (4112 days ago) |
100 rows in set (1 min 2.26 sec)
id/Bahasa Indonesian[edit]
last update: 2008-03-28 (3691 days ago)
| Name | Last edit |
|---|---|
| Azmi1995 | 2008-03-25 (3694 days ago) |
| IDRex | 2008-03-25 (3694 days ago) |
| IvanLanin | 2008-03-22 (3696 days ago) |
| Mimihitam | 2008-03-19 (3699 days ago) |
| Master2841 | 2008-03-08 (3710 days ago) |
| Chriswaterguy | 2008-03-07 (3712 days ago) |
| Borgx | 2008-03-04 (3715 days ago) |
| Kandar | 2008-02-18 (3729 days ago) |
| Meursault2004 | 2008-02-12 (3735 days ago) |
| Dragunova | 2008-02-08 (3740 days ago) |
| Hariadhi | 2007-08-03 (3929 days ago) |
| Irwangatot | 2007-06-12 (3980 days ago) |
| Anggoro | 2006-12-07 (4168 days ago) |
| Winana | 2006-11-22 (4182 days ago) |
| Anggreani | 2006-08-04 (4293 days ago) |
| HarisX | 2006-05-12 (4377 days ago) |
| Zaidpjd | 2005-11-20 (4549 days ago) |
| Widhiantoro | 2005-11-18 (4552 days ago) |
| Sudiryo | 2005-11-18 (4552 days ago) |
| *drew | 2005-11-08 (4562 days ago) |
20 rows in set (51.73 sec)
ro/Romanian[edit]
last update: 2008-03-28 (3691 days ago)
| Name | Last edit |
|---|---|
| SCriBu | 2008-02-24 (3723 days ago) |
| Cuman | 2008-01-25 (3753 days ago) |
| Desiphral | 2008-01-16 (3762 days ago) |
| IulianU | 2008-01-14 (3764 days ago) |
| AQUA | 2007-12-20 (3789 days ago) |
| Romihaitza | 2007-11-27 (3812 days ago) |
| BlueMonday | 2007-11-24 (3815 days ago) |
| Dorothea | 2007-11-19 (3820 days ago) |
| Bogdan | 2007-10-22 (3848 days ago) |
| Mocu | 2007-06-09 (3983 days ago) |
| Lorandka | 2007-01-05 (4138 days ago) |
| TSO1D | 2006-12-01 (4173 days ago) |
| Ronline | 2006-11-18 (4187 days ago) |
| Dmaftei | 2006-10-05 (4231 days ago) |
| Evosphere | 2006-07-14 (4313 days ago) |
| Orioane | 2006-06-29 (4328 days ago) |
| Victort | 2006-01-02 (4507 days ago) |
| NazismIsntCool | 2005-11-06 (4564 days ago) |
18 rows in set (55.09 sec)
sv/Swedish[edit]
last update: 2008-03-28 (3691 days ago)
| Name | Last edit |
|---|---|
| Micke | 2008-03-27 (3691 days ago) |
| Robertgreer | 2008-03-26 (3692 days ago) |
| M.M.S. | 2008-03-26 (3692 days ago) |
| Habj | 2008-03-25 (3693 days ago) |
| SvHannibal | 2008-03-24 (3694 days ago) |
| Moralist | 2008-03-24 (3694 days ago) |
| Boivie | 2008-03-14 (3704 days ago) |
| Mikez | 2008-03-04 (3715 days ago) |
| Riggwelter | 2008-02-16 (3731 days ago) |
| Malhonen | 2008-02-13 (3734 days ago) |
| LX | 2008-01-15 (3763 days ago) |
| Skomakarn | 2008-01-07 (3772 days ago) |
| Johngreen | 2007-12-04 (3805 days ago) |
| RaSten | 2007-10-21 (3849 days ago) |
| Pcongre | 2007-10-13 (3858 days ago) |
| Klibbnisse | 2007-08-27 (3904 days ago) |
| Edricson | 2007-08-09 (3922 days ago) |
| Smiddle | 2007-04-21 (4032 days ago) |
| Skagedal | 2007-04-01 (4052 days ago) |
| Yenx | 2007-01-08 (4135 days ago) |
| Kruosio | 2006-12-11 (4163 days ago) |
| NERIUM | 2006-06-29 (4329 days ago) |
| Jniemenmaa | 2006-06-12 (4345 days ago) |
| Marsve | 2006-05-05 (4383 days ago) |
| Aktalo | 2006-01-23 (4485 days ago) |
| Diyako | 2006-01-17 (4492 days ago) |
| Storpilot | 2005-12-12 (4527 days ago) |
| Scoo | 2005-12-08 (4531 days ago) |
| Qwm | 2005-11-16 (4554 days ago) |
| ShineB | 2005-09-29 (4601 days ago) |
| Tehvata | 2005-07-01 (4691 days ago) |
31 rows in set (3 min 51.74 sec)
uk/Ukrainian[edit]
last update: 2008-03-28 (3691 days ago)
| Name | Last edit |
|---|---|
| Ahonc | 2008-03-25 (3693 days ago) |
| Riwnodennyk | 2008-03-25 (3693 days ago) |
| A1 | 2008-02-11 (3736 days ago) |
| Ilyaroz | 2008-01-27 (3752 days ago) |
| Movses | 2008-01-23 (3755 days ago) |
| Yakudza | 2007-11-20 (3819 days ago) |
| Minia | 2007-11-18 (3821 days ago) |
| EvgenyGenkin | 2007-11-13 (3826 days ago) |
| DmRodionov | 2007-08-25 (3906 days ago) |
| Mikolasz | 2007-07-14 (3948 days ago) |
| Hayk | 2007-07-07 (3955 days ago) |
| Panas | 2007-07-01 (3961 days ago) |
| Yms | 2007-04-09 (4044 days ago) |
| Nevermind | 2006-12-18 (4156 days ago) |
| Angryxpeh | 2006-12-14 (4160 days ago) |
| AndriyK | 2006-11-24 (4180 days ago) |
| Martynenka | 2006-11-08 (4196 days ago) |
| Redsunrising | 2006-11-04 (4200 days ago) |
| Ornil | 2006-11-03 (4201 days ago) |
| Jan-ivan | 2005-11-14 (4555 days ago) |
| Inetd | 2005-03-26 (4788 days ago) |
21 rows in set (1 min 55.31 sec)
vi/Vietnamese[edit]
last update: 2008-03-28 (3691 days ago)
| Name | Last edit |
|---|---|
| Vinhtantran | 2008-03-27 (3692 days ago) |
| Neoneurone | 2007-11-15 (3825 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
}}
|
