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]last update: 2008-03-28 (6264 days ago)
Name | Last edit |
---|---|
Spiritia | 2008-03-20 (6271 days ago) |
Timurberk | 2008-02-04 (6316 days ago) |
Daggerstab | 2008-01-19 (6332 days ago) |
5ko | 2008-01-01 (6350 days ago) |
Azimski | 2007-09-19 (6454 days ago) |
Nk | 2007-06-28 (6537 days ago) |
Vanka5 | 2007-05-25 (6572 days ago) |
Sharkb | 2007-01-21 (6695 days ago) |
Bggoldie | 2006-12-19 (6728 days ago) |
DCLXVI | 2006-08-06 (6863 days ago) |
Smartech | 2006-04-14 (6977 days ago) |
Glimz | 2006-04-02 (6989 days ago) |
Espetkov | 2005-06-05 (7290 days ago) |
13 rows in set (56.82 sec)
last update: 2008-03-28 (6264 days ago)
Name | Last edit |
---|---|
Bellayet | 2008-03-26 (6265 days ago) |
Aeetlrsk | 2008-02-04 (6316 days ago) |
Frdayeen | 2008-01-08 (6343 days ago) |
Hermitage17 | 2008-01-08 (6344 days ago) |
4 rows in set (9.26 sec)
last update: 2008-03-28 (6264 days ago)
Name | Last edit |
---|---|
AtteL | 2008-03-25 (6266 days ago) |
Str4nd | 2008-03-24 (6267 days ago) |
Roosa | 2008-03-05 (6287 days ago) |
Malhonen | 2008-02-13 (6307 days ago) |
Ilaiho | 2007-12-25 (6357 days ago) |
Argus | 2007-11-12 (6400 days ago) |
Jariola | 2007-10-29 (6414 days ago) |
Kyzyl | 2007-07-16 (6519 days ago) |
Skuolfi | 2007-05-13 (6583 days ago) |
Urvabara | 2007-02-08 (6677 days ago) |
Jni | 2007-01-29 (6687 days ago) |
NZ- | 2006-12-30 (6717 days ago) |
Vilu | 2006-12-26 (6721 days ago) |
Hartz | 2006-12-15 (6732 days ago) |
Mzlla | 2006-12-07 (6740 days ago) |
Inzulac | 2006-10-31 (6777 days ago) |
Lauranen | 2006-10-02 (6806 days ago) |
Totuus | 2006-09-05 (6833 days ago) |
Anchjo | 2006-08-31 (6838 days ago) |
Pwc | 2006-08-05 (6864 days ago) |
Kouluhai | 2006-06-23 (6907 days ago) |
Jniemenmaa | 2006-06-12 (6918 days ago) |
Bobet | 2006-02-06 (7044 days ago) |
Finlandia | 2005-12-28 (7084 days ago) |
Hapsiainen | 2005-12-09 (7103 days ago) |
Viznut | 2005-07-27 (7238 days ago) |
Lanahard | 2005-07-21 (7244 days ago) |
Rdnk | 2005-05-24 (7302 days ago) |
31 rows in set (55.17 sec)
last update: 2008-03-28 (6264 days ago)
Name | Last edit |
---|---|
Spacebirdy | 2008-03-27 (6264 days ago) |
Bengoa | 2008-03-27 (6264 days ago) |
Kylu | 2008-03-27 (6265 days ago) |
Julie | 2008-03-26 (6265 days ago) |
Taichi | 2008-03-26 (6265 days ago) |
Ascánder | 2008-03-26 (6265 days ago) |
Smeira | 2008-03-26 (6265 days ago) |
SMP | 2008-03-26 (6265 days ago) |
Drini | 2008-03-26 (6265 days ago) |
Rdsmith4 | 2008-03-25 (6266 days ago) |
Masterches | 2008-03-25 (6266 days ago) |
Wikimistusik | 2008-03-25 (6266 days ago) |
Mikel | 2008-03-25 (6267 days ago) |
Willtron | 2008-03-24 (6267 days ago) |
CHV | 2008-03-24 (6267 days ago) |
Tosão | 2008-03-23 (6268 days ago) |
Redux | 2008-03-21 (6270 days ago) |
Xic667 | 2008-03-21 (6270 days ago) |
LaosLos | 2008-03-20 (6271 days ago) |
BetoCG | 2008-03-17 (6274 days ago) |
DamianFinol | 2008-03-16 (6275 days ago) |
Jurock | 2008-03-13 (6278 days ago) |
Oswaldo2025 | 2008-03-13 (6279 days ago) |
Damërung | 2008-03-08 (6283 days ago) |
Alhen | 2008-03-06 (6285 days ago) |
Fajro | 2008-03-04 (6287 days ago) |
LadyInGrey | 2008-03-03 (6288 days ago) |
Barcex | 2008-03-02 (6289 days ago) |
Alpertron | 2008-02-29 (6291 days ago) |
Cromwellt | 2008-02-29 (6292 days ago) |
RedCoat | 2008-02-28 (6292 days ago) |
Sapey | 2008-02-20 (6300 days ago) |
Elisardojm | 2008-02-20 (6300 days ago) |
Lascorz | 2008-02-19 (6301 days ago) |
Rastrojo | 2008-02-19 (6301 days ago) |
Cedric31 | 2008-02-19 (6301 days ago) |
Prevert | 2008-02-16 (6304 days ago) |
Aleator | 2008-02-15 (6305 days ago) |
Zuirdj | 2008-02-15 (6305 days ago) |
Orereta | 2008-02-15 (6305 days ago) |
FrancoGG | 2008-02-11 (6309 days ago) |
Loco085 | 2008-02-10 (6310 days ago) |
Agüeybaná | 2008-02-10 (6310 days ago) |
Mtmelendez | 2008-02-08 (6312 days ago) |
TXiKi | 2008-02-08 (6312 days ago) |
SCPS | 2008-02-07 (6313 days ago) |
Toliño | 2008-02-07 (6313 days ago) |
Theklan | 2008-02-07 (6313 days ago) |
ReyBrujo | 2008-02-05 (6315 days ago) |
Vilallonga | 2008-01-30 (6321 days ago) |
Gaudio | 2008-01-25 (6326 days ago) |
AlimanRuna | 2008-01-24 (6327 days ago) |
Xtv | 2008-01-19 (6332 days ago) |
Vriullop | 2008-01-18 (6333 days ago) |
Desiphral | 2008-01-16 (6335 days ago) |
DDarkfire | 2008-01-15 (6337 days ago) |
Jove | 2008-01-08 (6344 days ago) |
Pepelopex | 2008-01-07 (6344 days ago) |
Esbardu | 2008-01-07 (6345 days ago) |
Carles | 2007-12-30 (6352 days ago) |
Celestianpower | 2007-12-30 (6352 days ago) |
RRmeta | 2007-12-30 (6353 days ago) |
Axxgreazz | 2007-12-23 (6360 days ago) |
Sobreira | 2007-12-22 (6360 days ago) |
Varano | 2007-12-18 (6364 days ago) |
Chlewey | 2007-12-17 (6365 days ago) |
Javierm | 2007-12-13 (6369 days ago) |
Kipmaster | 2007-12-10 (6372 days ago) |
Adalbertofrenesi | 2007-12-07 (6375 days ago) |
JB82 | 2007-12-06 (6377 days ago) |
Patstuart | 2007-12-04 (6378 days ago) |
Subtiempo | 2007-11-30 (6382 days ago) |
Jaranda | 2007-11-30 (6382 days ago) |
Mac | 2007-11-29 (6383 days ago) |
Lmbuga | 2007-11-28 (6384 days ago) |
Janfri | 2007-11-28 (6384 days ago) |
Banjo | 2007-11-24 (6388 days ago) |
Malvenko | 2007-11-23 (6389 days ago) |
Iradigalesc | 2007-11-23 (6389 days ago) |
Llull | 2007-11-23 (6389 days ago) |
Lohen11 | 2007-11-21 (6391 days ago) |
Vibragiel | 2007-11-20 (6392 days ago) |
Sanbec | 2007-11-20 (6392 days ago) |
Yrithinnd | 2007-11-19 (6393 days ago) |
Bdenk715 | 2007-11-14 (6398 days ago) |
Marianocecowski | 2007-11-12 (6400 days ago) |
Kuartas | 2007-11-10 (6402 days ago) |
GlimmerPhoenix | 2007-11-09 (6403 days ago) |
Fryant | 2007-11-08 (6404 days ago) |
Edub | 2007-10-28 (6415 days ago) |
Jynus | 2007-10-24 (6419 days ago) |
Prietoquilmes | 2007-10-21 (6422 days ago) |
Spangineer | 2007-10-14 (6429 days ago) |
Pcongre | 2007-10-13 (6430 days ago) |
Rodasmith | 2007-10-11 (6432 days ago) |
JorgeGG | 2007-10-08 (6435 days ago) |
Battroid | 2007-10-06 (6438 days ago) |
Morza | 2007-09-30 (6443 days ago) |
Albdallah | 2007-09-29 (6444 days ago) |
Albeiror24 | 2007-09-29 (6444 days ago) |
100 rows in set (1 min 17.61 sec)
last update: 2008-03-28 (6264 days ago)
Name | Last edit |
---|---|
Ashishbhatnagar | 2008-02-22 (6299 days ago) |
Rajeevmass | 2008-02-07 (6313 days ago) |
Eukesh | 2008-02-03 (6317 days ago) |
Shyam | 2008-01-10 (6341 days ago) |
Srikeit | 2007-12-06 (6376 days ago) |
Sanjaybafnaji | 2007-07-26 (6509 days ago) |
Mexxian | 2007-05-27 (6569 days ago) |
Spundun | 2007-03-30 (6627 days ago) |
Shreshth91 | 2007-02-16 (6670 days ago) |
Jdas07 | 2006-09-12 (6826 days ago) |
Dineshjk | 2005-08-05 (7229 days ago) |
Abhishekbh | 2005-04-21 (7335 days ago) |
12 rows in set (43.28 sec)
last update: 2008-03-28 (6264 days ago)
Name | Last edit |
---|---|
Tuinui | 2008-03-27 (6264 days ago) |
Bookman | 2008-03-27 (6264 days ago) |
Aphaia | 2008-03-27 (6265 days ago) |
Kahusi | 2008-03-26 (6265 days ago) |
Me2hero | 2008-03-26 (6265 days ago) |
Genppy | 2008-03-26 (6266 days ago) |
Kanjy | 2008-03-25 (6266 days ago) |
Ninomy | 2008-03-25 (6266 days ago) |
Kzhr | 2008-03-25 (6266 days ago) |
LERK | 2008-03-25 (6266 days ago) |
ZCU | 2008-03-24 (6267 days ago) |
ゆいしあす | 2008-03-24 (6267 days ago) |
Marine-Blue | 2008-03-22 (6269 days ago) |
Courant | 2008-03-22 (6270 days ago) |
Miya | 2008-03-20 (6272 days ago) |
Mulukhiyya | 2008-03-12 (6279 days ago) |
Mzm5zbC3 | 2008-03-11 (6280 days ago) |
Bletilla | 2008-03-08 (6283 days ago) |
Aotake | 2008-03-08 (6284 days ago) |
Widehawk | 2008-03-04 (6288 days ago) |
おはぐろ蜻蛉 | 2008-02-28 (6292 days ago) |
ネッツ | 2008-02-27 (6293 days ago) |
NJT | 2008-02-24 (6296 days ago) |
朝彦 | 2008-02-24 (6297 days ago) |
Yassie | 2008-02-21 (6299 days ago) |
辞典の虫 | 2008-02-16 (6305 days ago) |
Tommy6 | 2008-02-13 (6307 days ago) |
Peccafly | 2008-02-10 (6310 days ago) |
Uryah | 2008-02-10 (6310 days ago) |
Kstigarbha | 2008-02-03 (6317 days ago) |
Bukki | 2008-02-03 (6318 days ago) |
Bellcricket | 2008-02-02 (6318 days ago) |
Sylphie | 2008-02-01 (6319 days ago) |
Pica | 2008-02-01 (6319 days ago) |
Quatro | 2008-01-30 (6321 days ago) |
Miya.m | 2008-01-29 (6322 days ago) |
Londonbashi | 2008-01-28 (6323 days ago) |
Kickaha | 2008-01-27 (6324 days ago) |
Co.kyoto | 2008-01-27 (6324 days ago) |
Hirokun | 2008-01-27 (6324 days ago) |
Complex01 | 2008-01-27 (6324 days ago) |
千代林檎 | 2008-01-26 (6326 days ago) |
Lonicera | 2008-01-25 (6326 days ago) |
ZERBERUS | 2008-01-25 (6326 days ago) |
Hyolee2 | 2008-01-25 (6327 days ago) |
Tangotango | 2008-01-18 (6333 days ago) |
Lemonsquash | 2008-01-16 (6335 days ago) |
Knua | 2008-01-12 (6339 days ago) |
Michey.M | 2008-01-05 (6346 days ago) |
SS95 | 2007-12-27 (6355 days ago) |
Suzuyoshinine | 2007-12-21 (6361 days ago) |
Horlicks | 2007-12-21 (6362 days ago) |
Volfgang | 2007-12-16 (6366 days ago) |
Watermint | 2007-12-14 (6368 days ago) |
Schu | 2007-12-14 (6369 days ago) |
Tietew | 2007-12-10 (6373 days ago) |
Dekimasu | 2007-12-04 (6379 days ago) |
Swind | 2007-12-03 (6380 days ago) |
Kareha | 2007-12-01 (6381 days ago) |
Tamtarm | 2007-11-29 (6383 days ago) |
Clarin | 2007-11-29 (6384 days ago) |
Kasuga | 2007-11-28 (6384 days ago) |
11ChamOK | 2007-11-28 (6384 days ago) |
Kurihaya | 2007-11-28 (6384 days ago) |
Lusheeta | 2007-11-28 (6384 days ago) |
Noraneko | 2007-11-28 (6385 days ago) |
Kotodama-Reverse | 2007-11-26 (6386 days ago) |
T-coco | 2007-11-26 (6386 days ago) |
Numerike | 2007-11-26 (6386 days ago) |
霧木諒二 | 2007-11-26 (6386 days ago) |
Takot | 2007-11-25 (6387 days ago) |
Himetv | 2007-10-24 (6420 days ago) |
Remington | 2007-10-20 (6423 days ago) |
SantaClaus | 2007-09-25 (6448 days ago) |
T.Saito | 2007-09-24 (6449 days ago) |
Tiens | 2007-09-18 (6456 days ago) |
Coryjp | 2007-09-05 (6468 days ago) |
Muyo | 2007-09-03 (6470 days ago) |
Ribbon | 2007-08-16 (6489 days ago) |
Penpen | 2007-08-08 (6497 days ago) |
PiaCarrot | 2007-08-04 (6500 days ago) |
YouShow | 2007-07-27 (6508 days ago) |
Chinneeb | 2007-07-03 (6533 days ago) |
HALPHA | 2007-07-01 (6534 days ago) |
Tonync | 2007-05-17 (6579 days ago) |
Araisyohei | 2007-04-21 (6605 days ago) |
七星 | 2007-04-21 (6606 days ago) |
LQVX | 2007-04-16 (6611 days ago) |
Goncyan | 2007-04-05 (6622 days ago) |
端くれの錬金術師 | 2007-04-02 (6624 days ago) |
Matsumomushi | 2007-03-25 (6633 days ago) |
かんがへなし | 2007-03-17 (6640 days ago) |
Rocky7 | 2007-03-16 (6641 days ago) |
Lonchi** | 2007-03-09 (6649 days ago) |
っ | 2007-02-17 (6668 days ago) |
Kkkdc | 2007-02-16 (6669 days ago) |
Diagraph01 | 2007-02-06 (6679 days ago) |
Pachayachachic | 2007-02-03 (6683 days ago) |
Adr6721 | 2007-02-01 (6684 days ago) |
Su-no-G | 2007-02-01 (6685 days ago) |
100 rows in set (1 min 2.26 sec)
last update: 2008-03-28 (6264 days ago)
Name | Last edit |
---|---|
Azmi1995 | 2008-03-25 (6266 days ago) |
IDRex | 2008-03-25 (6266 days ago) |
IvanLanin | 2008-03-22 (6269 days ago) |
Mimihitam | 2008-03-19 (6272 days ago) |
Master2841 | 2008-03-08 (6283 days ago) |
Chriswaterguy | 2008-03-07 (6285 days ago) |
Borgx | 2008-03-04 (6288 days ago) |
Kandar | 2008-02-18 (6302 days ago) |
Meursault2004 | 2008-02-12 (6308 days ago) |
Dragunova | 2008-02-08 (6312 days ago) |
Hariadhi | 2007-08-03 (6501 days ago) |
Irwangatot | 2007-06-12 (6553 days ago) |
Anggoro | 2006-12-07 (6740 days ago) |
Winana | 2006-11-22 (6755 days ago) |
Anggreani | 2006-08-04 (6865 days ago) |
HarisX | 2006-05-12 (6950 days ago) |
Zaidpjd | 2005-11-20 (7122 days ago) |
Widhiantoro | 2005-11-18 (7125 days ago) |
Sudiryo | 2005-11-18 (7125 days ago) |
*drew | 2005-11-08 (7134 days ago) |
20 rows in set (51.73 sec)
last update: 2008-03-28 (6264 days ago)
Name | Last edit |
---|---|
SCriBu | 2008-02-24 (6296 days ago) |
Cuman | 2008-01-25 (6326 days ago) |
Desiphral | 2008-01-16 (6335 days ago) |
IulianU | 2008-01-14 (6337 days ago) |
AQUA | 2007-12-20 (6362 days ago) |
Romihaitza | 2007-11-27 (6385 days ago) |
BlueMonday | 2007-11-24 (6388 days ago) |
Dorothea | 2007-11-19 (6393 days ago) |
Bogdan | 2007-10-22 (6421 days ago) |
Mocu | 2007-06-09 (6556 days ago) |
Lorandka | 2007-01-05 (6711 days ago) |
TSO1D | 2006-12-01 (6746 days ago) |
Ronline | 2006-11-18 (6760 days ago) |
Dmaftei | 2006-10-05 (6804 days ago) |
Evosphere | 2006-07-14 (6886 days ago) |
Orioane | 2006-06-29 (6901 days ago) |
Victort | 2006-01-02 (7079 days ago) |
NazismIsntCool | 2005-11-06 (7137 days ago) |
18 rows in set (55.09 sec)
last update: 2008-03-28 (6264 days ago)
Name | Last edit |
---|---|
Micke | 2008-03-27 (6264 days ago) |
Robertgreer | 2008-03-26 (6265 days ago) |
M.M.S. | 2008-03-26 (6265 days ago) |
Habj | 2008-03-25 (6266 days ago) |
SvHannibal | 2008-03-24 (6267 days ago) |
Moralist | 2008-03-24 (6267 days ago) |
Boivie | 2008-03-14 (6277 days ago) |
Mikez | 2008-03-04 (6288 days ago) |
Riggwelter | 2008-02-16 (6304 days ago) |
Malhonen | 2008-02-13 (6307 days ago) |
LX | 2008-01-15 (6336 days ago) |
Skomakarn | 2008-01-07 (6345 days ago) |
Johngreen | 2007-12-04 (6378 days ago) |
RaSten | 2007-10-21 (6422 days ago) |
Pcongre | 2007-10-13 (6430 days ago) |
Klibbnisse | 2007-08-27 (6477 days ago) |
Edricson | 2007-08-09 (6495 days ago) |
Smiddle | 2007-04-21 (6605 days ago) |
Skagedal | 2007-04-01 (6625 days ago) |
Yenx | 2007-01-08 (6708 days ago) |
Kruosio | 2006-12-11 (6736 days ago) |
NERIUM | 2006-06-29 (6902 days ago) |
Jniemenmaa | 2006-06-12 (6918 days ago) |
Marsve | 2006-05-05 (6956 days ago) |
Aktalo | 2006-01-23 (7058 days ago) |
Diyako | 2006-01-17 (7065 days ago) |
Storpilot | 2005-12-12 (7100 days ago) |
Scoo | 2005-12-08 (7104 days ago) |
Qwm | 2005-11-16 (7127 days ago) |
ShineB | 2005-09-29 (7174 days ago) |
Tehvata | 2005-07-01 (7264 days ago) |
31 rows in set (3 min 51.74 sec)
last update: 2008-03-28 (6264 days ago)
Name | Last edit |
---|---|
Ahonc | 2008-03-25 (6266 days ago) |
Riwnodennyk | 2008-03-25 (6266 days ago) |
A1 | 2008-02-11 (6309 days ago) |
Ilyaroz | 2008-01-27 (6325 days ago) |
Movses | 2008-01-23 (6328 days ago) |
Yakudza | 2007-11-20 (6392 days ago) |
Minia | 2007-11-18 (6394 days ago) |
EvgenyGenkin | 2007-11-13 (6399 days ago) |
DmRodionov | 2007-08-25 (6479 days ago) |
Mikolasz | 2007-07-14 (6521 days ago) |
Hayk | 2007-07-07 (6528 days ago) |
Panas | 2007-07-01 (6534 days ago) |
Yms | 2007-04-09 (6617 days ago) |
Nevermind | 2006-12-18 (6729 days ago) |
Angryxpeh | 2006-12-14 (6733 days ago) |
AndriyK | 2006-11-24 (6753 days ago) |
Martynenka | 2006-11-08 (6769 days ago) |
Redsunrising | 2006-11-04 (6773 days ago) |
Ornil | 2006-11-03 (6774 days ago) |
Jan-ivan | 2005-11-14 (7128 days ago) |
Inetd | 2005-03-26 (7361 days ago) |
21 rows in set (1 min 55.31 sec)
last update: 2008-03-28 (6264 days ago)
Name | Last edit |
---|---|
Vinhtantran | 2008-03-27 (6265 days ago) |
Neoneurone | 2007-11-15 (6397 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 }} |