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 (5856 days ago)
Name | Last edit |
---|---|
Spiritia | 2008-03-20 (5863 days ago) |
Timurberk | 2008-02-04 (5908 days ago) |
Daggerstab | 2008-01-19 (5924 days ago) |
5ko | 2008-01-01 (5942 days ago) |
Azimski | 2007-09-19 (6046 days ago) |
Nk | 2007-06-28 (6129 days ago) |
Vanka5 | 2007-05-25 (6163 days ago) |
Sharkb | 2007-01-21 (6287 days ago) |
Bggoldie | 2006-12-19 (6320 days ago) |
DCLXVI | 2006-08-06 (6455 days ago) |
Smartech | 2006-04-14 (6569 days ago) |
Glimz | 2006-04-02 (6581 days ago) |
Espetkov | 2005-06-05 (6882 days ago) |
13 rows in set (56.82 sec)
bn/Bengali[edit]
last update: 2008-03-28 (5856 days ago)
Name | Last edit |
---|---|
Bellayet | 2008-03-26 (5857 days ago) |
Aeetlrsk | 2008-02-04 (5908 days ago) |
Frdayeen | 2008-01-08 (5935 days ago) |
Hermitage17 | 2008-01-08 (5935 days ago) |
4 rows in set (9.26 sec)
fi/Finnish[edit]
last update: 2008-03-28 (5856 days ago)
Name | Last edit |
---|---|
AtteL | 2008-03-25 (5858 days ago) |
Str4nd | 2008-03-24 (5859 days ago) |
Roosa | 2008-03-05 (5879 days ago) |
Malhonen | 2008-02-13 (5899 days ago) |
Ilaiho | 2007-12-25 (5949 days ago) |
Argus | 2007-11-12 (5992 days ago) |
Jariola | 2007-10-29 (6006 days ago) |
Kyzyl | 2007-07-16 (6111 days ago) |
Skuolfi | 2007-05-13 (6175 days ago) |
Urvabara | 2007-02-08 (6269 days ago) |
Jni | 2007-01-29 (6279 days ago) |
NZ- | 2006-12-30 (6309 days ago) |
Vilu | 2006-12-26 (6313 days ago) |
Hartz | 2006-12-15 (6324 days ago) |
Mzlla | 2006-12-07 (6332 days ago) |
Inzulac | 2006-10-31 (6369 days ago) |
Lauranen | 2006-10-02 (6398 days ago) |
Totuus | 2006-09-05 (6425 days ago) |
Anchjo | 2006-08-31 (6430 days ago) |
Pwc | 2006-08-05 (6456 days ago) |
Kouluhai | 2006-06-23 (6499 days ago) |
Jniemenmaa | 2006-06-12 (6510 days ago) |
Bobet | 2006-02-06 (6636 days ago) |
Finlandia | 2005-12-28 (6676 days ago) |
Hapsiainen | 2005-12-09 (6695 days ago) |
Viznut | 2005-07-27 (6830 days ago) |
Lanahard | 2005-07-21 (6836 days ago) |
Rdnk | 2005-05-24 (6894 days ago) |
31 rows in set (55.17 sec)
es/Spanish[edit]
last update: 2008-03-28 (5856 days ago)
Name | Last edit |
---|---|
Spacebirdy | 2008-03-27 (5856 days ago) |
Bengoa | 2008-03-27 (5856 days ago) |
Kylu | 2008-03-27 (5857 days ago) |
Julie | 2008-03-26 (5857 days ago) |
Taichi | 2008-03-26 (5857 days ago) |
Ascánder | 2008-03-26 (5857 days ago) |
Smeira | 2008-03-26 (5857 days ago) |
SMP | 2008-03-26 (5857 days ago) |
Drini | 2008-03-26 (5857 days ago) |
Rdsmith4 | 2008-03-25 (5858 days ago) |
Masterches | 2008-03-25 (5858 days ago) |
Wikimistusik | 2008-03-25 (5858 days ago) |
Mikel | 2008-03-25 (5859 days ago) |
Willtron | 2008-03-24 (5859 days ago) |
CHV | 2008-03-24 (5859 days ago) |
Tosão | 2008-03-23 (5860 days ago) |
Redux | 2008-03-21 (5862 days ago) |
Xic667 | 2008-03-21 (5862 days ago) |
LaosLos | 2008-03-20 (5863 days ago) |
BetoCG | 2008-03-17 (5866 days ago) |
DamianFinol | 2008-03-16 (5867 days ago) |
Jurock | 2008-03-13 (5870 days ago) |
Oswaldo2025 | 2008-03-13 (5871 days ago) |
Damërung | 2008-03-08 (5875 days ago) |
Alhen | 2008-03-06 (5877 days ago) |
Fajro | 2008-03-04 (5879 days ago) |
LadyInGrey | 2008-03-03 (5880 days ago) |
Barcex | 2008-03-02 (5881 days ago) |
Alpertron | 2008-02-29 (5883 days ago) |
Cromwellt | 2008-02-29 (5884 days ago) |
RedCoat | 2008-02-28 (5884 days ago) |
Sapey | 2008-02-20 (5892 days ago) |
Elisardojm | 2008-02-20 (5892 days ago) |
Lascorz | 2008-02-19 (5893 days ago) |
Rastrojo | 2008-02-19 (5893 days ago) |
Cedric31 | 2008-02-19 (5893 days ago) |
Prevert | 2008-02-16 (5896 days ago) |
Aleator | 2008-02-15 (5897 days ago) |
Zuirdj | 2008-02-15 (5897 days ago) |
Orereta | 2008-02-15 (5897 days ago) |
FrancoGG | 2008-02-11 (5901 days ago) |
Loco085 | 2008-02-10 (5902 days ago) |
Agüeybaná | 2008-02-10 (5902 days ago) |
Mtmelendez | 2008-02-08 (5904 days ago) |
TXiKi | 2008-02-08 (5904 days ago) |
SCPS | 2008-02-07 (5905 days ago) |
Toliño | 2008-02-07 (5905 days ago) |
Theklan | 2008-02-07 (5905 days ago) |
ReyBrujo | 2008-02-05 (5907 days ago) |
Vilallonga | 2008-01-30 (5913 days ago) |
Gaudio | 2008-01-25 (5918 days ago) |
AlimanRuna | 2008-01-24 (5919 days ago) |
Xtv | 2008-01-19 (5924 days ago) |
Vriullop | 2008-01-18 (5925 days ago) |
Desiphral | 2008-01-16 (5927 days ago) |
DDarkfire | 2008-01-15 (5929 days ago) |
Jove | 2008-01-08 (5936 days ago) |
Pepelopex | 2008-01-07 (5936 days ago) |
Esbardu | 2008-01-07 (5937 days ago) |
Carles | 2007-12-30 (5944 days ago) |
Celestianpower | 2007-12-30 (5944 days ago) |
RRmeta | 2007-12-30 (5945 days ago) |
Axxgreazz | 2007-12-23 (5952 days ago) |
Sobreira | 2007-12-22 (5952 days ago) |
Varano | 2007-12-18 (5956 days ago) |
Chlewey | 2007-12-17 (5957 days ago) |
Javierm | 2007-12-13 (5961 days ago) |
Kipmaster | 2007-12-10 (5964 days ago) |
Adalbertofrenesi | 2007-12-07 (5967 days ago) |
JB82 | 2007-12-06 (5969 days ago) |
Patstuart | 2007-12-04 (5970 days ago) |
Subtiempo | 2007-11-30 (5974 days ago) |
Jaranda | 2007-11-30 (5974 days ago) |
Mac | 2007-11-29 (5975 days ago) |
Lmbuga | 2007-11-28 (5976 days ago) |
Janfri | 2007-11-28 (5976 days ago) |
Banjo | 2007-11-24 (5980 days ago) |
Malvenko | 2007-11-23 (5981 days ago) |
Iradigalesc | 2007-11-23 (5981 days ago) |
Llull | 2007-11-23 (5981 days ago) |
Lohen11 | 2007-11-21 (5983 days ago) |
Vibragiel | 2007-11-20 (5984 days ago) |
Sanbec | 2007-11-20 (5984 days ago) |
Yrithinnd | 2007-11-19 (5985 days ago) |
Bdenk715 | 2007-11-14 (5990 days ago) |
Marianocecowski | 2007-11-12 (5992 days ago) |
Kuartas | 2007-11-10 (5994 days ago) |
GlimmerPhoenix | 2007-11-09 (5995 days ago) |
Fryant | 2007-11-08 (5996 days ago) |
Edub | 2007-10-28 (6007 days ago) |
Jynus | 2007-10-24 (6011 days ago) |
Prietoquilmes | 2007-10-21 (6014 days ago) |
Spangineer | 2007-10-14 (6021 days ago) |
Pcongre | 2007-10-13 (6022 days ago) |
Rodasmith | 2007-10-11 (6024 days ago) |
JorgeGG | 2007-10-08 (6027 days ago) |
Battroid | 2007-10-06 (6030 days ago) |
Morza | 2007-09-30 (6035 days ago) |
Albdallah | 2007-09-29 (6036 days ago) |
Albeiror24 | 2007-09-29 (6036 days ago) |
100 rows in set (1 min 17.61 sec)
hi/Hindi[edit]
last update: 2008-03-28 (5856 days ago)
Name | Last edit |
---|---|
Ashishbhatnagar | 2008-02-22 (5890 days ago) |
Rajeevmass | 2008-02-07 (5905 days ago) |
Eukesh | 2008-02-03 (5909 days ago) |
Shyam | 2008-01-10 (5933 days ago) |
Srikeit | 2007-12-06 (5968 days ago) |
Sanjaybafnaji | 2007-07-26 (6101 days ago) |
Mexxian | 2007-05-27 (6161 days ago) |
Spundun | 2007-03-30 (6219 days ago) |
Shreshth91 | 2007-02-16 (6261 days ago) |
Jdas07 | 2006-09-12 (6418 days ago) |
Dineshjk | 2005-08-05 (6821 days ago) |
Abhishekbh | 2005-04-21 (6927 days ago) |
12 rows in set (43.28 sec)
ja/Japanese[edit]
last update: 2008-03-28 (5856 days ago)
Name | Last edit |
---|---|
Tuinui | 2008-03-27 (5856 days ago) |
Bookman | 2008-03-27 (5856 days ago) |
Aphaia | 2008-03-27 (5857 days ago) |
Kahusi | 2008-03-26 (5857 days ago) |
Me2hero | 2008-03-26 (5857 days ago) |
Genppy | 2008-03-26 (5858 days ago) |
Kanjy | 2008-03-25 (5858 days ago) |
Ninomy | 2008-03-25 (5858 days ago) |
Kzhr | 2008-03-25 (5858 days ago) |
LERK | 2008-03-25 (5858 days ago) |
ZCU | 2008-03-24 (5859 days ago) |
ゆいしあす | 2008-03-24 (5859 days ago) |
Marine-Blue | 2008-03-22 (5861 days ago) |
Courant | 2008-03-22 (5861 days ago) |
Miya | 2008-03-20 (5863 days ago) |
Mulukhiyya | 2008-03-12 (5871 days ago) |
Mzm5zbC3 | 2008-03-11 (5872 days ago) |
Bletilla | 2008-03-08 (5875 days ago) |
Aotake | 2008-03-08 (5875 days ago) |
Widehawk | 2008-03-04 (5880 days ago) |
おはぐろ蜻蛉 | 2008-02-28 (5884 days ago) |
ネッツ | 2008-02-27 (5885 days ago) |
NJT | 2008-02-24 (5888 days ago) |
朝彦 | 2008-02-24 (5889 days ago) |
Yassie | 2008-02-21 (5891 days ago) |
辞典の虫 | 2008-02-16 (5897 days ago) |
Tommy6 | 2008-02-13 (5899 days ago) |
Peccafly | 2008-02-10 (5902 days ago) |
Uryah | 2008-02-10 (5902 days ago) |
Kstigarbha | 2008-02-03 (5909 days ago) |
Bukki | 2008-02-03 (5910 days ago) |
Bellcricket | 2008-02-02 (5910 days ago) |
Sylphie | 2008-02-01 (5911 days ago) |
Pica | 2008-02-01 (5911 days ago) |
Quatro | 2008-01-30 (5913 days ago) |
Miya.m | 2008-01-29 (5914 days ago) |
Londonbashi | 2008-01-28 (5915 days ago) |
Kickaha | 2008-01-27 (5916 days ago) |
Co.kyoto | 2008-01-27 (5916 days ago) |
Hirokun | 2008-01-27 (5916 days ago) |
Complex01 | 2008-01-27 (5916 days ago) |
千代林檎 | 2008-01-26 (5917 days ago) |
Lonicera | 2008-01-25 (5918 days ago) |
ZERBERUS | 2008-01-25 (5918 days ago) |
Hyolee2 | 2008-01-25 (5918 days ago) |
Tangotango | 2008-01-18 (5925 days ago) |
Lemonsquash | 2008-01-16 (5927 days ago) |
Knua | 2008-01-12 (5931 days ago) |
Michey.M | 2008-01-05 (5938 days ago) |
SS95 | 2007-12-27 (5947 days ago) |
Suzuyoshinine | 2007-12-21 (5953 days ago) |
Horlicks | 2007-12-21 (5954 days ago) |
Volfgang | 2007-12-16 (5958 days ago) |
Watermint | 2007-12-14 (5960 days ago) |
Schu | 2007-12-14 (5961 days ago) |
Tietew | 2007-12-10 (5965 days ago) |
Dekimasu | 2007-12-04 (5971 days ago) |
Swind | 2007-12-03 (5971 days ago) |
Kareha | 2007-12-01 (5973 days ago) |
Tamtarm | 2007-11-29 (5975 days ago) |
Clarin | 2007-11-29 (5976 days ago) |
Kasuga | 2007-11-28 (5976 days ago) |
11ChamOK | 2007-11-28 (5976 days ago) |
Kurihaya | 2007-11-28 (5976 days ago) |
Lusheeta | 2007-11-28 (5976 days ago) |
Noraneko | 2007-11-28 (5977 days ago) |
Kotodama-Reverse | 2007-11-26 (5978 days ago) |
T-coco | 2007-11-26 (5978 days ago) |
Numerike | 2007-11-26 (5978 days ago) |
霧木諒二 | 2007-11-26 (5978 days ago) |
Takot | 2007-11-25 (5979 days ago) |
Himetv | 2007-10-24 (6011 days ago) |
Remington | 2007-10-20 (6015 days ago) |
SantaClaus | 2007-09-25 (6040 days ago) |
T.Saito | 2007-09-24 (6041 days ago) |
Tiens | 2007-09-18 (6048 days ago) |
Coryjp | 2007-09-05 (6060 days ago) |
Muyo | 2007-09-03 (6062 days ago) |
Ribbon | 2007-08-16 (6080 days ago) |
Penpen | 2007-08-08 (6089 days ago) |
PiaCarrot | 2007-08-04 (6092 days ago) |
YouShow | 2007-07-27 (6100 days ago) |
Chinneeb | 2007-07-03 (6125 days ago) |
HALPHA | 2007-07-01 (6126 days ago) |
Tonync | 2007-05-17 (6171 days ago) |
Araisyohei | 2007-04-21 (6197 days ago) |
七星 | 2007-04-21 (6198 days ago) |
LQVX | 2007-04-16 (6203 days ago) |
Goncyan | 2007-04-05 (6213 days ago) |
端くれの錬金術師 | 2007-04-02 (6216 days ago) |
Matsumomushi | 2007-03-25 (6224 days ago) |
かんがへなし | 2007-03-17 (6232 days ago) |
Rocky7 | 2007-03-16 (6233 days ago) |
Lonchi** | 2007-03-09 (6240 days ago) |
っ | 2007-02-17 (6260 days ago) |
Kkkdc | 2007-02-16 (6261 days ago) |
Diagraph01 | 2007-02-06 (6271 days ago) |
Pachayachachic | 2007-02-03 (6274 days ago) |
Adr6721 | 2007-02-01 (6276 days ago) |
Su-no-G | 2007-02-01 (6276 days ago) |
100 rows in set (1 min 2.26 sec)
id/Bahasa Indonesian[edit]
last update: 2008-03-28 (5856 days ago)
Name | Last edit |
---|---|
Azmi1995 | 2008-03-25 (5858 days ago) |
IDRex | 2008-03-25 (5858 days ago) |
IvanLanin | 2008-03-22 (5861 days ago) |
Mimihitam | 2008-03-19 (5864 days ago) |
Master2841 | 2008-03-08 (5875 days ago) |
Chriswaterguy | 2008-03-07 (5877 days ago) |
Borgx | 2008-03-04 (5880 days ago) |
Kandar | 2008-02-18 (5894 days ago) |
Meursault2004 | 2008-02-12 (5900 days ago) |
Dragunova | 2008-02-08 (5904 days ago) |
Hariadhi | 2007-08-03 (6093 days ago) |
Irwangatot | 2007-06-12 (6145 days ago) |
Anggoro | 2006-12-07 (6332 days ago) |
Winana | 2006-11-22 (6347 days ago) |
Anggreani | 2006-08-04 (6457 days ago) |
HarisX | 2006-05-12 (6541 days ago) |
Zaidpjd | 2005-11-20 (6714 days ago) |
Widhiantoro | 2005-11-18 (6717 days ago) |
Sudiryo | 2005-11-18 (6717 days ago) |
*drew | 2005-11-08 (6726 days ago) |
20 rows in set (51.73 sec)
ro/Romanian[edit]
last update: 2008-03-28 (5856 days ago)
Name | Last edit |
---|---|
SCriBu | 2008-02-24 (5888 days ago) |
Cuman | 2008-01-25 (5918 days ago) |
Desiphral | 2008-01-16 (5927 days ago) |
IulianU | 2008-01-14 (5929 days ago) |
AQUA | 2007-12-20 (5954 days ago) |
Romihaitza | 2007-11-27 (5977 days ago) |
BlueMonday | 2007-11-24 (5980 days ago) |
Dorothea | 2007-11-19 (5985 days ago) |
Bogdan | 2007-10-22 (6013 days ago) |
Mocu | 2007-06-09 (6148 days ago) |
Lorandka | 2007-01-05 (6303 days ago) |
TSO1D | 2006-12-01 (6338 days ago) |
Ronline | 2006-11-18 (6352 days ago) |
Dmaftei | 2006-10-05 (6396 days ago) |
Evosphere | 2006-07-14 (6478 days ago) |
Orioane | 2006-06-29 (6493 days ago) |
Victort | 2006-01-02 (6671 days ago) |
NazismIsntCool | 2005-11-06 (6729 days ago) |
18 rows in set (55.09 sec)
sv/Swedish[edit]
last update: 2008-03-28 (5856 days ago)
Name | Last edit |
---|---|
Micke | 2008-03-27 (5856 days ago) |
Robertgreer | 2008-03-26 (5857 days ago) |
M.M.S. | 2008-03-26 (5857 days ago) |
Habj | 2008-03-25 (5858 days ago) |
SvHannibal | 2008-03-24 (5859 days ago) |
Moralist | 2008-03-24 (5859 days ago) |
Boivie | 2008-03-14 (5869 days ago) |
Mikez | 2008-03-04 (5880 days ago) |
Riggwelter | 2008-02-16 (5896 days ago) |
Malhonen | 2008-02-13 (5899 days ago) |
LX | 2008-01-15 (5928 days ago) |
Skomakarn | 2008-01-07 (5937 days ago) |
Johngreen | 2007-12-04 (5970 days ago) |
RaSten | 2007-10-21 (6014 days ago) |
Pcongre | 2007-10-13 (6022 days ago) |
Klibbnisse | 2007-08-27 (6069 days ago) |
Edricson | 2007-08-09 (6087 days ago) |
Smiddle | 2007-04-21 (6197 days ago) |
Skagedal | 2007-04-01 (6217 days ago) |
Yenx | 2007-01-08 (6300 days ago) |
Kruosio | 2006-12-11 (6328 days ago) |
NERIUM | 2006-06-29 (6494 days ago) |
Jniemenmaa | 2006-06-12 (6510 days ago) |
Marsve | 2006-05-05 (6548 days ago) |
Aktalo | 2006-01-23 (6650 days ago) |
Diyako | 2006-01-17 (6657 days ago) |
Storpilot | 2005-12-12 (6692 days ago) |
Scoo | 2005-12-08 (6696 days ago) |
Qwm | 2005-11-16 (6719 days ago) |
ShineB | 2005-09-29 (6766 days ago) |
Tehvata | 2005-07-01 (6856 days ago) |
31 rows in set (3 min 51.74 sec)
uk/Ukrainian[edit]
last update: 2008-03-28 (5856 days ago)
Name | Last edit |
---|---|
Ahonc | 2008-03-25 (5858 days ago) |
Riwnodennyk | 2008-03-25 (5858 days ago) |
A1 | 2008-02-11 (5901 days ago) |
Ilyaroz | 2008-01-27 (5917 days ago) |
Movses | 2008-01-23 (5920 days ago) |
Yakudza | 2007-11-20 (5984 days ago) |
Minia | 2007-11-18 (5986 days ago) |
EvgenyGenkin | 2007-11-13 (5991 days ago) |
DmRodionov | 2007-08-25 (6071 days ago) |
Mikolasz | 2007-07-14 (6113 days ago) |
Hayk | 2007-07-07 (6120 days ago) |
Panas | 2007-07-01 (6126 days ago) |
Yms | 2007-04-09 (6209 days ago) |
Nevermind | 2006-12-18 (6321 days ago) |
Angryxpeh | 2006-12-14 (6325 days ago) |
AndriyK | 2006-11-24 (6345 days ago) |
Martynenka | 2006-11-08 (6361 days ago) |
Redsunrising | 2006-11-04 (6365 days ago) |
Ornil | 2006-11-03 (6366 days ago) |
Jan-ivan | 2005-11-14 (6720 days ago) |
Inetd | 2005-03-26 (6953 days ago) |
21 rows in set (1 min 55.31 sec)
vi/Vietnamese[edit]
last update: 2008-03-28 (5856 days ago)
Name | Last edit |
---|---|
Vinhtantran | 2008-03-27 (5857 days ago) |
Neoneurone | 2007-11-15 (5989 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 }} |