User:Pathoschild/Translators by activity
From Meta, a Wikimedia project coordination wiki
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.
Contents
Lists[edit]
bg/Bulgarian[edit]
last update: 2008-03-28 (2199 days ago)
| Name | Last edit |
|---|---|
| Spiritia | 2008-03-20 (2206 days ago) |
| Timurberk | 2008-02-04 (2251 days ago) |
| Daggerstab | 2008-01-19 (2267 days ago) |
| 5ko | 2008-01-01 (2285 days ago) |
| Azimski | 2007-09-19 (2389 days ago) |
| Nk | 2007-06-28 (2473 days ago) |
| Vanka5 | 2007-05-25 (2507 days ago) |
| Sharkb | 2007-01-21 (2630 days ago) |
| Bggoldie | 2006-12-19 (2664 days ago) |
| DCLXVI | 2006-08-06 (2798 days ago) |
| Smartech | 2006-04-14 (2912 days ago) |
| Glimz | 2006-04-02 (2925 days ago) |
| Espetkov | 2005-06-05 (3226 days ago) |
13 rows in set (56.82 sec)
bn/Bengali[edit]
last update: 2008-03-28 (2199 days ago)
| Name | Last edit |
|---|---|
| Bellayet | 2008-03-26 (2200 days ago) |
| Aeetlrsk | 2008-02-04 (2251 days ago) |
| Frdayeen | 2008-01-08 (2278 days ago) |
| Hermitage17 | 2008-01-08 (2279 days ago) |
4 rows in set (9.26 sec)
fi/Finnish[edit]
last update: 2008-03-28 (2199 days ago)
| Name | Last edit |
|---|---|
| AtteL | 2008-03-25 (2201 days ago) |
| Str4nd | 2008-03-24 (2202 days ago) |
| Roosa | 2008-03-05 (2222 days ago) |
| Malhonen | 2008-02-13 (2242 days ago) |
| Ilaiho | 2007-12-25 (2292 days ago) |
| Argus | 2007-11-12 (2336 days ago) |
| Jariola | 2007-10-29 (2350 days ago) |
| Kyzyl | 2007-07-16 (2455 days ago) |
| Skuolfi | 2007-05-13 (2519 days ago) |
| Urvabara | 2007-02-08 (2612 days ago) |
| Jni | 2007-01-29 (2623 days ago) |
| NZ- | 2006-12-30 (2652 days ago) |
| Vilu | 2006-12-26 (2656 days ago) |
| Hartz | 2006-12-15 (2667 days ago) |
| Mzlla | 2006-12-07 (2675 days ago) |
| Inzulac | 2006-10-31 (2712 days ago) |
| Lauranen | 2006-10-02 (2741 days ago) |
| Totuus | 2006-09-05 (2768 days ago) |
| Anchjo | 2006-08-31 (2773 days ago) |
| Pwc | 2006-08-05 (2799 days ago) |
| Kouluhai | 2006-06-23 (2842 days ago) |
| Jniemenmaa | 2006-06-12 (2854 days ago) |
| Bobet | 2006-02-06 (2979 days ago) |
| Finlandia | 2005-12-28 (3019 days ago) |
| Hapsiainen | 2005-12-09 (3038 days ago) |
| Viznut | 2005-07-27 (3174 days ago) |
| Lanahard | 2005-07-21 (3179 days ago) |
| Rdnk | 2005-05-24 (3237 days ago) |
31 rows in set (55.17 sec)
es/Spanish[edit]
last update: 2008-03-28 (2199 days ago)
| Name | Last edit |
|---|---|
| Spacebirdy | 2008-03-27 (2199 days ago) |
| Bengoa | 2008-03-27 (2200 days ago) |
| Kylu | 2008-03-27 (2200 days ago) |
| Julie | 2008-03-26 (2200 days ago) |
| Taichi | 2008-03-26 (2200 days ago) |
| Ascánder | 2008-03-26 (2200 days ago) |
| Smeira | 2008-03-26 (2200 days ago) |
| SMP | 2008-03-26 (2200 days ago) |
| Drini | 2008-03-26 (2200 days ago) |
| Rdsmith4 | 2008-03-25 (2201 days ago) |
| Masterches | 2008-03-25 (2202 days ago) |
| Wikimistusik | 2008-03-25 (2202 days ago) |
| Mikel | 2008-03-25 (2202 days ago) |
| Willtron | 2008-03-24 (2202 days ago) |
| CHV | 2008-03-24 (2202 days ago) |
| Tosão | 2008-03-23 (2203 days ago) |
| Redux | 2008-03-21 (2205 days ago) |
| Xic667 | 2008-03-21 (2205 days ago) |
| LaosLos | 2008-03-20 (2206 days ago) |
| BetoCG | 2008-03-17 (2209 days ago) |
| DamianFinol | 2008-03-16 (2211 days ago) |
| Jurock | 2008-03-13 (2213 days ago) |
| Oswaldo2025 | 2008-03-13 (2214 days ago) |
| Damërung | 2008-03-08 (2218 days ago) |
| Alhen | 2008-03-06 (2221 days ago) |
| Fajro | 2008-03-04 (2223 days ago) |
| LadyInGrey | 2008-03-03 (2223 days ago) |
| Barcex | 2008-03-02 (2224 days ago) |
| Alpertron | 2008-02-29 (2226 days ago) |
| Cromwellt | 2008-02-29 (2227 days ago) |
| RedCoat | 2008-02-28 (2227 days ago) |
| Sapey | 2008-02-20 (2235 days ago) |
| Elisardojm | 2008-02-20 (2235 days ago) |
| Lascorz | 2008-02-19 (2236 days ago) |
| Rastrojo | 2008-02-19 (2236 days ago) |
| Cedric31 | 2008-02-19 (2237 days ago) |
| Prevert | 2008-02-16 (2239 days ago) |
| Aleator | 2008-02-15 (2240 days ago) |
| Zuirdj | 2008-02-15 (2240 days ago) |
| Orereta | 2008-02-15 (2240 days ago) |
| FrancoGG | 2008-02-11 (2244 days ago) |
| Loco085 | 2008-02-10 (2245 days ago) |
| Agüeybaná | 2008-02-10 (2245 days ago) |
| Mtmelendez | 2008-02-08 (2247 days ago) |
| TXiKi | 2008-02-08 (2248 days ago) |
| SCPS | 2008-02-07 (2248 days ago) |
| Toliño | 2008-02-07 (2248 days ago) |
| Theklan | 2008-02-07 (2248 days ago) |
| ReyBrujo | 2008-02-05 (2251 days ago) |
| Vilallonga | 2008-01-30 (2256 days ago) |
| Gaudio | 2008-01-25 (2262 days ago) |
| AlimanRuna | 2008-01-24 (2262 days ago) |
| Xtv | 2008-01-19 (2267 days ago) |
| Vriullop | 2008-01-18 (2268 days ago) |
| Desiphral | 2008-01-16 (2270 days ago) |
| DDarkfire | 2008-01-15 (2272 days ago) |
| Jove | 2008-01-08 (2279 days ago) |
| Pepelopex | 2008-01-07 (2279 days ago) |
| Esbardu | 2008-01-07 (2280 days ago) |
| Carles | 2007-12-30 (2287 days ago) |
| Celestianpower | 2007-12-30 (2287 days ago) |
| RRmeta | 2007-12-30 (2288 days ago) |
| Axxgreazz | 2007-12-23 (2295 days ago) |
| Sobreira | 2007-12-22 (2295 days ago) |
| Varano | 2007-12-18 (2299 days ago) |
| Chlewey | 2007-12-17 (2300 days ago) |
| Javierm | 2007-12-13 (2304 days ago) |
| Kipmaster | 2007-12-10 (2307 days ago) |
| Adalbertofrenesi | 2007-12-07 (2310 days ago) |
| JB82 | 2007-12-06 (2312 days ago) |
| Patstuart | 2007-12-04 (2314 days ago) |
| Subtiempo | 2007-11-30 (2317 days ago) |
| Jaranda | 2007-11-30 (2317 days ago) |
| Mac | 2007-11-29 (2318 days ago) |
| Lmbuga | 2007-11-28 (2319 days ago) |
| Janfri | 2007-11-28 (2319 days ago) |
| Banjo | 2007-11-24 (2323 days ago) |
| Malvenko | 2007-11-23 (2324 days ago) |
| Iradigalesc | 2007-11-23 (2324 days ago) |
| Llull | 2007-11-23 (2324 days ago) |
| Lohen11 | 2007-11-21 (2326 days ago) |
| Vibragiel | 2007-11-20 (2327 days ago) |
| Sanbec | 2007-11-20 (2327 days ago) |
| Yrithinnd | 2007-11-19 (2328 days ago) |
| Bdenk715 | 2007-11-14 (2334 days ago) |
| Marianocecowski | 2007-11-12 (2335 days ago) |
| Kuartas | 2007-11-10 (2337 days ago) |
| GlimmerPhoenix | 2007-11-09 (2338 days ago) |
| Fryant | 2007-11-08 (2339 days ago) |
| Edub | 2007-10-28 (2351 days ago) |
| Jynus | 2007-10-24 (2354 days ago) |
| Prietoquilmes | 2007-10-21 (2357 days ago) |
| Spangineer | 2007-10-14 (2364 days ago) |
| Pcongre | 2007-10-13 (2366 days ago) |
| Rodasmith | 2007-10-11 (2367 days ago) |
| JorgeGG | 2007-10-08 (2370 days ago) |
| Battroid | 2007-10-06 (2373 days ago) |
| Morza | 2007-09-30 (2379 days ago) |
| Albdallah | 2007-09-29 (2379 days ago) |
| Albeiror24 | 2007-09-29 (2380 days ago) |
100 rows in set (1 min 17.61 sec)
hi/Hindi[edit]
last update: 2008-03-28 (2199 days ago)
| Name | Last edit |
|---|---|
| Ashishbhatnagar | 2008-02-22 (2234 days ago) |
| Rajeevmass | 2008-02-07 (2248 days ago) |
| Eukesh | 2008-02-03 (2252 days ago) |
| Shyam | 2008-01-10 (2277 days ago) |
| Srikeit | 2007-12-06 (2311 days ago) |
| Sanjaybafnaji | 2007-07-26 (2445 days ago) |
| Mexxian | 2007-05-27 (2504 days ago) |
| Spundun | 2007-03-30 (2562 days ago) |
| Shreshth91 | 2007-02-16 (2605 days ago) |
| Jdas07 | 2006-09-12 (2761 days ago) |
| Dineshjk | 2005-08-05 (3164 days ago) |
| Abhishekbh | 2005-04-21 (3271 days ago) |
12 rows in set (43.28 sec)
ja/Japanese[edit]
last update: 2008-03-28 (2199 days ago)
| Name | Last edit |
|---|---|
| Tuinui | 2008-03-27 (2200 days ago) |
| Bookman | 2008-03-27 (2200 days ago) |
| Aphaia | 2008-03-27 (2200 days ago) |
| Kahusi | 2008-03-26 (2200 days ago) |
| Me2hero | 2008-03-26 (2200 days ago) |
| Genppy | 2008-03-26 (2201 days ago) |
| Kanjy | 2008-03-25 (2201 days ago) |
| Ninomy | 2008-03-25 (2201 days ago) |
| Kzhr | 2008-03-25 (2201 days ago) |
| LERK | 2008-03-25 (2202 days ago) |
| ZCU | 2008-03-24 (2202 days ago) |
| ゆいしあす | 2008-03-24 (2202 days ago) |
| Marine-Blue | 2008-03-22 (2205 days ago) |
| Courant | 2008-03-22 (2205 days ago) |
| Miya | 2008-03-20 (2207 days ago) |
| Mulukhiyya | 2008-03-12 (2215 days ago) |
| Mzm5zbC3 | 2008-03-11 (2215 days ago) |
| Bletilla | 2008-03-08 (2219 days ago) |
| Aotake | 2008-03-08 (2219 days ago) |
| Widehawk | 2008-03-04 (2223 days ago) |
| おはぐろ蜻蛉 | 2008-02-28 (2227 days ago) |
| ネッツ | 2008-02-27 (2228 days ago) |
| NJT | 2008-02-24 (2232 days ago) |
| 朝彦 | 2008-02-24 (2232 days ago) |
| Yassie | 2008-02-21 (2234 days ago) |
| 辞典の虫 | 2008-02-16 (2240 days ago) |
| Tommy6 | 2008-02-13 (2243 days ago) |
| Peccafly | 2008-02-10 (2246 days ago) |
| Uryah | 2008-02-10 (2246 days ago) |
| Kstigarbha | 2008-02-03 (2252 days ago) |
| Bukki | 2008-02-03 (2253 days ago) |
| Bellcricket | 2008-02-02 (2253 days ago) |
| Sylphie | 2008-02-01 (2255 days ago) |
| Pica | 2008-02-01 (2255 days ago) |
| Quatro | 2008-01-30 (2256 days ago) |
| Miya.m | 2008-01-29 (2258 days ago) |
| Londonbashi | 2008-01-28 (2258 days ago) |
| Kickaha | 2008-01-27 (2260 days ago) |
| Co.kyoto | 2008-01-27 (2260 days ago) |
| Hirokun | 2008-01-27 (2260 days ago) |
| Complex01 | 2008-01-27 (2260 days ago) |
| 千代林檎 | 2008-01-26 (2261 days ago) |
| Lonicera | 2008-01-25 (2261 days ago) |
| ZERBERUS | 2008-01-25 (2261 days ago) |
| Hyolee2 | 2008-01-25 (2262 days ago) |
| Tangotango | 2008-01-18 (2268 days ago) |
| Lemonsquash | 2008-01-16 (2270 days ago) |
| Knua | 2008-01-12 (2274 days ago) |
| Michey.M | 2008-01-05 (2282 days ago) |
| SS95 | 2007-12-27 (2290 days ago) |
| Suzuyoshinine | 2007-12-21 (2296 days ago) |
| Horlicks | 2007-12-21 (2297 days ago) |
| Volfgang | 2007-12-16 (2301 days ago) |
| Watermint | 2007-12-14 (2303 days ago) |
| Schu | 2007-12-14 (2304 days ago) |
| Tietew | 2007-12-10 (2308 days ago) |
| Dekimasu | 2007-12-04 (2314 days ago) |
| Swind | 2007-12-03 (2315 days ago) |
| Kareha | 2007-12-01 (2316 days ago) |
| Tamtarm | 2007-11-29 (2318 days ago) |
| Clarin | 2007-11-29 (2319 days ago) |
| Kasuga | 2007-11-28 (2319 days ago) |
| 11ChamOK | 2007-11-28 (2319 days ago) |
| Kurihaya | 2007-11-28 (2320 days ago) |
| Lusheeta | 2007-11-28 (2320 days ago) |
| Noraneko | 2007-11-28 (2320 days ago) |
| Kotodama-Reverse | 2007-11-26 (2321 days ago) |
| T-coco | 2007-11-26 (2321 days ago) |
| Numerike | 2007-11-26 (2321 days ago) |
| 霧木諒二 | 2007-11-26 (2321 days ago) |
| Takot | 2007-11-25 (2322 days ago) |
| Himetv | 2007-10-24 (2355 days ago) |
| Remington | 2007-10-20 (2358 days ago) |
| SantaClaus | 2007-09-25 (2383 days ago) |
| T.Saito | 2007-09-24 (2384 days ago) |
| Tiens | 2007-09-18 (2391 days ago) |
| Coryjp | 2007-09-05 (2404 days ago) |
| Muyo | 2007-09-03 (2405 days ago) |
| Ribbon | 2007-08-16 (2424 days ago) |
| Penpen | 2007-08-08 (2432 days ago) |
| PiaCarrot | 2007-08-04 (2435 days ago) |
| YouShow | 2007-07-27 (2443 days ago) |
| Chinneeb | 2007-07-03 (2468 days ago) |
| HALPHA | 2007-07-01 (2470 days ago) |
| Tonync | 2007-05-17 (2514 days ago) |
| Araisyohei | 2007-04-21 (2540 days ago) |
| 七星 | 2007-04-21 (2541 days ago) |
| LQVX | 2007-04-16 (2546 days ago) |
| Goncyan | 2007-04-05 (2557 days ago) |
| 端くれの錬金術師 | 2007-04-02 (2560 days ago) |
| Matsumomushi | 2007-03-25 (2568 days ago) |
| かんがへなし | 2007-03-17 (2576 days ago) |
| Rocky7 | 2007-03-16 (2576 days ago) |
| Lonchi** | 2007-03-09 (2584 days ago) |
| っ | 2007-02-17 (2604 days ago) |
| Kkkdc | 2007-02-16 (2605 days ago) |
| Diagraph01 | 2007-02-06 (2615 days ago) |
| Pachayachachic | 2007-02-03 (2618 days ago) |
| Adr6721 | 2007-02-01 (2620 days ago) |
| Su-no-G | 2007-02-01 (2620 days ago) |
100 rows in set (1 min 2.26 sec)
id/Bahasa Indonesian[edit]
last update: 2008-03-28 (2199 days ago)
| Name | Last edit |
|---|---|
| Azmi1995 | 2008-03-25 (2202 days ago) |
| IDRex | 2008-03-25 (2202 days ago) |
| IvanLanin | 2008-03-22 (2204 days ago) |
| Mimihitam | 2008-03-19 (2208 days ago) |
| Master2841 | 2008-03-08 (2218 days ago) |
| Chriswaterguy | 2008-03-07 (2220 days ago) |
| Borgx | 2008-03-04 (2223 days ago) |
| Kandar | 2008-02-18 (2237 days ago) |
| Meursault2004 | 2008-02-12 (2243 days ago) |
| Dragunova | 2008-02-08 (2248 days ago) |
| Hariadhi | 2007-08-03 (2437 days ago) |
| Irwangatot | 2007-06-12 (2488 days ago) |
| Anggoro | 2006-12-07 (2676 days ago) |
| Winana | 2006-11-22 (2690 days ago) |
| Anggreani | 2006-08-04 (2801 days ago) |
| HarisX | 2006-05-12 (2885 days ago) |
| Zaidpjd | 2005-11-20 (3057 days ago) |
| Widhiantoro | 2005-11-18 (3060 days ago) |
| Sudiryo | 2005-11-18 (3060 days ago) |
| *drew | 2005-11-08 (3070 days ago) |
20 rows in set (51.73 sec)
ro/Romanian[edit]
last update: 2008-03-28 (2199 days ago)
| Name | Last edit |
|---|---|
| SCriBu | 2008-02-24 (2231 days ago) |
| Cuman | 2008-01-25 (2261 days ago) |
| Desiphral | 2008-01-16 (2270 days ago) |
| IulianU | 2008-01-14 (2272 days ago) |
| AQUA | 2007-12-20 (2297 days ago) |
| Romihaitza | 2007-11-27 (2320 days ago) |
| BlueMonday | 2007-11-24 (2323 days ago) |
| Dorothea | 2007-11-19 (2328 days ago) |
| Bogdan | 2007-10-22 (2356 days ago) |
| Mocu | 2007-06-09 (2491 days ago) |
| Lorandka | 2007-01-05 (2646 days ago) |
| TSO1D | 2006-12-01 (2681 days ago) |
| Ronline | 2006-11-18 (2695 days ago) |
| Dmaftei | 2006-10-05 (2739 days ago) |
| Evosphere | 2006-07-14 (2821 days ago) |
| Orioane | 2006-06-29 (2836 days ago) |
| Victort | 2006-01-02 (3015 days ago) |
| NazismIsntCool | 2005-11-06 (3072 days ago) |
18 rows in set (55.09 sec)
sv/Swedish[edit]
last update: 2008-03-28 (2199 days ago)
| Name | Last edit |
|---|---|
| Micke | 2008-03-27 (2199 days ago) |
| Robertgreer | 2008-03-26 (2200 days ago) |
| M.M.S. | 2008-03-26 (2201 days ago) |
| Habj | 2008-03-25 (2201 days ago) |
| SvHannibal | 2008-03-24 (2202 days ago) |
| Moralist | 2008-03-24 (2202 days ago) |
| Boivie | 2008-03-14 (2212 days ago) |
| Mikez | 2008-03-04 (2223 days ago) |
| Riggwelter | 2008-02-16 (2239 days ago) |
| Malhonen | 2008-02-13 (2242 days ago) |
| LX | 2008-01-15 (2271 days ago) |
| Skomakarn | 2008-01-07 (2280 days ago) |
| Johngreen | 2007-12-04 (2313 days ago) |
| RaSten | 2007-10-21 (2357 days ago) |
| Pcongre | 2007-10-13 (2366 days ago) |
| Klibbnisse | 2007-08-27 (2412 days ago) |
| Edricson | 2007-08-09 (2431 days ago) |
| Smiddle | 2007-04-21 (2540 days ago) |
| Skagedal | 2007-04-01 (2560 days ago) |
| Yenx | 2007-01-08 (2643 days ago) |
| Kruosio | 2006-12-11 (2671 days ago) |
| NERIUM | 2006-06-29 (2837 days ago) |
| Jniemenmaa | 2006-06-12 (2854 days ago) |
| Marsve | 2006-05-05 (2891 days ago) |
| Aktalo | 2006-01-23 (2993 days ago) |
| Diyako | 2006-01-17 (3000 days ago) |
| Storpilot | 2005-12-12 (3035 days ago) |
| Scoo | 2005-12-08 (3040 days ago) |
| Qwm | 2005-11-16 (3062 days ago) |
| ShineB | 2005-09-29 (3109 days ago) |
| Tehvata | 2005-07-01 (3199 days ago) |
31 rows in set (3 min 51.74 sec)
uk/Ukrainian[edit]
last update: 2008-03-28 (2199 days ago)
| Name | Last edit |
|---|---|
| Ahonc | 2008-03-25 (2201 days ago) |
| Riwnodennyk | 2008-03-25 (2201 days ago) |
| A1 | 2008-02-11 (2244 days ago) |
| Ilyaroz | 2008-01-27 (2260 days ago) |
| Movses | 2008-01-23 (2264 days ago) |
| Yakudza | 2007-11-20 (2328 days ago) |
| Minia | 2007-11-18 (2329 days ago) |
| EvgenyGenkin | 2007-11-13 (2334 days ago) |
| DmRodionov | 2007-08-25 (2414 days ago) |
| Mikolasz | 2007-07-14 (2456 days ago) |
| Hayk | 2007-07-07 (2463 days ago) |
| Panas | 2007-07-01 (2469 days ago) |
| Yms | 2007-04-09 (2552 days ago) |
| Nevermind | 2006-12-18 (2664 days ago) |
| Angryxpeh | 2006-12-14 (2668 days ago) |
| AndriyK | 2006-11-24 (2688 days ago) |
| Martynenka | 2006-11-08 (2704 days ago) |
| Redsunrising | 2006-11-04 (2708 days ago) |
| Ornil | 2006-11-03 (2709 days ago) |
| Jan-ivan | 2005-11-14 (3063 days ago) |
| Inetd | 2005-03-26 (3296 days ago) |
21 rows in set (1 min 55.31 sec)
vi/Vietnamese[edit]
last update: 2008-03-28 (2199 days ago)
| Name | Last edit |
|---|---|
| Vinhtantran | 2008-03-27 (2200 days ago) |
| Neoneurone | 2007-11-15 (2333 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
}}
|
