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 (6093 days ago)
Name | Last edit |
---|---|
Spiritia | 2008-03-20 (6100 days ago) |
Timurberk | 2008-02-04 (6146 days ago) |
Daggerstab | 2008-01-19 (6162 days ago) |
5ko | 2008-01-01 (6179 days ago) |
Azimski | 2007-09-19 (6284 days ago) |
Nk | 2007-06-28 (6367 days ago) |
Vanka5 | 2007-05-25 (6401 days ago) |
Sharkb | 2007-01-21 (6525 days ago) |
Bggoldie | 2006-12-19 (6558 days ago) |
DCLXVI | 2006-08-06 (6693 days ago) |
Smartech | 2006-04-14 (6807 days ago) |
Glimz | 2006-04-02 (6819 days ago) |
Espetkov | 2005-06-05 (7120 days ago) |
13 rows in set (56.82 sec)
last update: 2008-03-28 (6093 days ago)
Name | Last edit |
---|---|
Bellayet | 2008-03-26 (6095 days ago) |
Aeetlrsk | 2008-02-04 (6145 days ago) |
Frdayeen | 2008-01-08 (6173 days ago) |
Hermitage17 | 2008-01-08 (6173 days ago) |
4 rows in set (9.26 sec)
last update: 2008-03-28 (6093 days ago)
Name | Last edit |
---|---|
AtteL | 2008-03-25 (6096 days ago) |
Str4nd | 2008-03-24 (6097 days ago) |
Roosa | 2008-03-05 (6116 days ago) |
Malhonen | 2008-02-13 (6136 days ago) |
Ilaiho | 2007-12-25 (6187 days ago) |
Argus | 2007-11-12 (6230 days ago) |
Jariola | 2007-10-29 (6244 days ago) |
Kyzyl | 2007-07-16 (6349 days ago) |
Skuolfi | 2007-05-13 (6413 days ago) |
Urvabara | 2007-02-08 (6507 days ago) |
Jni | 2007-01-29 (6517 days ago) |
NZ- | 2006-12-30 (6546 days ago) |
Vilu | 2006-12-26 (6550 days ago) |
Hartz | 2006-12-15 (6562 days ago) |
Mzlla | 2006-12-07 (6570 days ago) |
Inzulac | 2006-10-31 (6607 days ago) |
Lauranen | 2006-10-02 (6636 days ago) |
Totuus | 2006-09-05 (6663 days ago) |
Anchjo | 2006-08-31 (6668 days ago) |
Pwc | 2006-08-05 (6694 days ago) |
Kouluhai | 2006-06-23 (6737 days ago) |
Jniemenmaa | 2006-06-12 (6748 days ago) |
Bobet | 2006-02-06 (6874 days ago) |
Finlandia | 2005-12-28 (6914 days ago) |
Hapsiainen | 2005-12-09 (6933 days ago) |
Viznut | 2005-07-27 (7068 days ago) |
Lanahard | 2005-07-21 (7074 days ago) |
Rdnk | 2005-05-24 (7131 days ago) |
31 rows in set (55.17 sec)
last update: 2008-03-28 (6093 days ago)
Name | Last edit |
---|---|
Spacebirdy | 2008-03-27 (6094 days ago) |
Bengoa | 2008-03-27 (6094 days ago) |
Kylu | 2008-03-27 (6094 days ago) |
Julie | 2008-03-26 (6094 days ago) |
Taichi | 2008-03-26 (6094 days ago) |
Ascánder | 2008-03-26 (6095 days ago) |
Smeira | 2008-03-26 (6095 days ago) |
SMP | 2008-03-26 (6095 days ago) |
Drini | 2008-03-26 (6095 days ago) |
Rdsmith4 | 2008-03-25 (6095 days ago) |
Masterches | 2008-03-25 (6096 days ago) |
Wikimistusik | 2008-03-25 (6096 days ago) |
Mikel | 2008-03-25 (6096 days ago) |
Willtron | 2008-03-24 (6096 days ago) |
CHV | 2008-03-24 (6096 days ago) |
Tosão | 2008-03-23 (6097 days ago) |
Redux | 2008-03-21 (6100 days ago) |
Xic667 | 2008-03-21 (6100 days ago) |
LaosLos | 2008-03-20 (6101 days ago) |
BetoCG | 2008-03-17 (6103 days ago) |
DamianFinol | 2008-03-16 (6105 days ago) |
Jurock | 2008-03-13 (6108 days ago) |
Oswaldo2025 | 2008-03-13 (6108 days ago) |
Damërung | 2008-03-08 (6113 days ago) |
Alhen | 2008-03-06 (6115 days ago) |
Fajro | 2008-03-04 (6117 days ago) |
LadyInGrey | 2008-03-03 (6118 days ago) |
Barcex | 2008-03-02 (6119 days ago) |
Alpertron | 2008-02-29 (6121 days ago) |
Cromwellt | 2008-02-29 (6121 days ago) |
RedCoat | 2008-02-28 (6122 days ago) |
Sapey | 2008-02-20 (6129 days ago) |
Elisardojm | 2008-02-20 (6130 days ago) |
Lascorz | 2008-02-19 (6130 days ago) |
Rastrojo | 2008-02-19 (6131 days ago) |
Cedric31 | 2008-02-19 (6131 days ago) |
Prevert | 2008-02-16 (6134 days ago) |
Aleator | 2008-02-15 (6134 days ago) |
Zuirdj | 2008-02-15 (6134 days ago) |
Orereta | 2008-02-15 (6135 days ago) |
FrancoGG | 2008-02-11 (6139 days ago) |
Loco085 | 2008-02-10 (6140 days ago) |
Agüeybaná | 2008-02-10 (6140 days ago) |
Mtmelendez | 2008-02-08 (6142 days ago) |
TXiKi | 2008-02-08 (6142 days ago) |
SCPS | 2008-02-07 (6142 days ago) |
Toliño | 2008-02-07 (6143 days ago) |
Theklan | 2008-02-07 (6143 days ago) |
ReyBrujo | 2008-02-05 (6145 days ago) |
Vilallonga | 2008-01-30 (6151 days ago) |
Gaudio | 2008-01-25 (6156 days ago) |
AlimanRuna | 2008-01-24 (6157 days ago) |
Xtv | 2008-01-19 (6162 days ago) |
Vriullop | 2008-01-18 (6162 days ago) |
Desiphral | 2008-01-16 (6165 days ago) |
DDarkfire | 2008-01-15 (6166 days ago) |
Jove | 2008-01-08 (6173 days ago) |
Pepelopex | 2008-01-07 (6174 days ago) |
Esbardu | 2008-01-07 (6174 days ago) |
Carles | 2007-12-30 (6182 days ago) |
Celestianpower | 2007-12-30 (6182 days ago) |
RRmeta | 2007-12-30 (6182 days ago) |
Axxgreazz | 2007-12-23 (6189 days ago) |
Sobreira | 2007-12-22 (6190 days ago) |
Varano | 2007-12-18 (6193 days ago) |
Chlewey | 2007-12-17 (6195 days ago) |
Javierm | 2007-12-13 (6199 days ago) |
Kipmaster | 2007-12-10 (6202 days ago) |
Adalbertofrenesi | 2007-12-07 (6204 days ago) |
JB82 | 2007-12-06 (6206 days ago) |
Patstuart | 2007-12-04 (6208 days ago) |
Subtiempo | 2007-11-30 (6211 days ago) |
Jaranda | 2007-11-30 (6212 days ago) |
Mac | 2007-11-29 (6213 days ago) |
Lmbuga | 2007-11-28 (6213 days ago) |
Janfri | 2007-11-28 (6213 days ago) |
Banjo | 2007-11-24 (6218 days ago) |
Malvenko | 2007-11-23 (6218 days ago) |
Iradigalesc | 2007-11-23 (6219 days ago) |
Llull | 2007-11-23 (6219 days ago) |
Lohen11 | 2007-11-21 (6220 days ago) |
Vibragiel | 2007-11-20 (6221 days ago) |
Sanbec | 2007-11-20 (6222 days ago) |
Yrithinnd | 2007-11-19 (6222 days ago) |
Bdenk715 | 2007-11-14 (6228 days ago) |
Marianocecowski | 2007-11-12 (6230 days ago) |
Kuartas | 2007-11-10 (6232 days ago) |
GlimmerPhoenix | 2007-11-09 (6233 days ago) |
Fryant | 2007-11-08 (6234 days ago) |
Edub | 2007-10-28 (6245 days ago) |
Jynus | 2007-10-24 (6249 days ago) |
Prietoquilmes | 2007-10-21 (6251 days ago) |
Spangineer | 2007-10-14 (6259 days ago) |
Pcongre | 2007-10-13 (6260 days ago) |
Rodasmith | 2007-10-11 (6262 days ago) |
JorgeGG | 2007-10-08 (6265 days ago) |
Battroid | 2007-10-06 (6267 days ago) |
Morza | 2007-09-30 (6273 days ago) |
Albdallah | 2007-09-29 (6274 days ago) |
Albeiror24 | 2007-09-29 (6274 days ago) |
100 rows in set (1 min 17.61 sec)
last update: 2008-03-28 (6093 days ago)
Name | Last edit |
---|---|
Ashishbhatnagar | 2008-02-22 (6128 days ago) |
Rajeevmass | 2008-02-07 (6143 days ago) |
Eukesh | 2008-02-03 (6147 days ago) |
Shyam | 2008-01-10 (6171 days ago) |
Srikeit | 2007-12-06 (6206 days ago) |
Sanjaybafnaji | 2007-07-26 (6339 days ago) |
Mexxian | 2007-05-27 (6399 days ago) |
Spundun | 2007-03-30 (6457 days ago) |
Shreshth91 | 2007-02-16 (6499 days ago) |
Jdas07 | 2006-09-12 (6655 days ago) |
Dineshjk | 2005-08-05 (7059 days ago) |
Abhishekbh | 2005-04-21 (7165 days ago) |
12 rows in set (43.28 sec)
last update: 2008-03-28 (6093 days ago)
Name | Last edit |
---|---|
Tuinui | 2008-03-27 (6094 days ago) |
Bookman | 2008-03-27 (6094 days ago) |
Aphaia | 2008-03-27 (6094 days ago) |
Kahusi | 2008-03-26 (6095 days ago) |
Me2hero | 2008-03-26 (6095 days ago) |
Genppy | 2008-03-26 (6095 days ago) |
Kanjy | 2008-03-25 (6096 days ago) |
Ninomy | 2008-03-25 (6096 days ago) |
Kzhr | 2008-03-25 (6096 days ago) |
LERK | 2008-03-25 (6096 days ago) |
ZCU | 2008-03-24 (6097 days ago) |
ゆいしあす | 2008-03-24 (6097 days ago) |
Marine-Blue | 2008-03-22 (6099 days ago) |
Courant | 2008-03-22 (6099 days ago) |
Miya | 2008-03-20 (6101 days ago) |
Mulukhiyya | 2008-03-12 (6109 days ago) |
Mzm5zbC3 | 2008-03-11 (6110 days ago) |
Bletilla | 2008-03-08 (6113 days ago) |
Aotake | 2008-03-08 (6113 days ago) |
Widehawk | 2008-03-04 (6117 days ago) |
おはぐろ蜻蛉 | 2008-02-28 (6122 days ago) |
ネッツ | 2008-02-27 (6123 days ago) |
NJT | 2008-02-24 (6126 days ago) |
朝彦 | 2008-02-24 (6126 days ago) |
Yassie | 2008-02-21 (6129 days ago) |
辞典の虫 | 2008-02-16 (6134 days ago) |
Tommy6 | 2008-02-13 (6137 days ago) |
Peccafly | 2008-02-10 (6140 days ago) |
Uryah | 2008-02-10 (6140 days ago) |
Kstigarbha | 2008-02-03 (6147 days ago) |
Bukki | 2008-02-03 (6147 days ago) |
Bellcricket | 2008-02-02 (6147 days ago) |
Sylphie | 2008-02-01 (6149 days ago) |
Pica | 2008-02-01 (6149 days ago) |
Quatro | 2008-01-30 (6151 days ago) |
Miya.m | 2008-01-29 (6152 days ago) |
Londonbashi | 2008-01-28 (6153 days ago) |
Kickaha | 2008-01-27 (6154 days ago) |
Co.kyoto | 2008-01-27 (6154 days ago) |
Hirokun | 2008-01-27 (6154 days ago) |
Complex01 | 2008-01-27 (6154 days ago) |
千代林檎 | 2008-01-26 (6155 days ago) |
Lonicera | 2008-01-25 (6156 days ago) |
ZERBERUS | 2008-01-25 (6156 days ago) |
Hyolee2 | 2008-01-25 (6156 days ago) |
Tangotango | 2008-01-18 (6163 days ago) |
Lemonsquash | 2008-01-16 (6164 days ago) |
Knua | 2008-01-12 (6169 days ago) |
Michey.M | 2008-01-05 (6176 days ago) |
SS95 | 2007-12-27 (6184 days ago) |
Suzuyoshinine | 2007-12-21 (6191 days ago) |
Horlicks | 2007-12-21 (6191 days ago) |
Volfgang | 2007-12-16 (6196 days ago) |
Watermint | 2007-12-14 (6198 days ago) |
Schu | 2007-12-14 (6198 days ago) |
Tietew | 2007-12-10 (6202 days ago) |
Dekimasu | 2007-12-04 (6208 days ago) |
Swind | 2007-12-03 (6209 days ago) |
Kareha | 2007-12-01 (6211 days ago) |
Tamtarm | 2007-11-29 (6213 days ago) |
Clarin | 2007-11-29 (6213 days ago) |
Kasuga | 2007-11-28 (6214 days ago) |
11ChamOK | 2007-11-28 (6214 days ago) |
Kurihaya | 2007-11-28 (6214 days ago) |
Lusheeta | 2007-11-28 (6214 days ago) |
Noraneko | 2007-11-28 (6214 days ago) |
Kotodama-Reverse | 2007-11-26 (6215 days ago) |
T-coco | 2007-11-26 (6216 days ago) |
Numerike | 2007-11-26 (6216 days ago) |
霧木諒二 | 2007-11-26 (6216 days ago) |
Takot | 2007-11-25 (6217 days ago) |
Himetv | 2007-10-24 (6249 days ago) |
Remington | 2007-10-20 (6253 days ago) |
SantaClaus | 2007-09-25 (6277 days ago) |
T.Saito | 2007-09-24 (6279 days ago) |
Tiens | 2007-09-18 (6285 days ago) |
Coryjp | 2007-09-05 (6298 days ago) |
Muyo | 2007-09-03 (6300 days ago) |
Ribbon | 2007-08-16 (6318 days ago) |
Penpen | 2007-08-08 (6326 days ago) |
PiaCarrot | 2007-08-04 (6330 days ago) |
YouShow | 2007-07-27 (6337 days ago) |
Chinneeb | 2007-07-03 (6362 days ago) |
HALPHA | 2007-07-01 (6364 days ago) |
Tonync | 2007-05-17 (6409 days ago) |
Araisyohei | 2007-04-21 (6435 days ago) |
七星 | 2007-04-21 (6435 days ago) |
LQVX | 2007-04-16 (6440 days ago) |
Goncyan | 2007-04-05 (6451 days ago) |
端くれの錬金術師 | 2007-04-02 (6454 days ago) |
Matsumomushi | 2007-03-25 (6462 days ago) |
かんがへなし | 2007-03-17 (6470 days ago) |
Rocky7 | 2007-03-16 (6471 days ago) |
Lonchi** | 2007-03-09 (6478 days ago) |
っ | 2007-02-17 (6498 days ago) |
Kkkdc | 2007-02-16 (6499 days ago) |
Diagraph01 | 2007-02-06 (6509 days ago) |
Pachayachachic | 2007-02-03 (6512 days ago) |
Adr6721 | 2007-02-01 (6514 days ago) |
Su-no-G | 2007-02-01 (6514 days ago) |
100 rows in set (1 min 2.26 sec)
last update: 2008-03-28 (6093 days ago)
Name | Last edit |
---|---|
Azmi1995 | 2008-03-25 (6096 days ago) |
IDRex | 2008-03-25 (6096 days ago) |
IvanLanin | 2008-03-22 (6098 days ago) |
Mimihitam | 2008-03-19 (6102 days ago) |
Master2841 | 2008-03-08 (6113 days ago) |
Chriswaterguy | 2008-03-07 (6114 days ago) |
Borgx | 2008-03-04 (6117 days ago) |
Kandar | 2008-02-18 (6132 days ago) |
Meursault2004 | 2008-02-12 (6138 days ago) |
Dragunova | 2008-02-08 (6142 days ago) |
Hariadhi | 2007-08-03 (6331 days ago) |
Irwangatot | 2007-06-12 (6382 days ago) |
Anggoro | 2006-12-07 (6570 days ago) |
Winana | 2006-11-22 (6585 days ago) |
Anggreani | 2006-08-04 (6695 days ago) |
HarisX | 2006-05-12 (6779 days ago) |
Zaidpjd | 2005-11-20 (6952 days ago) |
Widhiantoro | 2005-11-18 (6954 days ago) |
Sudiryo | 2005-11-18 (6954 days ago) |
*drew | 2005-11-08 (6964 days ago) |
20 rows in set (51.73 sec)
last update: 2008-03-28 (6093 days ago)
Name | Last edit |
---|---|
SCriBu | 2008-02-24 (6125 days ago) |
Cuman | 2008-01-25 (6156 days ago) |
Desiphral | 2008-01-16 (6165 days ago) |
IulianU | 2008-01-14 (6167 days ago) |
AQUA | 2007-12-20 (6192 days ago) |
Romihaitza | 2007-11-27 (6215 days ago) |
BlueMonday | 2007-11-24 (6218 days ago) |
Dorothea | 2007-11-19 (6223 days ago) |
Bogdan | 2007-10-22 (6250 days ago) |
Mocu | 2007-06-09 (6385 days ago) |
Lorandka | 2007-01-05 (6540 days ago) |
TSO1D | 2006-12-01 (6575 days ago) |
Ronline | 2006-11-18 (6589 days ago) |
Dmaftei | 2006-10-05 (6633 days ago) |
Evosphere | 2006-07-14 (6716 days ago) |
Orioane | 2006-06-29 (6731 days ago) |
Victort | 2006-01-02 (6909 days ago) |
NazismIsntCool | 2005-11-06 (6966 days ago) |
18 rows in set (55.09 sec)
last update: 2008-03-28 (6093 days ago)
Name | Last edit |
---|---|
Micke | 2008-03-27 (6094 days ago) |
Robertgreer | 2008-03-26 (6094 days ago) |
M.M.S. | 2008-03-26 (6095 days ago) |
Habj | 2008-03-25 (6096 days ago) |
SvHannibal | 2008-03-24 (6097 days ago) |
Moralist | 2008-03-24 (6097 days ago) |
Boivie | 2008-03-14 (6107 days ago) |
Mikez | 2008-03-04 (6117 days ago) |
Riggwelter | 2008-02-16 (6134 days ago) |
Malhonen | 2008-02-13 (6136 days ago) |
LX | 2008-01-15 (6166 days ago) |
Skomakarn | 2008-01-07 (6174 days ago) |
Johngreen | 2007-12-04 (6208 days ago) |
RaSten | 2007-10-21 (6252 days ago) |
Pcongre | 2007-10-13 (6260 days ago) |
Klibbnisse | 2007-08-27 (6307 days ago) |
Edricson | 2007-08-09 (6325 days ago) |
Smiddle | 2007-04-21 (6435 days ago) |
Skagedal | 2007-04-01 (6454 days ago) |
Yenx | 2007-01-08 (6538 days ago) |
Kruosio | 2006-12-11 (6565 days ago) |
NERIUM | 2006-06-29 (6731 days ago) |
Jniemenmaa | 2006-06-12 (6748 days ago) |
Marsve | 2006-05-05 (6785 days ago) |
Aktalo | 2006-01-23 (6888 days ago) |
Diyako | 2006-01-17 (6894 days ago) |
Storpilot | 2005-12-12 (6930 days ago) |
Scoo | 2005-12-08 (6934 days ago) |
Qwm | 2005-11-16 (6956 days ago) |
ShineB | 2005-09-29 (7004 days ago) |
Tehvata | 2005-07-01 (7093 days ago) |
31 rows in set (3 min 51.74 sec)
last update: 2008-03-28 (6093 days ago)
Name | Last edit |
---|---|
Ahonc | 2008-03-25 (6095 days ago) |
Riwnodennyk | 2008-03-25 (6095 days ago) |
A1 | 2008-02-11 (6138 days ago) |
Ilyaroz | 2008-01-27 (6154 days ago) |
Movses | 2008-01-23 (6158 days ago) |
Yakudza | 2007-11-20 (6222 days ago) |
Minia | 2007-11-18 (6224 days ago) |
EvgenyGenkin | 2007-11-13 (6229 days ago) |
DmRodionov | 2007-08-25 (6309 days ago) |
Mikolasz | 2007-07-14 (6351 days ago) |
Hayk | 2007-07-07 (6358 days ago) |
Panas | 2007-07-01 (6364 days ago) |
Yms | 2007-04-09 (6447 days ago) |
Nevermind | 2006-12-18 (6559 days ago) |
Angryxpeh | 2006-12-14 (6562 days ago) |
AndriyK | 2006-11-24 (6583 days ago) |
Martynenka | 2006-11-08 (6599 days ago) |
Redsunrising | 2006-11-04 (6603 days ago) |
Ornil | 2006-11-03 (6604 days ago) |
Jan-ivan | 2005-11-14 (6958 days ago) |
Inetd | 2005-03-26 (7190 days ago) |
21 rows in set (1 min 55.31 sec)
last update: 2008-03-28 (6093 days ago)
Name | Last edit |
---|---|
Vinhtantran | 2008-03-27 (6094 days ago) |
Neoneurone | 2007-11-15 (6227 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 }} |