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 (2161 days ago)
| Name | Last edit |
|---|---|
| Spiritia | 2008-03-20 (2168 days ago) |
| Timurberk | 2008-02-04 (2214 days ago) |
| Daggerstab | 2008-01-19 (2230 days ago) |
| 5ko | 2008-01-01 (2247 days ago) |
| Azimski | 2007-09-19 (2352 days ago) |
| Nk | 2007-06-28 (2435 days ago) |
| Vanka5 | 2007-05-25 (2469 days ago) |
| Sharkb | 2007-01-21 (2593 days ago) |
| Bggoldie | 2006-12-19 (2626 days ago) |
| DCLXVI | 2006-08-06 (2761 days ago) |
| Smartech | 2006-04-14 (2875 days ago) |
| Glimz | 2006-04-02 (2887 days ago) |
| Espetkov | 2005-06-05 (3188 days ago) |
13 rows in set (56.82 sec)
bn/Bengali[edit]
last update: 2008-03-28 (2161 days ago)
| Name | Last edit |
|---|---|
| Bellayet | 2008-03-26 (2162 days ago) |
| Aeetlrsk | 2008-02-04 (2213 days ago) |
| Frdayeen | 2008-01-08 (2241 days ago) |
| Hermitage17 | 2008-01-08 (2241 days ago) |
4 rows in set (9.26 sec)
fi/Finnish[edit]
last update: 2008-03-28 (2161 days ago)
| Name | Last edit |
|---|---|
| AtteL | 2008-03-25 (2164 days ago) |
| Str4nd | 2008-03-24 (2164 days ago) |
| Roosa | 2008-03-05 (2184 days ago) |
| Malhonen | 2008-02-13 (2204 days ago) |
| Ilaiho | 2007-12-25 (2254 days ago) |
| Argus | 2007-11-12 (2298 days ago) |
| Jariola | 2007-10-29 (2312 days ago) |
| Kyzyl | 2007-07-16 (2417 days ago) |
| Skuolfi | 2007-05-13 (2481 days ago) |
| Urvabara | 2007-02-08 (2575 days ago) |
| Jni | 2007-01-29 (2585 days ago) |
| NZ- | 2006-12-30 (2614 days ago) |
| Vilu | 2006-12-26 (2618 days ago) |
| Hartz | 2006-12-15 (2629 days ago) |
| Mzlla | 2006-12-07 (2638 days ago) |
| Inzulac | 2006-10-31 (2674 days ago) |
| Lauranen | 2006-10-02 (2704 days ago) |
| Totuus | 2006-09-05 (2730 days ago) |
| Anchjo | 2006-08-31 (2736 days ago) |
| Pwc | 2006-08-05 (2761 days ago) |
| Kouluhai | 2006-06-23 (2804 days ago) |
| Jniemenmaa | 2006-06-12 (2816 days ago) |
| Bobet | 2006-02-06 (2941 days ago) |
| Finlandia | 2005-12-28 (2982 days ago) |
| Hapsiainen | 2005-12-09 (3000 days ago) |
| Viznut | 2005-07-27 (3136 days ago) |
| Lanahard | 2005-07-21 (3141 days ago) |
| Rdnk | 2005-05-24 (3199 days ago) |
31 rows in set (55.17 sec)
es/Spanish[edit]
last update: 2008-03-28 (2161 days ago)
| Name | Last edit |
|---|---|
| Spacebirdy | 2008-03-27 (2162 days ago) |
| Bengoa | 2008-03-27 (2162 days ago) |
| Kylu | 2008-03-27 (2162 days ago) |
| Julie | 2008-03-26 (2162 days ago) |
| Taichi | 2008-03-26 (2162 days ago) |
| Ascánder | 2008-03-26 (2162 days ago) |
| Smeira | 2008-03-26 (2162 days ago) |
| SMP | 2008-03-26 (2162 days ago) |
| Drini | 2008-03-26 (2162 days ago) |
| Rdsmith4 | 2008-03-25 (2163 days ago) |
| Masterches | 2008-03-25 (2164 days ago) |
| Wikimistusik | 2008-03-25 (2164 days ago) |
| Mikel | 2008-03-25 (2164 days ago) |
| Willtron | 2008-03-24 (2164 days ago) |
| CHV | 2008-03-24 (2164 days ago) |
| Tosão | 2008-03-23 (2165 days ago) |
| Redux | 2008-03-21 (2168 days ago) |
| Xic667 | 2008-03-21 (2168 days ago) |
| LaosLos | 2008-03-20 (2169 days ago) |
| BetoCG | 2008-03-17 (2171 days ago) |
| DamianFinol | 2008-03-16 (2173 days ago) |
| Jurock | 2008-03-13 (2175 days ago) |
| Oswaldo2025 | 2008-03-13 (2176 days ago) |
| Damërung | 2008-03-08 (2181 days ago) |
| Alhen | 2008-03-06 (2183 days ago) |
| Fajro | 2008-03-04 (2185 days ago) |
| LadyInGrey | 2008-03-03 (2185 days ago) |
| Barcex | 2008-03-02 (2186 days ago) |
| Alpertron | 2008-02-29 (2188 days ago) |
| Cromwellt | 2008-02-29 (2189 days ago) |
| RedCoat | 2008-02-28 (2190 days ago) |
| Sapey | 2008-02-20 (2197 days ago) |
| Elisardojm | 2008-02-20 (2198 days ago) |
| Lascorz | 2008-02-19 (2198 days ago) |
| Rastrojo | 2008-02-19 (2199 days ago) |
| Cedric31 | 2008-02-19 (2199 days ago) |
| Prevert | 2008-02-16 (2201 days ago) |
| Aleator | 2008-02-15 (2202 days ago) |
| Zuirdj | 2008-02-15 (2202 days ago) |
| Orereta | 2008-02-15 (2203 days ago) |
| FrancoGG | 2008-02-11 (2206 days ago) |
| Loco085 | 2008-02-10 (2208 days ago) |
| Agüeybaná | 2008-02-10 (2208 days ago) |
| Mtmelendez | 2008-02-08 (2210 days ago) |
| TXiKi | 2008-02-08 (2210 days ago) |
| SCPS | 2008-02-07 (2210 days ago) |
| Toliño | 2008-02-07 (2210 days ago) |
| Theklan | 2008-02-07 (2211 days ago) |
| ReyBrujo | 2008-02-05 (2213 days ago) |
| Vilallonga | 2008-01-30 (2219 days ago) |
| Gaudio | 2008-01-25 (2224 days ago) |
| AlimanRuna | 2008-01-24 (2224 days ago) |
| Xtv | 2008-01-19 (2229 days ago) |
| Vriullop | 2008-01-18 (2230 days ago) |
| Desiphral | 2008-01-16 (2233 days ago) |
| DDarkfire | 2008-01-15 (2234 days ago) |
| Jove | 2008-01-08 (2241 days ago) |
| Pepelopex | 2008-01-07 (2241 days ago) |
| Esbardu | 2008-01-07 (2242 days ago) |
| Carles | 2007-12-30 (2249 days ago) |
| Celestianpower | 2007-12-30 (2250 days ago) |
| RRmeta | 2007-12-30 (2250 days ago) |
| Axxgreazz | 2007-12-23 (2257 days ago) |
| Sobreira | 2007-12-22 (2258 days ago) |
| Varano | 2007-12-18 (2261 days ago) |
| Chlewey | 2007-12-17 (2263 days ago) |
| Javierm | 2007-12-13 (2266 days ago) |
| Kipmaster | 2007-12-10 (2269 days ago) |
| Adalbertofrenesi | 2007-12-07 (2272 days ago) |
| JB82 | 2007-12-06 (2274 days ago) |
| Patstuart | 2007-12-04 (2276 days ago) |
| Subtiempo | 2007-11-30 (2279 days ago) |
| Jaranda | 2007-11-30 (2279 days ago) |
| Mac | 2007-11-29 (2281 days ago) |
| Lmbuga | 2007-11-28 (2281 days ago) |
| Janfri | 2007-11-28 (2281 days ago) |
| Banjo | 2007-11-24 (2285 days ago) |
| Malvenko | 2007-11-23 (2286 days ago) |
| Iradigalesc | 2007-11-23 (2286 days ago) |
| Llull | 2007-11-23 (2287 days ago) |
| Lohen11 | 2007-11-21 (2288 days ago) |
| Vibragiel | 2007-11-20 (2289 days ago) |
| Sanbec | 2007-11-20 (2289 days ago) |
| Yrithinnd | 2007-11-19 (2290 days ago) |
| Bdenk715 | 2007-11-14 (2296 days ago) |
| Marianocecowski | 2007-11-12 (2297 days ago) |
| Kuartas | 2007-11-10 (2299 days ago) |
| GlimmerPhoenix | 2007-11-09 (2300 days ago) |
| Fryant | 2007-11-08 (2301 days ago) |
| Edub | 2007-10-28 (2313 days ago) |
| Jynus | 2007-10-24 (2317 days ago) |
| Prietoquilmes | 2007-10-21 (2319 days ago) |
| Spangineer | 2007-10-14 (2326 days ago) |
| Pcongre | 2007-10-13 (2328 days ago) |
| Rodasmith | 2007-10-11 (2329 days ago) |
| JorgeGG | 2007-10-08 (2333 days ago) |
| Battroid | 2007-10-06 (2335 days ago) |
| Morza | 2007-09-30 (2341 days ago) |
| Albdallah | 2007-09-29 (2341 days ago) |
| Albeiror24 | 2007-09-29 (2342 days ago) |
100 rows in set (1 min 17.61 sec)
hi/Hindi[edit]
last update: 2008-03-28 (2161 days ago)
| Name | Last edit |
|---|---|
| Ashishbhatnagar | 2008-02-22 (2196 days ago) |
| Rajeevmass | 2008-02-07 (2211 days ago) |
| Eukesh | 2008-02-03 (2214 days ago) |
| Shyam | 2008-01-10 (2239 days ago) |
| Srikeit | 2007-12-06 (2273 days ago) |
| Sanjaybafnaji | 2007-07-26 (2407 days ago) |
| Mexxian | 2007-05-27 (2466 days ago) |
| Spundun | 2007-03-30 (2525 days ago) |
| Shreshth91 | 2007-02-16 (2567 days ago) |
| Jdas07 | 2006-09-12 (2723 days ago) |
| Dineshjk | 2005-08-05 (3126 days ago) |
| Abhishekbh | 2005-04-21 (3233 days ago) |
12 rows in set (43.28 sec)
ja/Japanese[edit]
last update: 2008-03-28 (2161 days ago)
| Name | Last edit |
|---|---|
| Tuinui | 2008-03-27 (2162 days ago) |
| Bookman | 2008-03-27 (2162 days ago) |
| Aphaia | 2008-03-27 (2162 days ago) |
| Kahusi | 2008-03-26 (2163 days ago) |
| Me2hero | 2008-03-26 (2163 days ago) |
| Genppy | 2008-03-26 (2163 days ago) |
| Kanjy | 2008-03-25 (2163 days ago) |
| Ninomy | 2008-03-25 (2164 days ago) |
| Kzhr | 2008-03-25 (2164 days ago) |
| LERK | 2008-03-25 (2164 days ago) |
| ZCU | 2008-03-24 (2165 days ago) |
| ゆいしあす | 2008-03-24 (2165 days ago) |
| Marine-Blue | 2008-03-22 (2167 days ago) |
| Courant | 2008-03-22 (2167 days ago) |
| Miya | 2008-03-20 (2169 days ago) |
| Mulukhiyya | 2008-03-12 (2177 days ago) |
| Mzm5zbC3 | 2008-03-11 (2178 days ago) |
| Bletilla | 2008-03-08 (2181 days ago) |
| Aotake | 2008-03-08 (2181 days ago) |
| Widehawk | 2008-03-04 (2185 days ago) |
| おはぐろ蜻蛉 | 2008-02-28 (2190 days ago) |
| ネッツ | 2008-02-27 (2190 days ago) |
| NJT | 2008-02-24 (2194 days ago) |
| 朝彦 | 2008-02-24 (2194 days ago) |
| Yassie | 2008-02-21 (2197 days ago) |
| 辞典の虫 | 2008-02-16 (2202 days ago) |
| Tommy6 | 2008-02-13 (2205 days ago) |
| Peccafly | 2008-02-10 (2208 days ago) |
| Uryah | 2008-02-10 (2208 days ago) |
| Kstigarbha | 2008-02-03 (2215 days ago) |
| Bukki | 2008-02-03 (2215 days ago) |
| Bellcricket | 2008-02-02 (2215 days ago) |
| Sylphie | 2008-02-01 (2217 days ago) |
| Pica | 2008-02-01 (2217 days ago) |
| Quatro | 2008-01-30 (2218 days ago) |
| Miya.m | 2008-01-29 (2220 days ago) |
| Londonbashi | 2008-01-28 (2221 days ago) |
| Kickaha | 2008-01-27 (2222 days ago) |
| Co.kyoto | 2008-01-27 (2222 days ago) |
| Hirokun | 2008-01-27 (2222 days ago) |
| Complex01 | 2008-01-27 (2222 days ago) |
| 千代林檎 | 2008-01-26 (2223 days ago) |
| Lonicera | 2008-01-25 (2223 days ago) |
| ZERBERUS | 2008-01-25 (2224 days ago) |
| Hyolee2 | 2008-01-25 (2224 days ago) |
| Tangotango | 2008-01-18 (2230 days ago) |
| Lemonsquash | 2008-01-16 (2232 days ago) |
| Knua | 2008-01-12 (2236 days ago) |
| Michey.M | 2008-01-05 (2244 days ago) |
| SS95 | 2007-12-27 (2252 days ago) |
| Suzuyoshinine | 2007-12-21 (2259 days ago) |
| Horlicks | 2007-12-21 (2259 days ago) |
| Volfgang | 2007-12-16 (2264 days ago) |
| Watermint | 2007-12-14 (2266 days ago) |
| Schu | 2007-12-14 (2266 days ago) |
| Tietew | 2007-12-10 (2270 days ago) |
| Dekimasu | 2007-12-04 (2276 days ago) |
| Swind | 2007-12-03 (2277 days ago) |
| Kareha | 2007-12-01 (2279 days ago) |
| Tamtarm | 2007-11-29 (2281 days ago) |
| Clarin | 2007-11-29 (2281 days ago) |
| Kasuga | 2007-11-28 (2281 days ago) |
| 11ChamOK | 2007-11-28 (2281 days ago) |
| Kurihaya | 2007-11-28 (2282 days ago) |
| Lusheeta | 2007-11-28 (2282 days ago) |
| Noraneko | 2007-11-28 (2282 days ago) |
| Kotodama-Reverse | 2007-11-26 (2283 days ago) |
| T-coco | 2007-11-26 (2283 days ago) |
| Numerike | 2007-11-26 (2283 days ago) |
| 霧木諒二 | 2007-11-26 (2284 days ago) |
| Takot | 2007-11-25 (2284 days ago) |
| Himetv | 2007-10-24 (2317 days ago) |
| Remington | 2007-10-20 (2321 days ago) |
| SantaClaus | 2007-09-25 (2345 days ago) |
| T.Saito | 2007-09-24 (2347 days ago) |
| Tiens | 2007-09-18 (2353 days ago) |
| Coryjp | 2007-09-05 (2366 days ago) |
| Muyo | 2007-09-03 (2367 days ago) |
| Ribbon | 2007-08-16 (2386 days ago) |
| Penpen | 2007-08-08 (2394 days ago) |
| PiaCarrot | 2007-08-04 (2398 days ago) |
| YouShow | 2007-07-27 (2405 days ago) |
| Chinneeb | 2007-07-03 (2430 days ago) |
| HALPHA | 2007-07-01 (2432 days ago) |
| Tonync | 2007-05-17 (2477 days ago) |
| Araisyohei | 2007-04-21 (2503 days ago) |
| 七星 | 2007-04-21 (2503 days ago) |
| LQVX | 2007-04-16 (2508 days ago) |
| Goncyan | 2007-04-05 (2519 days ago) |
| 端くれの錬金術師 | 2007-04-02 (2522 days ago) |
| Matsumomushi | 2007-03-25 (2530 days ago) |
| かんがへなし | 2007-03-17 (2538 days ago) |
| Rocky7 | 2007-03-16 (2538 days ago) |
| Lonchi** | 2007-03-09 (2546 days ago) |
| っ | 2007-02-17 (2566 days ago) |
| Kkkdc | 2007-02-16 (2567 days ago) |
| Diagraph01 | 2007-02-06 (2577 days ago) |
| Pachayachachic | 2007-02-03 (2580 days ago) |
| Adr6721 | 2007-02-01 (2582 days ago) |
| Su-no-G | 2007-02-01 (2582 days ago) |
100 rows in set (1 min 2.26 sec)
id/Bahasa Indonesian[edit]
last update: 2008-03-28 (2161 days ago)
| Name | Last edit |
|---|---|
| Azmi1995 | 2008-03-25 (2164 days ago) |
| IDRex | 2008-03-25 (2164 days ago) |
| IvanLanin | 2008-03-22 (2166 days ago) |
| Mimihitam | 2008-03-19 (2170 days ago) |
| Master2841 | 2008-03-08 (2180 days ago) |
| Chriswaterguy | 2008-03-07 (2182 days ago) |
| Borgx | 2008-03-04 (2185 days ago) |
| Kandar | 2008-02-18 (2200 days ago) |
| Meursault2004 | 2008-02-12 (2205 days ago) |
| Dragunova | 2008-02-08 (2210 days ago) |
| Hariadhi | 2007-08-03 (2399 days ago) |
| Irwangatot | 2007-06-12 (2450 days ago) |
| Anggoro | 2006-12-07 (2638 days ago) |
| Winana | 2006-11-22 (2652 days ago) |
| Anggreani | 2006-08-04 (2763 days ago) |
| HarisX | 2006-05-12 (2847 days ago) |
| Zaidpjd | 2005-11-20 (3019 days ago) |
| Widhiantoro | 2005-11-18 (3022 days ago) |
| Sudiryo | 2005-11-18 (3022 days ago) |
| *drew | 2005-11-08 (3032 days ago) |
20 rows in set (51.73 sec)
ro/Romanian[edit]
last update: 2008-03-28 (2161 days ago)
| Name | Last edit |
|---|---|
| SCriBu | 2008-02-24 (2193 days ago) |
| Cuman | 2008-01-25 (2224 days ago) |
| Desiphral | 2008-01-16 (2233 days ago) |
| IulianU | 2008-01-14 (2234 days ago) |
| AQUA | 2007-12-20 (2259 days ago) |
| Romihaitza | 2007-11-27 (2282 days ago) |
| BlueMonday | 2007-11-24 (2286 days ago) |
| Dorothea | 2007-11-19 (2290 days ago) |
| Bogdan | 2007-10-22 (2318 days ago) |
| Mocu | 2007-06-09 (2453 days ago) |
| Lorandka | 2007-01-05 (2608 days ago) |
| TSO1D | 2006-12-01 (2643 days ago) |
| Ronline | 2006-11-18 (2657 days ago) |
| Dmaftei | 2006-10-05 (2701 days ago) |
| Evosphere | 2006-07-14 (2784 days ago) |
| Orioane | 2006-06-29 (2799 days ago) |
| Victort | 2006-01-02 (2977 days ago) |
| NazismIsntCool | 2005-11-06 (3034 days ago) |
18 rows in set (55.09 sec)
sv/Swedish[edit]
last update: 2008-03-28 (2161 days ago)
| Name | Last edit |
|---|---|
| Micke | 2008-03-27 (2162 days ago) |
| Robertgreer | 2008-03-26 (2162 days ago) |
| M.M.S. | 2008-03-26 (2163 days ago) |
| Habj | 2008-03-25 (2164 days ago) |
| SvHannibal | 2008-03-24 (2164 days ago) |
| Moralist | 2008-03-24 (2164 days ago) |
| Boivie | 2008-03-14 (2175 days ago) |
| Mikez | 2008-03-04 (2185 days ago) |
| Riggwelter | 2008-02-16 (2202 days ago) |
| Malhonen | 2008-02-13 (2204 days ago) |
| LX | 2008-01-15 (2233 days ago) |
| Skomakarn | 2008-01-07 (2242 days ago) |
| Johngreen | 2007-12-04 (2275 days ago) |
| RaSten | 2007-10-21 (2320 days ago) |
| Pcongre | 2007-10-13 (2328 days ago) |
| Klibbnisse | 2007-08-27 (2375 days ago) |
| Edricson | 2007-08-09 (2393 days ago) |
| Smiddle | 2007-04-21 (2503 days ago) |
| Skagedal | 2007-04-01 (2522 days ago) |
| Yenx | 2007-01-08 (2606 days ago) |
| Kruosio | 2006-12-11 (2633 days ago) |
| NERIUM | 2006-06-29 (2799 days ago) |
| Jniemenmaa | 2006-06-12 (2816 days ago) |
| Marsve | 2006-05-05 (2853 days ago) |
| Aktalo | 2006-01-23 (2956 days ago) |
| Diyako | 2006-01-17 (2962 days ago) |
| Storpilot | 2005-12-12 (2998 days ago) |
| Scoo | 2005-12-08 (3002 days ago) |
| Qwm | 2005-11-16 (3024 days ago) |
| ShineB | 2005-09-29 (3072 days ago) |
| Tehvata | 2005-07-01 (3161 days ago) |
31 rows in set (3 min 51.74 sec)
uk/Ukrainian[edit]
last update: 2008-03-28 (2161 days ago)
| Name | Last edit |
|---|---|
| Ahonc | 2008-03-25 (2163 days ago) |
| Riwnodennyk | 2008-03-25 (2163 days ago) |
| A1 | 2008-02-11 (2206 days ago) |
| Ilyaroz | 2008-01-27 (2222 days ago) |
| Movses | 2008-01-23 (2226 days ago) |
| Yakudza | 2007-11-20 (2290 days ago) |
| Minia | 2007-11-18 (2291 days ago) |
| EvgenyGenkin | 2007-11-13 (2296 days ago) |
| DmRodionov | 2007-08-25 (2376 days ago) |
| Mikolasz | 2007-07-14 (2418 days ago) |
| Hayk | 2007-07-07 (2425 days ago) |
| Panas | 2007-07-01 (2432 days ago) |
| Yms | 2007-04-09 (2514 days ago) |
| Nevermind | 2006-12-18 (2627 days ago) |
| Angryxpeh | 2006-12-14 (2630 days ago) |
| AndriyK | 2006-11-24 (2650 days ago) |
| Martynenka | 2006-11-08 (2666 days ago) |
| Redsunrising | 2006-11-04 (2671 days ago) |
| Ornil | 2006-11-03 (2671 days ago) |
| Jan-ivan | 2005-11-14 (3025 days ago) |
| Inetd | 2005-03-26 (3258 days ago) |
21 rows in set (1 min 55.31 sec)
vi/Vietnamese[edit]
last update: 2008-03-28 (2161 days ago)
| Name | Last edit |
|---|---|
| Vinhtantran | 2008-03-27 (2162 days ago) |
| Neoneurone | 2007-11-15 (2295 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
}}
|
