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 (5923 days ago)

Name Last edit
Spiritia 2008-03-20 (5930 days ago)
Timurberk 2008-02-04 (5975 days ago)
Daggerstab 2008-01-19 (5991 days ago)
5ko 2008-01-01 (6009 days ago)
Azimski 2007-09-19 (6113 days ago)
Nk 2007-06-28 (6196 days ago)
Vanka5 2007-05-25 (6230 days ago)
Sharkb 2007-01-21 (6354 days ago)
Bggoldie 2006-12-19 (6387 days ago)
DCLXVI 2006-08-06 (6522 days ago)
Smartech 2006-04-14 (6636 days ago)
Glimz 2006-04-02 (6648 days ago)
Espetkov 2005-06-05 (6949 days ago)

13 rows in set (56.82 sec)

last update: 2008-03-28 (5923 days ago)

Name Last edit
Bellayet 2008-03-26 (5924 days ago)
Aeetlrsk 2008-02-04 (5975 days ago)
Frdayeen 2008-01-08 (6002 days ago)
Hermitage17 2008-01-08 (6002 days ago)

4 rows in set (9.26 sec)

last update: 2008-03-28 (5923 days ago)

Name Last edit
AtteL 2008-03-25 (5925 days ago)
Str4nd 2008-03-24 (5926 days ago)
Roosa 2008-03-05 (5946 days ago)
Malhonen 2008-02-13 (5966 days ago)
Ilaiho 2007-12-25 (6016 days ago)
Argus 2007-11-12 (6059 days ago)
Jariola 2007-10-29 (6073 days ago)
Kyzyl 2007-07-16 (6178 days ago)
Skuolfi 2007-05-13 (6242 days ago)
Urvabara 2007-02-08 (6336 days ago)
Jni 2007-01-29 (6346 days ago)
NZ- 2006-12-30 (6376 days ago)
Vilu 2006-12-26 (6380 days ago)
Hartz 2006-12-15 (6391 days ago)
Mzlla 2006-12-07 (6399 days ago)
Inzulac 2006-10-31 (6436 days ago)
Lauranen 2006-10-02 (6465 days ago)
Totuus 2006-09-05 (6492 days ago)
Anchjo 2006-08-31 (6497 days ago)
Pwc 2006-08-05 (6523 days ago)
Kouluhai 2006-06-23 (6566 days ago)
Jniemenmaa 2006-06-12 (6577 days ago)
Bobet 2006-02-06 (6703 days ago)
Finlandia 2005-12-28 (6743 days ago)
Hapsiainen 2005-12-09 (6762 days ago)
Viznut 2005-07-27 (6897 days ago)
Lanahard 2005-07-21 (6903 days ago)
Rdnk 2005-05-24 (6961 days ago)

31 rows in set (55.17 sec)

last update: 2008-03-28 (5923 days ago)

Name Last edit
Spacebirdy 2008-03-27 (5923 days ago)
Bengoa 2008-03-27 (5923 days ago)
Kylu 2008-03-27 (5923 days ago)
Julie 2008-03-26 (5924 days ago)
Taichi 2008-03-26 (5924 days ago)
Ascánder 2008-03-26 (5924 days ago)
Smeira 2008-03-26 (5924 days ago)
SMP 2008-03-26 (5924 days ago)
Drini 2008-03-26 (5924 days ago)
Rdsmith4 2008-03-25 (5925 days ago)
Masterches 2008-03-25 (5925 days ago)
Wikimistusik 2008-03-25 (5925 days ago)
Mikel 2008-03-25 (5925 days ago)
Willtron 2008-03-24 (5926 days ago)
CHV 2008-03-24 (5926 days ago)
Tosão 2008-03-23 (5927 days ago)
Redux 2008-03-21 (5929 days ago)
Xic667 2008-03-21 (5929 days ago)
LaosLos 2008-03-20 (5930 days ago)
BetoCG 2008-03-17 (5933 days ago)
DamianFinol 2008-03-16 (5934 days ago)
Jurock 2008-03-13 (5937 days ago)
Oswaldo2025 2008-03-13 (5938 days ago)
Damërung 2008-03-08 (5942 days ago)
Alhen 2008-03-06 (5944 days ago)
Fajro 2008-03-04 (5946 days ago)
LadyInGrey 2008-03-03 (5947 days ago)
Barcex 2008-03-02 (5948 days ago)
Alpertron 2008-02-29 (5950 days ago)
Cromwellt 2008-02-29 (5951 days ago)
RedCoat 2008-02-28 (5951 days ago)
Sapey 2008-02-20 (5959 days ago)
Elisardojm 2008-02-20 (5959 days ago)
Lascorz 2008-02-19 (5960 days ago)
Rastrojo 2008-02-19 (5960 days ago)
Cedric31 2008-02-19 (5960 days ago)
Prevert 2008-02-16 (5963 days ago)
Aleator 2008-02-15 (5964 days ago)
Zuirdj 2008-02-15 (5964 days ago)
Orereta 2008-02-15 (5964 days ago)
FrancoGG 2008-02-11 (5968 days ago)
Loco085 2008-02-10 (5969 days ago)
Agüeybaná 2008-02-10 (5969 days ago)
Mtmelendez 2008-02-08 (5971 days ago)
TXiKi 2008-02-08 (5971 days ago)
SCPS 2008-02-07 (5972 days ago)
Toliño 2008-02-07 (5972 days ago)
Theklan 2008-02-07 (5972 days ago)
ReyBrujo 2008-02-05 (5974 days ago)
Vilallonga 2008-01-30 (5980 days ago)
Gaudio 2008-01-25 (5985 days ago)
AlimanRuna 2008-01-24 (5986 days ago)
Xtv 2008-01-19 (5991 days ago)
Vriullop 2008-01-18 (5992 days ago)
Desiphral 2008-01-16 (5994 days ago)
DDarkfire 2008-01-15 (5996 days ago)
Jove 2008-01-08 (6003 days ago)
Pepelopex 2008-01-07 (6003 days ago)
Esbardu 2008-01-07 (6003 days ago)
Carles 2007-12-30 (6011 days ago)
Celestianpower 2007-12-30 (6011 days ago)
RRmeta 2007-12-30 (6012 days ago)
Axxgreazz 2007-12-23 (6018 days ago)
Sobreira 2007-12-22 (6019 days ago)
Varano 2007-12-18 (6023 days ago)
Chlewey 2007-12-17 (6024 days ago)
Javierm 2007-12-13 (6028 days ago)
Kipmaster 2007-12-10 (6031 days ago)
Adalbertofrenesi 2007-12-07 (6034 days ago)
JB82 2007-12-06 (6036 days ago)
Patstuart 2007-12-04 (6037 days ago)
Subtiempo 2007-11-30 (6041 days ago)
Jaranda 2007-11-30 (6041 days ago)
Mac 2007-11-29 (6042 days ago)
Lmbuga 2007-11-28 (6043 days ago)
Janfri 2007-11-28 (6043 days ago)
Banjo 2007-11-24 (6047 days ago)
Malvenko 2007-11-23 (6048 days ago)
Iradigalesc 2007-11-23 (6048 days ago)
Llull 2007-11-23 (6048 days ago)
Lohen11 2007-11-21 (6050 days ago)
Vibragiel 2007-11-20 (6051 days ago)
Sanbec 2007-11-20 (6051 days ago)
Yrithinnd 2007-11-19 (6052 days ago)
Bdenk715 2007-11-14 (6057 days ago)
Marianocecowski 2007-11-12 (6059 days ago)
Kuartas 2007-11-10 (6061 days ago)
GlimmerPhoenix 2007-11-09 (6062 days ago)
Fryant 2007-11-08 (6063 days ago)
Edub 2007-10-28 (6074 days ago)
Jynus 2007-10-24 (6078 days ago)
Prietoquilmes 2007-10-21 (6081 days ago)
Spangineer 2007-10-14 (6088 days ago)
Pcongre 2007-10-13 (6089 days ago)
Rodasmith 2007-10-11 (6091 days ago)
JorgeGG 2007-10-08 (6094 days ago)
Battroid 2007-10-06 (6097 days ago)
Morza 2007-09-30 (6102 days ago)
Albdallah 2007-09-29 (6103 days ago)
Albeiror24 2007-09-29 (6103 days ago)

100 rows in set (1 min 17.61 sec)

last update: 2008-03-28 (5923 days ago)

Name Last edit
Ashishbhatnagar 2008-02-22 (5957 days ago)
Rajeevmass 2008-02-07 (5972 days ago)
Eukesh 2008-02-03 (5976 days ago)
Shyam 2008-01-10 (6000 days ago)
Srikeit 2007-12-06 (6035 days ago)
Sanjaybafnaji 2007-07-26 (6168 days ago)
Mexxian 2007-05-27 (6228 days ago)
Spundun 2007-03-30 (6286 days ago)
Shreshth91 2007-02-16 (6328 days ago)
Jdas07 2006-09-12 (6485 days ago)
Dineshjk 2005-08-05 (6888 days ago)
Abhishekbh 2005-04-21 (6994 days ago)

12 rows in set (43.28 sec)

last update: 2008-03-28 (5923 days ago)

Name Last edit
Tuinui 2008-03-27 (5923 days ago)
Bookman 2008-03-27 (5923 days ago)
Aphaia 2008-03-27 (5923 days ago)
Kahusi 2008-03-26 (5924 days ago)
Me2hero 2008-03-26 (5924 days ago)
Genppy 2008-03-26 (5924 days ago)
Kanjy 2008-03-25 (5925 days ago)
Ninomy 2008-03-25 (5925 days ago)
Kzhr 2008-03-25 (5925 days ago)
LERK 2008-03-25 (5925 days ago)
ZCU 2008-03-24 (5926 days ago)
ゆいしあす 2008-03-24 (5926 days ago)
Marine-Blue 2008-03-22 (5928 days ago)
Courant 2008-03-22 (5928 days ago)
Miya 2008-03-20 (5930 days ago)
Mulukhiyya 2008-03-12 (5938 days ago)
Mzm5zbC3 2008-03-11 (5939 days ago)
Bletilla 2008-03-08 (5942 days ago)
Aotake 2008-03-08 (5942 days ago)
Widehawk 2008-03-04 (5947 days ago)
おはぐろ蜻蛉 2008-02-28 (5951 days ago)
ネッツ 2008-02-27 (5952 days ago)
NJT 2008-02-24 (5955 days ago)
朝彦 2008-02-24 (5956 days ago)
Yassie 2008-02-21 (5958 days ago)
辞典の虫 2008-02-16 (5964 days ago)
Tommy6 2008-02-13 (5966 days ago)
Peccafly 2008-02-10 (5969 days ago)
Uryah 2008-02-10 (5969 days ago)
Kstigarbha 2008-02-03 (5976 days ago)
Bukki 2008-02-03 (5977 days ago)
Bellcricket 2008-02-02 (5977 days ago)
Sylphie 2008-02-01 (5978 days ago)
Pica 2008-02-01 (5978 days ago)
Quatro 2008-01-30 (5980 days ago)
Miya.m 2008-01-29 (5981 days ago)
Londonbashi 2008-01-28 (5982 days ago)
Kickaha 2008-01-27 (5983 days ago)
Co.kyoto 2008-01-27 (5983 days ago)
Hirokun 2008-01-27 (5983 days ago)
Complex01 2008-01-27 (5983 days ago)
千代林檎 2008-01-26 (5984 days ago)
Lonicera 2008-01-25 (5985 days ago)
ZERBERUS 2008-01-25 (5985 days ago)
Hyolee2 2008-01-25 (5985 days ago)
Tangotango 2008-01-18 (5992 days ago)
Lemonsquash 2008-01-16 (5994 days ago)
Knua 2008-01-12 (5998 days ago)
Michey.M 2008-01-05 (6005 days ago)
SS95 2007-12-27 (6014 days ago)
Suzuyoshinine 2007-12-21 (6020 days ago)
Horlicks 2007-12-21 (6020 days ago)
Volfgang 2007-12-16 (6025 days ago)
Watermint 2007-12-14 (6027 days ago)
Schu 2007-12-14 (6027 days ago)
Tietew 2007-12-10 (6031 days ago)
Dekimasu 2007-12-04 (6037 days ago)
Swind 2007-12-03 (6038 days ago)
Kareha 2007-12-01 (6040 days ago)
Tamtarm 2007-11-29 (6042 days ago)
Clarin 2007-11-29 (6042 days ago)
Kasuga 2007-11-28 (6043 days ago)
11ChamOK 2007-11-28 (6043 days ago)
Kurihaya 2007-11-28 (6043 days ago)
Lusheeta 2007-11-28 (6043 days ago)
Noraneko 2007-11-28 (6044 days ago)
Kotodama-Reverse 2007-11-26 (6045 days ago)
T-coco 2007-11-26 (6045 days ago)
Numerike 2007-11-26 (6045 days ago)
霧木諒二 2007-11-26 (6045 days ago)
Takot 2007-11-25 (6046 days ago)
Himetv 2007-10-24 (6078 days ago)
Remington 2007-10-20 (6082 days ago)
SantaClaus 2007-09-25 (6107 days ago)
T.Saito 2007-09-24 (6108 days ago)
Tiens 2007-09-18 (6114 days ago)
Coryjp 2007-09-05 (6127 days ago)
Muyo 2007-09-03 (6129 days ago)
Ribbon 2007-08-16 (6147 days ago)
Penpen 2007-08-08 (6156 days ago)
PiaCarrot 2007-08-04 (6159 days ago)
YouShow 2007-07-27 (6167 days ago)
Chinneeb 2007-07-03 (6191 days ago)
HALPHA 2007-07-01 (6193 days ago)
Tonync 2007-05-17 (6238 days ago)
Araisyohei 2007-04-21 (6264 days ago)
七星 2007-04-21 (6264 days ago)
LQVX 2007-04-16 (6270 days ago)
Goncyan 2007-04-05 (6280 days ago)
端くれの錬金術師 2007-04-02 (6283 days ago)
Matsumomushi 2007-03-25 (6291 days ago)
かんがへなし 2007-03-17 (6299 days ago)
Rocky7 2007-03-16 (6300 days ago)
Lonchi** 2007-03-09 (6307 days ago)
2007-02-17 (6327 days ago)
Kkkdc 2007-02-16 (6328 days ago)
Diagraph01 2007-02-06 (6338 days ago)
Pachayachachic 2007-02-03 (6341 days ago)
Adr6721 2007-02-01 (6343 days ago)
Su-no-G 2007-02-01 (6343 days ago)

100 rows in set (1 min 2.26 sec)

last update: 2008-03-28 (5923 days ago)

Name Last edit
Azmi1995 2008-03-25 (5925 days ago)
IDRex 2008-03-25 (5925 days ago)
IvanLanin 2008-03-22 (5928 days ago)
Mimihitam 2008-03-19 (5931 days ago)
Master2841 2008-03-08 (5942 days ago)
Chriswaterguy 2008-03-07 (5944 days ago)
Borgx 2008-03-04 (5947 days ago)
Kandar 2008-02-18 (5961 days ago)
Meursault2004 2008-02-12 (5967 days ago)
Dragunova 2008-02-08 (5971 days ago)
Hariadhi 2007-08-03 (6160 days ago)
Irwangatot 2007-06-12 (6212 days ago)
Anggoro 2006-12-07 (6399 days ago)
Winana 2006-11-22 (6414 days ago)
Anggreani 2006-08-04 (6524 days ago)
HarisX 2006-05-12 (6608 days ago)
Zaidpjd 2005-11-20 (6781 days ago)
Widhiantoro 2005-11-18 (6783 days ago)
Sudiryo 2005-11-18 (6783 days ago)
*drew 2005-11-08 (6793 days ago)

20 rows in set (51.73 sec)

last update: 2008-03-28 (5923 days ago)

Name Last edit
SCriBu 2008-02-24 (5955 days ago)
Cuman 2008-01-25 (5985 days ago)
Desiphral 2008-01-16 (5994 days ago)
IulianU 2008-01-14 (5996 days ago)
AQUA 2007-12-20 (6021 days ago)
Romihaitza 2007-11-27 (6044 days ago)
BlueMonday 2007-11-24 (6047 days ago)
Dorothea 2007-11-19 (6052 days ago)
Bogdan 2007-10-22 (6080 days ago)
Mocu 2007-06-09 (6215 days ago)
Lorandka 2007-01-05 (6370 days ago)
TSO1D 2006-12-01 (6405 days ago)
Ronline 2006-11-18 (6419 days ago)
Dmaftei 2006-10-05 (6463 days ago)
Evosphere 2006-07-14 (6545 days ago)
Orioane 2006-06-29 (6560 days ago)
Victort 2006-01-02 (6738 days ago)
NazismIsntCool 2005-11-06 (6795 days ago)

18 rows in set (55.09 sec)

last update: 2008-03-28 (5923 days ago)

Name Last edit
Micke 2008-03-27 (5923 days ago)
Robertgreer 2008-03-26 (5924 days ago)
M.M.S. 2008-03-26 (5924 days ago)
Habj 2008-03-25 (5925 days ago)
SvHannibal 2008-03-24 (5926 days ago)
Moralist 2008-03-24 (5926 days ago)
Boivie 2008-03-14 (5936 days ago)
Mikez 2008-03-04 (5947 days ago)
Riggwelter 2008-02-16 (5963 days ago)
Malhonen 2008-02-13 (5966 days ago)
LX 2008-01-15 (5995 days ago)
Skomakarn 2008-01-07 (6004 days ago)
Johngreen 2007-12-04 (6037 days ago)
RaSten 2007-10-21 (6081 days ago)
Pcongre 2007-10-13 (6089 days ago)
Klibbnisse 2007-08-27 (6136 days ago)
Edricson 2007-08-09 (6154 days ago)
Smiddle 2007-04-21 (6264 days ago)
Skagedal 2007-04-01 (6284 days ago)
Yenx 2007-01-08 (6367 days ago)
Kruosio 2006-12-11 (6395 days ago)
NERIUM 2006-06-29 (6561 days ago)
Jniemenmaa 2006-06-12 (6577 days ago)
Marsve 2006-05-05 (6615 days ago)
Aktalo 2006-01-23 (6717 days ago)
Diyako 2006-01-17 (6723 days ago)
Storpilot 2005-12-12 (6759 days ago)
Scoo 2005-12-08 (6763 days ago)
Qwm 2005-11-16 (6786 days ago)
ShineB 2005-09-29 (6833 days ago)
Tehvata 2005-07-01 (6923 days ago)

31 rows in set (3 min 51.74 sec)

last update: 2008-03-28 (5923 days ago)

Name Last edit
Ahonc 2008-03-25 (5925 days ago)
Riwnodennyk 2008-03-25 (5925 days ago)
A1 2008-02-11 (5968 days ago)
Ilyaroz 2008-01-27 (5983 days ago)
Movses 2008-01-23 (5987 days ago)
Yakudza 2007-11-20 (6051 days ago)
Minia 2007-11-18 (6053 days ago)
EvgenyGenkin 2007-11-13 (6058 days ago)
DmRodionov 2007-08-25 (6138 days ago)
Mikolasz 2007-07-14 (6180 days ago)
Hayk 2007-07-07 (6187 days ago)
Panas 2007-07-01 (6193 days ago)
Yms 2007-04-09 (6276 days ago)
Nevermind 2006-12-18 (6388 days ago)
Angryxpeh 2006-12-14 (6392 days ago)
AndriyK 2006-11-24 (6412 days ago)
Martynenka 2006-11-08 (6428 days ago)
Redsunrising 2006-11-04 (6432 days ago)
Ornil 2006-11-03 (6433 days ago)
Jan-ivan 2005-11-14 (6787 days ago)
Inetd 2005-03-26 (7020 days ago)

21 rows in set (1 min 55.31 sec)

last update: 2008-03-28 (5923 days ago)

Name Last edit
Vinhtantran 2008-03-27 (5923 days ago)
Neoneurone 2007-11-15 (6056 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
}}