User:Pathoschild/Translators by activity

From Meta, a Wikimedia project coordination wiki
Jump to: navigation, search

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

Name Last edit
Spiritia 2008-03-20 (3024 days ago)
Timurberk 2008-02-04 (3069 days ago)
Daggerstab 2008-01-19 (3085 days ago)
5ko 2008-01-01 (3103 days ago)
Azimski 2007-09-19 (3207 days ago)
Nk 2007-06-28 (3290 days ago)
Vanka5 2007-05-25 (3325 days ago)
Sharkb 2007-01-21 (3448 days ago)
Bggoldie 2006-12-19 (3481 days ago)
DCLXVI 2006-08-06 (3616 days ago)
Smartech 2006-04-14 (3730 days ago)
Glimz 2006-04-02 (3742 days ago)
Espetkov 2005-06-05 (4043 days ago)

13 rows in set (56.82 sec)

bn/Bengali[edit]

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

Name Last edit
Bellayet 2008-03-26 (3018 days ago)
Aeetlrsk 2008-02-04 (3069 days ago)
Frdayeen 2008-01-08 (3096 days ago)
Hermitage17 2008-01-08 (3097 days ago)

4 rows in set (9.26 sec)

fi/Finnish[edit]

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

Name Last edit
AtteL 2008-03-25 (3019 days ago)
Str4nd 2008-03-24 (3020 days ago)
Roosa 2008-03-05 (3040 days ago)
Malhonen 2008-02-13 (3060 days ago)
Ilaiho 2007-12-25 (3110 days ago)
Argus 2007-11-12 (3153 days ago)
Jariola 2007-10-29 (3167 days ago)
Kyzyl 2007-07-16 (3273 days ago)
Skuolfi 2007-05-13 (3336 days ago)
Urvabara 2007-02-08 (3430 days ago)
Jni 2007-01-29 (3440 days ago)
NZ- 2006-12-30 (3470 days ago)
Vilu 2006-12-26 (3474 days ago)
Hartz 2006-12-15 (3485 days ago)
Mzlla 2006-12-07 (3493 days ago)
Inzulac 2006-10-31 (3530 days ago)
Lauranen 2006-10-02 (3559 days ago)
Totuus 2006-09-05 (3586 days ago)
Anchjo 2006-08-31 (3591 days ago)
Pwc 2006-08-05 (3617 days ago)
Kouluhai 2006-06-23 (3660 days ago)
Jniemenmaa 2006-06-12 (3671 days ago)
Bobet 2006-02-06 (3797 days ago)
Finlandia 2005-12-28 (3837 days ago)
Hapsiainen 2005-12-09 (3856 days ago)
Viznut 2005-07-27 (3992 days ago)
Lanahard 2005-07-21 (3997 days ago)
Rdnk 2005-05-24 (4055 days ago)

31 rows in set (55.17 sec)

es/Spanish[edit]

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

Name Last edit
Spacebirdy 2008-03-27 (3017 days ago)
Bengoa 2008-03-27 (3017 days ago)
Kylu 2008-03-27 (3018 days ago)
Julie 2008-03-26 (3018 days ago)
Taichi 2008-03-26 (3018 days ago)
Ascánder 2008-03-26 (3018 days ago)
Smeira 2008-03-26 (3018 days ago)
SMP 2008-03-26 (3018 days ago)
Drini 2008-03-26 (3018 days ago)
Rdsmith4 2008-03-25 (3019 days ago)
Masterches 2008-03-25 (3020 days ago)
Wikimistusik 2008-03-25 (3020 days ago)
Mikel 2008-03-25 (3020 days ago)
Willtron 2008-03-24 (3020 days ago)
CHV 2008-03-24 (3020 days ago)
Tosão 2008-03-23 (3021 days ago)
Redux 2008-03-21 (3023 days ago)
Xic667 2008-03-21 (3023 days ago)
LaosLos 2008-03-20 (3024 days ago)
BetoCG 2008-03-17 (3027 days ago)
DamianFinol 2008-03-16 (3029 days ago)
Jurock 2008-03-13 (3031 days ago)
Oswaldo2025 2008-03-13 (3032 days ago)
Damërung 2008-03-08 (3036 days ago)
Alhen 2008-03-06 (3038 days ago)
Fajro 2008-03-04 (3041 days ago)
LadyInGrey 2008-03-03 (3041 days ago)
Barcex 2008-03-02 (3042 days ago)
Alpertron 2008-02-29 (3044 days ago)
Cromwellt 2008-02-29 (3045 days ago)
RedCoat 2008-02-28 (3045 days ago)
Sapey 2008-02-20 (3053 days ago)
Elisardojm 2008-02-20 (3053 days ago)
Lascorz 2008-02-19 (3054 days ago)
Rastrojo 2008-02-19 (3054 days ago)
Cedric31 2008-02-19 (3054 days ago)
Prevert 2008-02-16 (3057 days ago)
Aleator 2008-02-15 (3058 days ago)
Zuirdj 2008-02-15 (3058 days ago)
Orereta 2008-02-15 (3058 days ago)
FrancoGG 2008-02-11 (3062 days ago)
Loco085 2008-02-10 (3063 days ago)
Agüeybaná 2008-02-10 (3063 days ago)
Mtmelendez 2008-02-08 (3065 days ago)
TXiKi 2008-02-08 (3066 days ago)
SCPS 2008-02-07 (3066 days ago)
Toliño 2008-02-07 (3066 days ago)
Theklan 2008-02-07 (3066 days ago)
ReyBrujo 2008-02-05 (3069 days ago)
Vilallonga 2008-01-30 (3074 days ago)
Gaudio 2008-01-25 (3079 days ago)
AlimanRuna 2008-01-24 (3080 days ago)
Xtv 2008-01-19 (3085 days ago)
Vriullop 2008-01-18 (3086 days ago)
Desiphral 2008-01-16 (3088 days ago)
DDarkfire 2008-01-15 (3090 days ago)
Jove 2008-01-08 (3097 days ago)
Pepelopex 2008-01-07 (3097 days ago)
Esbardu 2008-01-07 (3098 days ago)
Carles 2007-12-30 (3105 days ago)
Celestianpower 2007-12-30 (3105 days ago)
RRmeta 2007-12-30 (3106 days ago)
Axxgreazz 2007-12-23 (3113 days ago)
Sobreira 2007-12-22 (3113 days ago)
Varano 2007-12-18 (3117 days ago)
Chlewey 2007-12-17 (3118 days ago)
Javierm 2007-12-13 (3122 days ago)
Kipmaster 2007-12-10 (3125 days ago)
Adalbertofrenesi 2007-12-07 (3128 days ago)
JB82 2007-12-06 (3130 days ago)
Patstuart 2007-12-04 (3132 days ago)
Subtiempo 2007-11-30 (3135 days ago)
Jaranda 2007-11-30 (3135 days ago)
Mac 2007-11-29 (3136 days ago)
Lmbuga 2007-11-28 (3137 days ago)
Janfri 2007-11-28 (3137 days ago)
Banjo 2007-11-24 (3141 days ago)
Malvenko 2007-11-23 (3142 days ago)
Iradigalesc 2007-11-23 (3142 days ago)
Llull 2007-11-23 (3142 days ago)
Lohen11 2007-11-21 (3144 days ago)
Vibragiel 2007-11-20 (3145 days ago)
Sanbec 2007-11-20 (3145 days ago)
Yrithinnd 2007-11-19 (3146 days ago)
Bdenk715 2007-11-14 (3152 days ago)
Marianocecowski 2007-11-12 (3153 days ago)
Kuartas 2007-11-10 (3155 days ago)
GlimmerPhoenix 2007-11-09 (3156 days ago)
Fryant 2007-11-08 (3157 days ago)
Edub 2007-10-28 (3168 days ago)
Jynus 2007-10-24 (3172 days ago)
Prietoquilmes 2007-10-21 (3175 days ago)
Spangineer 2007-10-14 (3182 days ago)
Pcongre 2007-10-13 (3184 days ago)
Rodasmith 2007-10-11 (3185 days ago)
JorgeGG 2007-10-08 (3188 days ago)
Battroid 2007-10-06 (3191 days ago)
Morza 2007-09-30 (3196 days ago)
Albdallah 2007-09-29 (3197 days ago)
Albeiror24 2007-09-29 (3198 days ago)

100 rows in set (1 min 17.61 sec)

hi/Hindi[edit]

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

Name Last edit
Ashishbhatnagar 2008-02-22 (3052 days ago)
Rajeevmass 2008-02-07 (3066 days ago)
Eukesh 2008-02-03 (3070 days ago)
Shyam 2008-01-10 (3095 days ago)
Srikeit 2007-12-06 (3129 days ago)
Sanjaybafnaji 2007-07-26 (3262 days ago)
Mexxian 2007-05-27 (3322 days ago)
Spundun 2007-03-30 (3380 days ago)
Shreshth91 2007-02-16 (3423 days ago)
Jdas07 2006-09-12 (3579 days ago)
Dineshjk 2005-08-05 (3982 days ago)
Abhishekbh 2005-04-21 (4089 days ago)

12 rows in set (43.28 sec)

ja/Japanese[edit]

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

Name Last edit
Tuinui 2008-03-27 (3018 days ago)
Bookman 2008-03-27 (3018 days ago)
Aphaia 2008-03-27 (3018 days ago)
Kahusi 2008-03-26 (3018 days ago)
Me2hero 2008-03-26 (3018 days ago)
Genppy 2008-03-26 (3019 days ago)
Kanjy 2008-03-25 (3019 days ago)
Ninomy 2008-03-25 (3019 days ago)
Kzhr 2008-03-25 (3019 days ago)
LERK 2008-03-25 (3019 days ago)
ZCU 2008-03-24 (3020 days ago)
ゆいしあす 2008-03-24 (3020 days ago)
Marine-Blue 2008-03-22 (3023 days ago)
Courant 2008-03-22 (3023 days ago)
Miya 2008-03-20 (3025 days ago)
Mulukhiyya 2008-03-12 (3032 days ago)
Mzm5zbC3 2008-03-11 (3033 days ago)
Bletilla 2008-03-08 (3036 days ago)
Aotake 2008-03-08 (3037 days ago)
Widehawk 2008-03-04 (3041 days ago)
おはぐろ蜻蛉 2008-02-28 (3045 days ago)
ネッツ 2008-02-27 (3046 days ago)
NJT 2008-02-24 (3050 days ago)
朝彦 2008-02-24 (3050 days ago)
Yassie 2008-02-21 (3052 days ago)
辞典の虫 2008-02-16 (3058 days ago)
Tommy6 2008-02-13 (3061 days ago)
Peccafly 2008-02-10 (3063 days ago)
Uryah 2008-02-10 (3064 days ago)
Kstigarbha 2008-02-03 (3070 days ago)
Bukki 2008-02-03 (3071 days ago)
Bellcricket 2008-02-02 (3071 days ago)
Sylphie 2008-02-01 (3072 days ago)
Pica 2008-02-01 (3073 days ago)
Quatro 2008-01-30 (3074 days ago)
Miya.m 2008-01-29 (3075 days ago)
Londonbashi 2008-01-28 (3076 days ago)
Kickaha 2008-01-27 (3077 days ago)
Co.kyoto 2008-01-27 (3077 days ago)
Hirokun 2008-01-27 (3077 days ago)
Complex01 2008-01-27 (3078 days ago)
千代林檎 2008-01-26 (3079 days ago)
Lonicera 2008-01-25 (3079 days ago)
ZERBERUS 2008-01-25 (3079 days ago)
Hyolee2 2008-01-25 (3080 days ago)
Tangotango 2008-01-18 (3086 days ago)
Lemonsquash 2008-01-16 (3088 days ago)
Knua 2008-01-12 (3092 days ago)
Michey.M 2008-01-05 (3099 days ago)
SS95 2007-12-27 (3108 days ago)
Suzuyoshinine 2007-12-21 (3114 days ago)
Horlicks 2007-12-21 (3115 days ago)
Volfgang 2007-12-16 (3119 days ago)
Watermint 2007-12-14 (3121 days ago)
Schu 2007-12-14 (3122 days ago)
Tietew 2007-12-10 (3126 days ago)
Dekimasu 2007-12-04 (3132 days ago)
Swind 2007-12-03 (3133 days ago)
Kareha 2007-12-01 (3134 days ago)
Tamtarm 2007-11-29 (3136 days ago)
Clarin 2007-11-29 (3137 days ago)
Kasuga 2007-11-28 (3137 days ago)
11ChamOK 2007-11-28 (3137 days ago)
Kurihaya 2007-11-28 (3137 days ago)
Lusheeta 2007-11-28 (3137 days ago)
Noraneko 2007-11-28 (3138 days ago)
Kotodama-Reverse 2007-11-26 (3139 days ago)
T-coco 2007-11-26 (3139 days ago)
Numerike 2007-11-26 (3139 days ago)
霧木諒二 2007-11-26 (3139 days ago)
Takot 2007-11-25 (3140 days ago)
Himetv 2007-10-24 (3173 days ago)
Remington 2007-10-20 (3176 days ago)
SantaClaus 2007-09-25 (3201 days ago)
T.Saito 2007-09-24 (3202 days ago)
Tiens 2007-09-18 (3209 days ago)
Coryjp 2007-09-05 (3221 days ago)
Muyo 2007-09-03 (3223 days ago)
Ribbon 2007-08-16 (3242 days ago)
Penpen 2007-08-08 (3250 days ago)
PiaCarrot 2007-08-04 (3253 days ago)
YouShow 2007-07-27 (3261 days ago)
Chinneeb 2007-07-03 (3286 days ago)
HALPHA 2007-07-01 (3287 days ago)
Tonync 2007-05-17 (3332 days ago)
Araisyohei 2007-04-21 (3358 days ago)
七星 2007-04-21 (3359 days ago)
LQVX 2007-04-16 (3364 days ago)
Goncyan 2007-04-05 (3375 days ago)
端くれの錬金術師 2007-04-02 (3377 days ago)
Matsumomushi 2007-03-25 (3386 days ago)
かんがへなし 2007-03-17 (3394 days ago)
Rocky7 2007-03-16 (3394 days ago)
Lonchi** 2007-03-09 (3402 days ago)
2007-02-17 (3421 days ago)
Kkkdc 2007-02-16 (3422 days ago)
Diagraph01 2007-02-06 (3432 days ago)
Pachayachachic 2007-02-03 (3436 days ago)
Adr6721 2007-02-01 (3438 days ago)
Su-no-G 2007-02-01 (3438 days ago)

100 rows in set (1 min 2.26 sec)

id/Bahasa Indonesian[edit]

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

Name Last edit
Azmi1995 2008-03-25 (3020 days ago)
IDRex 2008-03-25 (3020 days ago)
IvanLanin 2008-03-22 (3022 days ago)
Mimihitam 2008-03-19 (3025 days ago)
Master2841 2008-03-08 (3036 days ago)
Chriswaterguy 2008-03-07 (3038 days ago)
Borgx 2008-03-04 (3041 days ago)
Kandar 2008-02-18 (3055 days ago)
Meursault2004 2008-02-12 (3061 days ago)
Dragunova 2008-02-08 (3065 days ago)
Hariadhi 2007-08-03 (3255 days ago)
Irwangatot 2007-06-12 (3306 days ago)
Anggoro 2006-12-07 (3494 days ago)
Winana 2006-11-22 (3508 days ago)
Anggreani 2006-08-04 (3619 days ago)
HarisX 2006-05-12 (3703 days ago)
Zaidpjd 2005-11-20 (3875 days ago)
Widhiantoro 2005-11-18 (3878 days ago)
Sudiryo 2005-11-18 (3878 days ago)
*drew 2005-11-08 (3888 days ago)

20 rows in set (51.73 sec)

ro/Romanian[edit]

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

Name Last edit
SCriBu 2008-02-24 (3049 days ago)
Cuman 2008-01-25 (3079 days ago)
Desiphral 2008-01-16 (3088 days ago)
IulianU 2008-01-14 (3090 days ago)
AQUA 2007-12-20 (3115 days ago)
Romihaitza 2007-11-27 (3138 days ago)
BlueMonday 2007-11-24 (3141 days ago)
Dorothea 2007-11-19 (3146 days ago)
Bogdan 2007-10-22 (3174 days ago)
Mocu 2007-06-09 (3309 days ago)
Lorandka 2007-01-05 (3464 days ago)
TSO1D 2006-12-01 (3499 days ago)
Ronline 2006-11-18 (3513 days ago)
Dmaftei 2006-10-05 (3557 days ago)
Evosphere 2006-07-14 (3639 days ago)
Orioane 2006-06-29 (3654 days ago)
Victort 2006-01-02 (3833 days ago)
NazismIsntCool 2005-11-06 (3890 days ago)

18 rows in set (55.09 sec)

sv/Swedish[edit]

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

Name Last edit
Micke 2008-03-27 (3017 days ago)
Robertgreer 2008-03-26 (3018 days ago)
M.M.S. 2008-03-26 (3018 days ago)
Habj 2008-03-25 (3019 days ago)
SvHannibal 2008-03-24 (3020 days ago)
Moralist 2008-03-24 (3020 days ago)
Boivie 2008-03-14 (3030 days ago)
Mikez 2008-03-04 (3041 days ago)
Riggwelter 2008-02-16 (3057 days ago)
Malhonen 2008-02-13 (3060 days ago)
LX 2008-01-15 (3089 days ago)
Skomakarn 2008-01-07 (3098 days ago)
Johngreen 2007-12-04 (3131 days ago)
RaSten 2007-10-21 (3175 days ago)
Pcongre 2007-10-13 (3184 days ago)
Klibbnisse 2007-08-27 (3230 days ago)
Edricson 2007-08-09 (3248 days ago)
Smiddle 2007-04-21 (3358 days ago)
Skagedal 2007-04-01 (3378 days ago)
Yenx 2007-01-08 (3461 days ago)
Kruosio 2006-12-11 (3489 days ago)
NERIUM 2006-06-29 (3655 days ago)
Jniemenmaa 2006-06-12 (3671 days ago)
Marsve 2006-05-05 (3709 days ago)
Aktalo 2006-01-23 (3811 days ago)
Diyako 2006-01-17 (3818 days ago)
Storpilot 2005-12-12 (3853 days ago)
Scoo 2005-12-08 (3857 days ago)
Qwm 2005-11-16 (3880 days ago)
ShineB 2005-09-29 (3927 days ago)
Tehvata 2005-07-01 (4017 days ago)

31 rows in set (3 min 51.74 sec)

uk/Ukrainian[edit]

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

Name Last edit
Ahonc 2008-03-25 (3019 days ago)
Riwnodennyk 2008-03-25 (3019 days ago)
A1 2008-02-11 (3062 days ago)
Ilyaroz 2008-01-27 (3078 days ago)
Movses 2008-01-23 (3081 days ago)
Yakudza 2007-11-20 (3145 days ago)
Minia 2007-11-18 (3147 days ago)
EvgenyGenkin 2007-11-13 (3152 days ago)
DmRodionov 2007-08-25 (3232 days ago)
Mikolasz 2007-07-14 (3274 days ago)
Hayk 2007-07-07 (3281 days ago)
Panas 2007-07-01 (3287 days ago)
Yms 2007-04-09 (3370 days ago)
Nevermind 2006-12-18 (3482 days ago)
Angryxpeh 2006-12-14 (3486 days ago)
AndriyK 2006-11-24 (3506 days ago)
Martynenka 2006-11-08 (3522 days ago)
Redsunrising 2006-11-04 (3526 days ago)
Ornil 2006-11-03 (3527 days ago)
Jan-ivan 2005-11-14 (3881 days ago)
Inetd 2005-03-26 (4114 days ago)

21 rows in set (1 min 55.31 sec)

vi/Vietnamese[edit]

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

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