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
editlast update: 2008-03-28 (5950 days ago)
Name | Last edit |
---|---|
Spiritia | 2008-03-20 (5957 days ago) |
Timurberk | 2008-02-04 (6002 days ago) |
Daggerstab | 2008-01-19 (6018 days ago) |
5ko | 2008-01-01 (6036 days ago) |
Azimski | 2007-09-19 (6140 days ago) |
Nk | 2007-06-28 (6223 days ago) |
Vanka5 | 2007-05-25 (6258 days ago) |
Sharkb | 2007-01-21 (6381 days ago) |
Bggoldie | 2006-12-19 (6414 days ago) |
DCLXVI | 2006-08-06 (6549 days ago) |
Smartech | 2006-04-14 (6663 days ago) |
Glimz | 2006-04-02 (6675 days ago) |
Espetkov | 2005-06-05 (6976 days ago) |
13 rows in set (56.82 sec)
last update: 2008-03-28 (5950 days ago)
Name | Last edit |
---|---|
Bellayet | 2008-03-26 (5951 days ago) |
Aeetlrsk | 2008-02-04 (6002 days ago) |
Frdayeen | 2008-01-08 (6029 days ago) |
Hermitage17 | 2008-01-08 (6030 days ago) |
4 rows in set (9.26 sec)
last update: 2008-03-28 (5950 days ago)
Name | Last edit |
---|---|
AtteL | 2008-03-25 (5952 days ago) |
Str4nd | 2008-03-24 (5953 days ago) |
Roosa | 2008-03-05 (5973 days ago) |
Malhonen | 2008-02-13 (5993 days ago) |
Ilaiho | 2007-12-25 (6043 days ago) |
Argus | 2007-11-12 (6086 days ago) |
Jariola | 2007-10-29 (6100 days ago) |
Kyzyl | 2007-07-16 (6205 days ago) |
Skuolfi | 2007-05-13 (6269 days ago) |
Urvabara | 2007-02-08 (6363 days ago) |
Jni | 2007-01-29 (6373 days ago) |
NZ- | 2006-12-30 (6403 days ago) |
Vilu | 2006-12-26 (6407 days ago) |
Hartz | 2006-12-15 (6418 days ago) |
Mzlla | 2006-12-07 (6426 days ago) |
Inzulac | 2006-10-31 (6463 days ago) |
Lauranen | 2006-10-02 (6492 days ago) |
Totuus | 2006-09-05 (6519 days ago) |
Anchjo | 2006-08-31 (6524 days ago) |
Pwc | 2006-08-05 (6550 days ago) |
Kouluhai | 2006-06-23 (6593 days ago) |
Jniemenmaa | 2006-06-12 (6604 days ago) |
Bobet | 2006-02-06 (6730 days ago) |
Finlandia | 2005-12-28 (6770 days ago) |
Hapsiainen | 2005-12-09 (6789 days ago) |
Viznut | 2005-07-27 (6924 days ago) |
Lanahard | 2005-07-21 (6930 days ago) |
Rdnk | 2005-05-24 (6988 days ago) |
31 rows in set (55.17 sec)
last update: 2008-03-28 (5950 days ago)
Name | Last edit |
---|---|
Spacebirdy | 2008-03-27 (5950 days ago) |
Bengoa | 2008-03-27 (5950 days ago) |
Kylu | 2008-03-27 (5951 days ago) |
Julie | 2008-03-26 (5951 days ago) |
Taichi | 2008-03-26 (5951 days ago) |
Ascánder | 2008-03-26 (5951 days ago) |
Smeira | 2008-03-26 (5951 days ago) |
SMP | 2008-03-26 (5951 days ago) |
Drini | 2008-03-26 (5951 days ago) |
Rdsmith4 | 2008-03-25 (5952 days ago) |
Masterches | 2008-03-25 (5952 days ago) |
Wikimistusik | 2008-03-25 (5952 days ago) |
Mikel | 2008-03-25 (5953 days ago) |
Willtron | 2008-03-24 (5953 days ago) |
CHV | 2008-03-24 (5953 days ago) |
Tosão | 2008-03-23 (5954 days ago) |
Redux | 2008-03-21 (5956 days ago) |
Xic667 | 2008-03-21 (5956 days ago) |
LaosLos | 2008-03-20 (5957 days ago) |
BetoCG | 2008-03-17 (5960 days ago) |
DamianFinol | 2008-03-16 (5961 days ago) |
Jurock | 2008-03-13 (5964 days ago) |
Oswaldo2025 | 2008-03-13 (5965 days ago) |
Damërung | 2008-03-08 (5969 days ago) |
Alhen | 2008-03-06 (5971 days ago) |
Fajro | 2008-03-04 (5973 days ago) |
LadyInGrey | 2008-03-03 (5974 days ago) |
Barcex | 2008-03-02 (5975 days ago) |
Alpertron | 2008-02-29 (5977 days ago) |
Cromwellt | 2008-02-29 (5978 days ago) |
RedCoat | 2008-02-28 (5978 days ago) |
Sapey | 2008-02-20 (5986 days ago) |
Elisardojm | 2008-02-20 (5986 days ago) |
Lascorz | 2008-02-19 (5987 days ago) |
Rastrojo | 2008-02-19 (5987 days ago) |
Cedric31 | 2008-02-19 (5987 days ago) |
Prevert | 2008-02-16 (5990 days ago) |
Aleator | 2008-02-15 (5991 days ago) |
Zuirdj | 2008-02-15 (5991 days ago) |
Orereta | 2008-02-15 (5991 days ago) |
FrancoGG | 2008-02-11 (5995 days ago) |
Loco085 | 2008-02-10 (5996 days ago) |
Agüeybaná | 2008-02-10 (5996 days ago) |
Mtmelendez | 2008-02-08 (5998 days ago) |
TXiKi | 2008-02-08 (5998 days ago) |
SCPS | 2008-02-07 (5999 days ago) |
Toliño | 2008-02-07 (5999 days ago) |
Theklan | 2008-02-07 (5999 days ago) |
ReyBrujo | 2008-02-05 (6001 days ago) |
Vilallonga | 2008-01-30 (6007 days ago) |
Gaudio | 2008-01-25 (6012 days ago) |
AlimanRuna | 2008-01-24 (6013 days ago) |
Xtv | 2008-01-19 (6018 days ago) |
Vriullop | 2008-01-18 (6019 days ago) |
Desiphral | 2008-01-16 (6021 days ago) |
DDarkfire | 2008-01-15 (6023 days ago) |
Jove | 2008-01-08 (6030 days ago) |
Pepelopex | 2008-01-07 (6030 days ago) |
Esbardu | 2008-01-07 (6031 days ago) |
Carles | 2007-12-30 (6038 days ago) |
Celestianpower | 2007-12-30 (6038 days ago) |
RRmeta | 2007-12-30 (6039 days ago) |
Axxgreazz | 2007-12-23 (6046 days ago) |
Sobreira | 2007-12-22 (6046 days ago) |
Varano | 2007-12-18 (6050 days ago) |
Chlewey | 2007-12-17 (6051 days ago) |
Javierm | 2007-12-13 (6055 days ago) |
Kipmaster | 2007-12-10 (6058 days ago) |
Adalbertofrenesi | 2007-12-07 (6061 days ago) |
JB82 | 2007-12-06 (6063 days ago) |
Patstuart | 2007-12-04 (6064 days ago) |
Subtiempo | 2007-11-30 (6068 days ago) |
Jaranda | 2007-11-30 (6068 days ago) |
Mac | 2007-11-29 (6069 days ago) |
Lmbuga | 2007-11-28 (6070 days ago) |
Janfri | 2007-11-28 (6070 days ago) |
Banjo | 2007-11-24 (6074 days ago) |
Malvenko | 2007-11-23 (6075 days ago) |
Iradigalesc | 2007-11-23 (6075 days ago) |
Llull | 2007-11-23 (6075 days ago) |
Lohen11 | 2007-11-21 (6077 days ago) |
Vibragiel | 2007-11-20 (6078 days ago) |
Sanbec | 2007-11-20 (6078 days ago) |
Yrithinnd | 2007-11-19 (6079 days ago) |
Bdenk715 | 2007-11-14 (6084 days ago) |
Marianocecowski | 2007-11-12 (6086 days ago) |
Kuartas | 2007-11-10 (6088 days ago) |
GlimmerPhoenix | 2007-11-09 (6089 days ago) |
Fryant | 2007-11-08 (6090 days ago) |
Edub | 2007-10-28 (6101 days ago) |
Jynus | 2007-10-24 (6105 days ago) |
Prietoquilmes | 2007-10-21 (6108 days ago) |
Spangineer | 2007-10-14 (6115 days ago) |
Pcongre | 2007-10-13 (6116 days ago) |
Rodasmith | 2007-10-11 (6118 days ago) |
JorgeGG | 2007-10-08 (6121 days ago) |
Battroid | 2007-10-06 (6124 days ago) |
Morza | 2007-09-30 (6129 days ago) |
Albdallah | 2007-09-29 (6130 days ago) |
Albeiror24 | 2007-09-29 (6130 days ago) |
100 rows in set (1 min 17.61 sec)
last update: 2008-03-28 (5950 days ago)
Name | Last edit |
---|---|
Ashishbhatnagar | 2008-02-22 (5985 days ago) |
Rajeevmass | 2008-02-07 (5999 days ago) |
Eukesh | 2008-02-03 (6003 days ago) |
Shyam | 2008-01-10 (6027 days ago) |
Srikeit | 2007-12-06 (6062 days ago) |
Sanjaybafnaji | 2007-07-26 (6195 days ago) |
Mexxian | 2007-05-27 (6255 days ago) |
Spundun | 2007-03-30 (6313 days ago) |
Shreshth91 | 2007-02-16 (6356 days ago) |
Jdas07 | 2006-09-12 (6512 days ago) |
Dineshjk | 2005-08-05 (6915 days ago) |
Abhishekbh | 2005-04-21 (7021 days ago) |
12 rows in set (43.28 sec)
last update: 2008-03-28 (5950 days ago)
Name | Last edit |
---|---|
Tuinui | 2008-03-27 (5950 days ago) |
Bookman | 2008-03-27 (5950 days ago) |
Aphaia | 2008-03-27 (5951 days ago) |
Kahusi | 2008-03-26 (5951 days ago) |
Me2hero | 2008-03-26 (5951 days ago) |
Genppy | 2008-03-26 (5952 days ago) |
Kanjy | 2008-03-25 (5952 days ago) |
Ninomy | 2008-03-25 (5952 days ago) |
Kzhr | 2008-03-25 (5952 days ago) |
LERK | 2008-03-25 (5952 days ago) |
ZCU | 2008-03-24 (5953 days ago) |
ゆいしあす | 2008-03-24 (5953 days ago) |
Marine-Blue | 2008-03-22 (5955 days ago) |
Courant | 2008-03-22 (5956 days ago) |
Miya | 2008-03-20 (5958 days ago) |
Mulukhiyya | 2008-03-12 (5965 days ago) |
Mzm5zbC3 | 2008-03-11 (5966 days ago) |
Bletilla | 2008-03-08 (5969 days ago) |
Aotake | 2008-03-08 (5970 days ago) |
Widehawk | 2008-03-04 (5974 days ago) |
おはぐろ蜻蛉 | 2008-02-28 (5978 days ago) |
ネッツ | 2008-02-27 (5979 days ago) |
NJT | 2008-02-24 (5982 days ago) |
朝彦 | 2008-02-24 (5983 days ago) |
Yassie | 2008-02-21 (5985 days ago) |
辞典の虫 | 2008-02-16 (5991 days ago) |
Tommy6 | 2008-02-13 (5993 days ago) |
Peccafly | 2008-02-10 (5996 days ago) |
Uryah | 2008-02-10 (5996 days ago) |
Kstigarbha | 2008-02-03 (6003 days ago) |
Bukki | 2008-02-03 (6004 days ago) |
Bellcricket | 2008-02-02 (6004 days ago) |
Sylphie | 2008-02-01 (6005 days ago) |
Pica | 2008-02-01 (6005 days ago) |
Quatro | 2008-01-30 (6007 days ago) |
Miya.m | 2008-01-29 (6008 days ago) |
Londonbashi | 2008-01-28 (6009 days ago) |
Kickaha | 2008-01-27 (6010 days ago) |
Co.kyoto | 2008-01-27 (6010 days ago) |
Hirokun | 2008-01-27 (6010 days ago) |
Complex01 | 2008-01-27 (6010 days ago) |
千代林檎 | 2008-01-26 (6012 days ago) |
Lonicera | 2008-01-25 (6012 days ago) |
ZERBERUS | 2008-01-25 (6012 days ago) |
Hyolee2 | 2008-01-25 (6013 days ago) |
Tangotango | 2008-01-18 (6019 days ago) |
Lemonsquash | 2008-01-16 (6021 days ago) |
Knua | 2008-01-12 (6025 days ago) |
Michey.M | 2008-01-05 (6032 days ago) |
SS95 | 2007-12-27 (6041 days ago) |
Suzuyoshinine | 2007-12-21 (6047 days ago) |
Horlicks | 2007-12-21 (6048 days ago) |
Volfgang | 2007-12-16 (6052 days ago) |
Watermint | 2007-12-14 (6054 days ago) |
Schu | 2007-12-14 (6055 days ago) |
Tietew | 2007-12-10 (6059 days ago) |
Dekimasu | 2007-12-04 (6065 days ago) |
Swind | 2007-12-03 (6066 days ago) |
Kareha | 2007-12-01 (6067 days ago) |
Tamtarm | 2007-11-29 (6069 days ago) |
Clarin | 2007-11-29 (6070 days ago) |
Kasuga | 2007-11-28 (6070 days ago) |
11ChamOK | 2007-11-28 (6070 days ago) |
Kurihaya | 2007-11-28 (6070 days ago) |
Lusheeta | 2007-11-28 (6070 days ago) |
Noraneko | 2007-11-28 (6071 days ago) |
Kotodama-Reverse | 2007-11-26 (6072 days ago) |
T-coco | 2007-11-26 (6072 days ago) |
Numerike | 2007-11-26 (6072 days ago) |
霧木諒二 | 2007-11-26 (6072 days ago) |
Takot | 2007-11-25 (6073 days ago) |
Himetv | 2007-10-24 (6106 days ago) |
Remington | 2007-10-20 (6109 days ago) |
SantaClaus | 2007-09-25 (6134 days ago) |
T.Saito | 2007-09-24 (6135 days ago) |
Tiens | 2007-09-18 (6142 days ago) |
Coryjp | 2007-09-05 (6154 days ago) |
Muyo | 2007-09-03 (6156 days ago) |
Ribbon | 2007-08-16 (6175 days ago) |
Penpen | 2007-08-08 (6183 days ago) |
PiaCarrot | 2007-08-04 (6186 days ago) |
YouShow | 2007-07-27 (6194 days ago) |
Chinneeb | 2007-07-03 (6219 days ago) |
HALPHA | 2007-07-01 (6220 days ago) |
Tonync | 2007-05-17 (6265 days ago) |
Araisyohei | 2007-04-21 (6291 days ago) |
七星 | 2007-04-21 (6292 days ago) |
LQVX | 2007-04-16 (6297 days ago) |
Goncyan | 2007-04-05 (6308 days ago) |
端くれの錬金術師 | 2007-04-02 (6310 days ago) |
Matsumomushi | 2007-03-25 (6319 days ago) |
かんがへなし | 2007-03-17 (6326 days ago) |
Rocky7 | 2007-03-16 (6327 days ago) |
Lonchi** | 2007-03-09 (6335 days ago) |
っ | 2007-02-17 (6354 days ago) |
Kkkdc | 2007-02-16 (6355 days ago) |
Diagraph01 | 2007-02-06 (6365 days ago) |
Pachayachachic | 2007-02-03 (6369 days ago) |
Adr6721 | 2007-02-01 (6370 days ago) |
Su-no-G | 2007-02-01 (6371 days ago) |
100 rows in set (1 min 2.26 sec)
last update: 2008-03-28 (5950 days ago)
Name | Last edit |
---|---|
Azmi1995 | 2008-03-25 (5952 days ago) |
IDRex | 2008-03-25 (5952 days ago) |
IvanLanin | 2008-03-22 (5955 days ago) |
Mimihitam | 2008-03-19 (5958 days ago) |
Master2841 | 2008-03-08 (5969 days ago) |
Chriswaterguy | 2008-03-07 (5971 days ago) |
Borgx | 2008-03-04 (5974 days ago) |
Kandar | 2008-02-18 (5988 days ago) |
Meursault2004 | 2008-02-12 (5994 days ago) |
Dragunova | 2008-02-08 (5998 days ago) |
Hariadhi | 2007-08-03 (6187 days ago) |
Irwangatot | 2007-06-12 (6239 days ago) |
Anggoro | 2006-12-07 (6426 days ago) |
Winana | 2006-11-22 (6441 days ago) |
Anggreani | 2006-08-04 (6551 days ago) |
HarisX | 2006-05-12 (6636 days ago) |
Zaidpjd | 2005-11-20 (6808 days ago) |
Widhiantoro | 2005-11-18 (6811 days ago) |
Sudiryo | 2005-11-18 (6811 days ago) |
*drew | 2005-11-08 (6820 days ago) |
20 rows in set (51.73 sec)
last update: 2008-03-28 (5950 days ago)
Name | Last edit |
---|---|
SCriBu | 2008-02-24 (5982 days ago) |
Cuman | 2008-01-25 (6012 days ago) |
Desiphral | 2008-01-16 (6021 days ago) |
IulianU | 2008-01-14 (6023 days ago) |
AQUA | 2007-12-20 (6048 days ago) |
Romihaitza | 2007-11-27 (6071 days ago) |
BlueMonday | 2007-11-24 (6074 days ago) |
Dorothea | 2007-11-19 (6079 days ago) |
Bogdan | 2007-10-22 (6107 days ago) |
Mocu | 2007-06-09 (6242 days ago) |
Lorandka | 2007-01-05 (6397 days ago) |
TSO1D | 2006-12-01 (6432 days ago) |
Ronline | 2006-11-18 (6446 days ago) |
Dmaftei | 2006-10-05 (6490 days ago) |
Evosphere | 2006-07-14 (6572 days ago) |
Orioane | 2006-06-29 (6587 days ago) |
Victort | 2006-01-02 (6765 days ago) |
NazismIsntCool | 2005-11-06 (6823 days ago) |
18 rows in set (55.09 sec)
last update: 2008-03-28 (5950 days ago)
Name | Last edit |
---|---|
Micke | 2008-03-27 (5950 days ago) |
Robertgreer | 2008-03-26 (5951 days ago) |
M.M.S. | 2008-03-26 (5951 days ago) |
Habj | 2008-03-25 (5952 days ago) |
SvHannibal | 2008-03-24 (5953 days ago) |
Moralist | 2008-03-24 (5953 days ago) |
Boivie | 2008-03-14 (5963 days ago) |
Mikez | 2008-03-04 (5974 days ago) |
Riggwelter | 2008-02-16 (5990 days ago) |
Malhonen | 2008-02-13 (5993 days ago) |
LX | 2008-01-15 (6022 days ago) |
Skomakarn | 2008-01-07 (6031 days ago) |
Johngreen | 2007-12-04 (6064 days ago) |
RaSten | 2007-10-21 (6108 days ago) |
Pcongre | 2007-10-13 (6116 days ago) |
Klibbnisse | 2007-08-27 (6163 days ago) |
Edricson | 2007-08-09 (6181 days ago) |
Smiddle | 2007-04-21 (6291 days ago) |
Skagedal | 2007-04-01 (6311 days ago) |
Yenx | 2007-01-08 (6394 days ago) |
Kruosio | 2006-12-11 (6422 days ago) |
NERIUM | 2006-06-29 (6588 days ago) |
Jniemenmaa | 2006-06-12 (6604 days ago) |
Marsve | 2006-05-05 (6642 days ago) |
Aktalo | 2006-01-23 (6744 days ago) |
Diyako | 2006-01-17 (6751 days ago) |
Storpilot | 2005-12-12 (6786 days ago) |
Scoo | 2005-12-08 (6790 days ago) |
Qwm | 2005-11-16 (6813 days ago) |
ShineB | 2005-09-29 (6860 days ago) |
Tehvata | 2005-07-01 (6950 days ago) |
31 rows in set (3 min 51.74 sec)
last update: 2008-03-28 (5950 days ago)
Name | Last edit |
---|---|
Ahonc | 2008-03-25 (5952 days ago) |
Riwnodennyk | 2008-03-25 (5952 days ago) |
A1 | 2008-02-11 (5995 days ago) |
Ilyaroz | 2008-01-27 (6011 days ago) |
Movses | 2008-01-23 (6014 days ago) |
Yakudza | 2007-11-20 (6078 days ago) |
Minia | 2007-11-18 (6080 days ago) |
EvgenyGenkin | 2007-11-13 (6085 days ago) |
DmRodionov | 2007-08-25 (6165 days ago) |
Mikolasz | 2007-07-14 (6207 days ago) |
Hayk | 2007-07-07 (6214 days ago) |
Panas | 2007-07-01 (6220 days ago) |
Yms | 2007-04-09 (6303 days ago) |
Nevermind | 2006-12-18 (6415 days ago) |
Angryxpeh | 2006-12-14 (6419 days ago) |
AndriyK | 2006-11-24 (6439 days ago) |
Martynenka | 2006-11-08 (6455 days ago) |
Redsunrising | 2006-11-04 (6459 days ago) |
Ornil | 2006-11-03 (6460 days ago) |
Jan-ivan | 2005-11-14 (6814 days ago) |
Inetd | 2005-03-26 (7047 days ago) |
21 rows in set (1 min 55.31 sec)
last update: 2008-03-28 (5950 days ago)
Name | Last edit |
---|---|
Vinhtantran | 2008-03-27 (5951 days ago) |
Neoneurone | 2007-11-15 (6083 days ago) |
2 rows in set (11.40 sec)
Generating
editStructure
editThis 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
editThe 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
editThe 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
editSSH output can be converted to wiki table syntax using the following regex:
search | \| (.+?)\s+\| (\d+) \| (?:\r\n)? |
---|---|
replace | {{/user |1= $1 |2= $2 }} |