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 (2529 days ago)
| Name | Last edit |
|---|---|
| Spiritia | 2008-03-20 (2536 days ago) |
| Timurberk | 2008-02-04 (2581 days ago) |
| Daggerstab | 2008-01-19 (2597 days ago) |
| 5ko | 2008-01-01 (2615 days ago) |
| Azimski | 2007-09-19 (2719 days ago) |
| Nk | 2007-06-28 (2802 days ago) |
| Vanka5 | 2007-05-25 (2837 days ago) |
| Sharkb | 2007-01-21 (2960 days ago) |
| Bggoldie | 2006-12-19 (2993 days ago) |
| DCLXVI | 2006-08-06 (3128 days ago) |
| Smartech | 2006-04-14 (3242 days ago) |
| Glimz | 2006-04-02 (3254 days ago) |
| Espetkov | 2005-06-05 (3555 days ago) |
13 rows in set (56.82 sec)
bn/Bengali[edit]
last update: 2008-03-28 (2529 days ago)
| Name | Last edit |
|---|---|
| Bellayet | 2008-03-26 (2530 days ago) |
| Aeetlrsk | 2008-02-04 (2581 days ago) |
| Frdayeen | 2008-01-08 (2608 days ago) |
| Hermitage17 | 2008-01-08 (2609 days ago) |
4 rows in set (9.26 sec)
fi/Finnish[edit]
last update: 2008-03-28 (2529 days ago)
| Name | Last edit |
|---|---|
| AtteL | 2008-03-25 (2531 days ago) |
| Str4nd | 2008-03-24 (2532 days ago) |
| Roosa | 2008-03-05 (2552 days ago) |
| Malhonen | 2008-02-13 (2572 days ago) |
| Ilaiho | 2007-12-25 (2622 days ago) |
| Argus | 2007-11-12 (2665 days ago) |
| Jariola | 2007-10-29 (2679 days ago) |
| Kyzyl | 2007-07-16 (2784 days ago) |
| Skuolfi | 2007-05-13 (2848 days ago) |
| Urvabara | 2007-02-08 (2942 days ago) |
| Jni | 2007-01-29 (2952 days ago) |
| NZ- | 2006-12-30 (2982 days ago) |
| Vilu | 2006-12-26 (2986 days ago) |
| Hartz | 2006-12-15 (2997 days ago) |
| Mzlla | 2006-12-07 (3005 days ago) |
| Inzulac | 2006-10-31 (3042 days ago) |
| Lauranen | 2006-10-02 (3071 days ago) |
| Totuus | 2006-09-05 (3098 days ago) |
| Anchjo | 2006-08-31 (3103 days ago) |
| Pwc | 2006-08-05 (3129 days ago) |
| Kouluhai | 2006-06-23 (3172 days ago) |
| Jniemenmaa | 2006-06-12 (3183 days ago) |
| Bobet | 2006-02-06 (3309 days ago) |
| Finlandia | 2005-12-28 (3349 days ago) |
| Hapsiainen | 2005-12-09 (3368 days ago) |
| Viznut | 2005-07-27 (3503 days ago) |
| Lanahard | 2005-07-21 (3509 days ago) |
| Rdnk | 2005-05-24 (3567 days ago) |
31 rows in set (55.17 sec)
es/Spanish[edit]
last update: 2008-03-28 (2529 days ago)
| Name | Last edit |
|---|---|
| Spacebirdy | 2008-03-27 (2529 days ago) |
| Bengoa | 2008-03-27 (2529 days ago) |
| Kylu | 2008-03-27 (2530 days ago) |
| Julie | 2008-03-26 (2530 days ago) |
| Taichi | 2008-03-26 (2530 days ago) |
| Ascánder | 2008-03-26 (2530 days ago) |
| Smeira | 2008-03-26 (2530 days ago) |
| SMP | 2008-03-26 (2530 days ago) |
| Drini | 2008-03-26 (2530 days ago) |
| Rdsmith4 | 2008-03-25 (2531 days ago) |
| Masterches | 2008-03-25 (2531 days ago) |
| Wikimistusik | 2008-03-25 (2531 days ago) |
| Mikel | 2008-03-25 (2532 days ago) |
| Willtron | 2008-03-24 (2532 days ago) |
| CHV | 2008-03-24 (2532 days ago) |
| Tosão | 2008-03-23 (2533 days ago) |
| Redux | 2008-03-21 (2535 days ago) |
| Xic667 | 2008-03-21 (2535 days ago) |
| LaosLos | 2008-03-20 (2536 days ago) |
| BetoCG | 2008-03-17 (2539 days ago) |
| DamianFinol | 2008-03-16 (2540 days ago) |
| Jurock | 2008-03-13 (2543 days ago) |
| Oswaldo2025 | 2008-03-13 (2544 days ago) |
| Damërung | 2008-03-08 (2548 days ago) |
| Alhen | 2008-03-06 (2550 days ago) |
| Fajro | 2008-03-04 (2552 days ago) |
| LadyInGrey | 2008-03-03 (2553 days ago) |
| Barcex | 2008-03-02 (2554 days ago) |
| Alpertron | 2008-02-29 (2556 days ago) |
| Cromwellt | 2008-02-29 (2557 days ago) |
| RedCoat | 2008-02-28 (2557 days ago) |
| Sapey | 2008-02-20 (2565 days ago) |
| Elisardojm | 2008-02-20 (2565 days ago) |
| Lascorz | 2008-02-19 (2566 days ago) |
| Rastrojo | 2008-02-19 (2566 days ago) |
| Cedric31 | 2008-02-19 (2566 days ago) |
| Prevert | 2008-02-16 (2569 days ago) |
| Aleator | 2008-02-15 (2570 days ago) |
| Zuirdj | 2008-02-15 (2570 days ago) |
| Orereta | 2008-02-15 (2570 days ago) |
| FrancoGG | 2008-02-11 (2574 days ago) |
| Loco085 | 2008-02-10 (2575 days ago) |
| Agüeybaná | 2008-02-10 (2575 days ago) |
| Mtmelendez | 2008-02-08 (2577 days ago) |
| TXiKi | 2008-02-08 (2577 days ago) |
| SCPS | 2008-02-07 (2578 days ago) |
| Toliño | 2008-02-07 (2578 days ago) |
| Theklan | 2008-02-07 (2578 days ago) |
| ReyBrujo | 2008-02-05 (2580 days ago) |
| Vilallonga | 2008-01-30 (2586 days ago) |
| Gaudio | 2008-01-25 (2591 days ago) |
| AlimanRuna | 2008-01-24 (2592 days ago) |
| Xtv | 2008-01-19 (2597 days ago) |
| Vriullop | 2008-01-18 (2598 days ago) |
| Desiphral | 2008-01-16 (2600 days ago) |
| DDarkfire | 2008-01-15 (2602 days ago) |
| Jove | 2008-01-08 (2609 days ago) |
| Pepelopex | 2008-01-07 (2609 days ago) |
| Esbardu | 2008-01-07 (2610 days ago) |
| Carles | 2007-12-30 (2617 days ago) |
| Celestianpower | 2007-12-30 (2617 days ago) |
| RRmeta | 2007-12-30 (2618 days ago) |
| Axxgreazz | 2007-12-23 (2625 days ago) |
| Sobreira | 2007-12-22 (2625 days ago) |
| Varano | 2007-12-18 (2629 days ago) |
| Chlewey | 2007-12-17 (2630 days ago) |
| Javierm | 2007-12-13 (2634 days ago) |
| Kipmaster | 2007-12-10 (2637 days ago) |
| Adalbertofrenesi | 2007-12-07 (2640 days ago) |
| JB82 | 2007-12-06 (2642 days ago) |
| Patstuart | 2007-12-04 (2643 days ago) |
| Subtiempo | 2007-11-30 (2647 days ago) |
| Jaranda | 2007-11-30 (2647 days ago) |
| Mac | 2007-11-29 (2648 days ago) |
| Lmbuga | 2007-11-28 (2649 days ago) |
| Janfri | 2007-11-28 (2649 days ago) |
| Banjo | 2007-11-24 (2653 days ago) |
| Malvenko | 2007-11-23 (2654 days ago) |
| Iradigalesc | 2007-11-23 (2654 days ago) |
| Llull | 2007-11-23 (2654 days ago) |
| Lohen11 | 2007-11-21 (2656 days ago) |
| Vibragiel | 2007-11-20 (2657 days ago) |
| Sanbec | 2007-11-20 (2657 days ago) |
| Yrithinnd | 2007-11-19 (2658 days ago) |
| Bdenk715 | 2007-11-14 (2663 days ago) |
| Marianocecowski | 2007-11-12 (2665 days ago) |
| Kuartas | 2007-11-10 (2667 days ago) |
| GlimmerPhoenix | 2007-11-09 (2668 days ago) |
| Fryant | 2007-11-08 (2669 days ago) |
| Edub | 2007-10-28 (2680 days ago) |
| Jynus | 2007-10-24 (2684 days ago) |
| Prietoquilmes | 2007-10-21 (2687 days ago) |
| Spangineer | 2007-10-14 (2694 days ago) |
| Pcongre | 2007-10-13 (2695 days ago) |
| Rodasmith | 2007-10-11 (2697 days ago) |
| JorgeGG | 2007-10-08 (2700 days ago) |
| Battroid | 2007-10-06 (2703 days ago) |
| Morza | 2007-09-30 (2708 days ago) |
| Albdallah | 2007-09-29 (2709 days ago) |
| Albeiror24 | 2007-09-29 (2709 days ago) |
100 rows in set (1 min 17.61 sec)
hi/Hindi[edit]
last update: 2008-03-28 (2529 days ago)
| Name | Last edit |
|---|---|
| Ashishbhatnagar | 2008-02-22 (2564 days ago) |
| Rajeevmass | 2008-02-07 (2578 days ago) |
| Eukesh | 2008-02-03 (2582 days ago) |
| Shyam | 2008-01-10 (2606 days ago) |
| Srikeit | 2007-12-06 (2641 days ago) |
| Sanjaybafnaji | 2007-07-26 (2774 days ago) |
| Mexxian | 2007-05-27 (2834 days ago) |
| Spundun | 2007-03-30 (2892 days ago) |
| Shreshth91 | 2007-02-16 (2935 days ago) |
| Jdas07 | 2006-09-12 (3091 days ago) |
| Dineshjk | 2005-08-05 (3494 days ago) |
| Abhishekbh | 2005-04-21 (3600 days ago) |
12 rows in set (43.28 sec)
ja/Japanese[edit]
last update: 2008-03-28 (2529 days ago)
| Name | Last edit |
|---|---|
| Tuinui | 2008-03-27 (2529 days ago) |
| Bookman | 2008-03-27 (2529 days ago) |
| Aphaia | 2008-03-27 (2530 days ago) |
| Kahusi | 2008-03-26 (2530 days ago) |
| Me2hero | 2008-03-26 (2530 days ago) |
| Genppy | 2008-03-26 (2531 days ago) |
| Kanjy | 2008-03-25 (2531 days ago) |
| Ninomy | 2008-03-25 (2531 days ago) |
| Kzhr | 2008-03-25 (2531 days ago) |
| LERK | 2008-03-25 (2531 days ago) |
| ZCU | 2008-03-24 (2532 days ago) |
| ゆいしあす | 2008-03-24 (2532 days ago) |
| Marine-Blue | 2008-03-22 (2534 days ago) |
| Courant | 2008-03-22 (2535 days ago) |
| Miya | 2008-03-20 (2537 days ago) |
| Mulukhiyya | 2008-03-12 (2544 days ago) |
| Mzm5zbC3 | 2008-03-11 (2545 days ago) |
| Bletilla | 2008-03-08 (2548 days ago) |
| Aotake | 2008-03-08 (2549 days ago) |
| Widehawk | 2008-03-04 (2553 days ago) |
| おはぐろ蜻蛉 | 2008-02-28 (2557 days ago) |
| ネッツ | 2008-02-27 (2558 days ago) |
| NJT | 2008-02-24 (2561 days ago) |
| 朝彦 | 2008-02-24 (2562 days ago) |
| Yassie | 2008-02-21 (2564 days ago) |
| 辞典の虫 | 2008-02-16 (2570 days ago) |
| Tommy6 | 2008-02-13 (2572 days ago) |
| Peccafly | 2008-02-10 (2575 days ago) |
| Uryah | 2008-02-10 (2575 days ago) |
| Kstigarbha | 2008-02-03 (2582 days ago) |
| Bukki | 2008-02-03 (2583 days ago) |
| Bellcricket | 2008-02-02 (2583 days ago) |
| Sylphie | 2008-02-01 (2584 days ago) |
| Pica | 2008-02-01 (2584 days ago) |
| Quatro | 2008-01-30 (2586 days ago) |
| Miya.m | 2008-01-29 (2587 days ago) |
| Londonbashi | 2008-01-28 (2588 days ago) |
| Kickaha | 2008-01-27 (2589 days ago) |
| Co.kyoto | 2008-01-27 (2589 days ago) |
| Hirokun | 2008-01-27 (2589 days ago) |
| Complex01 | 2008-01-27 (2589 days ago) |
| 千代林檎 | 2008-01-26 (2591 days ago) |
| Lonicera | 2008-01-25 (2591 days ago) |
| ZERBERUS | 2008-01-25 (2591 days ago) |
| Hyolee2 | 2008-01-25 (2592 days ago) |
| Tangotango | 2008-01-18 (2598 days ago) |
| Lemonsquash | 2008-01-16 (2600 days ago) |
| Knua | 2008-01-12 (2604 days ago) |
| Michey.M | 2008-01-05 (2611 days ago) |
| SS95 | 2007-12-27 (2620 days ago) |
| Suzuyoshinine | 2007-12-21 (2626 days ago) |
| Horlicks | 2007-12-21 (2627 days ago) |
| Volfgang | 2007-12-16 (2631 days ago) |
| Watermint | 2007-12-14 (2633 days ago) |
| Schu | 2007-12-14 (2634 days ago) |
| Tietew | 2007-12-10 (2638 days ago) |
| Dekimasu | 2007-12-04 (2644 days ago) |
| Swind | 2007-12-03 (2645 days ago) |
| Kareha | 2007-12-01 (2646 days ago) |
| Tamtarm | 2007-11-29 (2648 days ago) |
| Clarin | 2007-11-29 (2649 days ago) |
| Kasuga | 2007-11-28 (2649 days ago) |
| 11ChamOK | 2007-11-28 (2649 days ago) |
| Kurihaya | 2007-11-28 (2649 days ago) |
| Lusheeta | 2007-11-28 (2649 days ago) |
| Noraneko | 2007-11-28 (2650 days ago) |
| Kotodama-Reverse | 2007-11-26 (2651 days ago) |
| T-coco | 2007-11-26 (2651 days ago) |
| Numerike | 2007-11-26 (2651 days ago) |
| 霧木諒二 | 2007-11-26 (2651 days ago) |
| Takot | 2007-11-25 (2652 days ago) |
| Himetv | 2007-10-24 (2685 days ago) |
| Remington | 2007-10-20 (2688 days ago) |
| SantaClaus | 2007-09-25 (2713 days ago) |
| T.Saito | 2007-09-24 (2714 days ago) |
| Tiens | 2007-09-18 (2721 days ago) |
| Coryjp | 2007-09-05 (2733 days ago) |
| Muyo | 2007-09-03 (2735 days ago) |
| Ribbon | 2007-08-16 (2754 days ago) |
| Penpen | 2007-08-08 (2762 days ago) |
| PiaCarrot | 2007-08-04 (2765 days ago) |
| YouShow | 2007-07-27 (2773 days ago) |
| Chinneeb | 2007-07-03 (2798 days ago) |
| HALPHA | 2007-07-01 (2799 days ago) |
| Tonync | 2007-05-17 (2844 days ago) |
| Araisyohei | 2007-04-21 (2870 days ago) |
| 七星 | 2007-04-21 (2871 days ago) |
| LQVX | 2007-04-16 (2876 days ago) |
| Goncyan | 2007-04-05 (2887 days ago) |
| 端くれの錬金術師 | 2007-04-02 (2889 days ago) |
| Matsumomushi | 2007-03-25 (2898 days ago) |
| かんがへなし | 2007-03-17 (2905 days ago) |
| Rocky7 | 2007-03-16 (2906 days ago) |
| Lonchi** | 2007-03-09 (2914 days ago) |
| っ | 2007-02-17 (2933 days ago) |
| Kkkdc | 2007-02-16 (2934 days ago) |
| Diagraph01 | 2007-02-06 (2944 days ago) |
| Pachayachachic | 2007-02-03 (2948 days ago) |
| Adr6721 | 2007-02-01 (2949 days ago) |
| Su-no-G | 2007-02-01 (2950 days ago) |
100 rows in set (1 min 2.26 sec)
id/Bahasa Indonesian[edit]
last update: 2008-03-28 (2529 days ago)
| Name | Last edit |
|---|---|
| Azmi1995 | 2008-03-25 (2531 days ago) |
| IDRex | 2008-03-25 (2531 days ago) |
| IvanLanin | 2008-03-22 (2534 days ago) |
| Mimihitam | 2008-03-19 (2537 days ago) |
| Master2841 | 2008-03-08 (2548 days ago) |
| Chriswaterguy | 2008-03-07 (2550 days ago) |
| Borgx | 2008-03-04 (2553 days ago) |
| Kandar | 2008-02-18 (2567 days ago) |
| Meursault2004 | 2008-02-12 (2573 days ago) |
| Dragunova | 2008-02-08 (2577 days ago) |
| Hariadhi | 2007-08-03 (2766 days ago) |
| Irwangatot | 2007-06-12 (2818 days ago) |
| Anggoro | 2006-12-07 (3005 days ago) |
| Winana | 2006-11-22 (3020 days ago) |
| Anggreani | 2006-08-04 (3130 days ago) |
| HarisX | 2006-05-12 (3215 days ago) |
| Zaidpjd | 2005-11-20 (3387 days ago) |
| Widhiantoro | 2005-11-18 (3390 days ago) |
| Sudiryo | 2005-11-18 (3390 days ago) |
| *drew | 2005-11-08 (3399 days ago) |
20 rows in set (51.73 sec)
ro/Romanian[edit]
last update: 2008-03-28 (2529 days ago)
| Name | Last edit |
|---|---|
| SCriBu | 2008-02-24 (2561 days ago) |
| Cuman | 2008-01-25 (2591 days ago) |
| Desiphral | 2008-01-16 (2600 days ago) |
| IulianU | 2008-01-14 (2602 days ago) |
| AQUA | 2007-12-20 (2627 days ago) |
| Romihaitza | 2007-11-27 (2650 days ago) |
| BlueMonday | 2007-11-24 (2653 days ago) |
| Dorothea | 2007-11-19 (2658 days ago) |
| Bogdan | 2007-10-22 (2686 days ago) |
| Mocu | 2007-06-09 (2821 days ago) |
| Lorandka | 2007-01-05 (2976 days ago) |
| TSO1D | 2006-12-01 (3011 days ago) |
| Ronline | 2006-11-18 (3025 days ago) |
| Dmaftei | 2006-10-05 (3069 days ago) |
| Evosphere | 2006-07-14 (3151 days ago) |
| Orioane | 2006-06-29 (3166 days ago) |
| Victort | 2006-01-02 (3344 days ago) |
| NazismIsntCool | 2005-11-06 (3402 days ago) |
18 rows in set (55.09 sec)
sv/Swedish[edit]
last update: 2008-03-28 (2529 days ago)
| Name | Last edit |
|---|---|
| Micke | 2008-03-27 (2529 days ago) |
| Robertgreer | 2008-03-26 (2530 days ago) |
| M.M.S. | 2008-03-26 (2530 days ago) |
| Habj | 2008-03-25 (2531 days ago) |
| SvHannibal | 2008-03-24 (2532 days ago) |
| Moralist | 2008-03-24 (2532 days ago) |
| Boivie | 2008-03-14 (2542 days ago) |
| Mikez | 2008-03-04 (2553 days ago) |
| Riggwelter | 2008-02-16 (2569 days ago) |
| Malhonen | 2008-02-13 (2572 days ago) |
| LX | 2008-01-15 (2601 days ago) |
| Skomakarn | 2008-01-07 (2610 days ago) |
| Johngreen | 2007-12-04 (2643 days ago) |
| RaSten | 2007-10-21 (2687 days ago) |
| Pcongre | 2007-10-13 (2695 days ago) |
| Klibbnisse | 2007-08-27 (2742 days ago) |
| Edricson | 2007-08-09 (2760 days ago) |
| Smiddle | 2007-04-21 (2870 days ago) |
| Skagedal | 2007-04-01 (2890 days ago) |
| Yenx | 2007-01-08 (2973 days ago) |
| Kruosio | 2006-12-11 (3001 days ago) |
| NERIUM | 2006-06-29 (3167 days ago) |
| Jniemenmaa | 2006-06-12 (3183 days ago) |
| Marsve | 2006-05-05 (3221 days ago) |
| Aktalo | 2006-01-23 (3323 days ago) |
| Diyako | 2006-01-17 (3330 days ago) |
| Storpilot | 2005-12-12 (3365 days ago) |
| Scoo | 2005-12-08 (3369 days ago) |
| Qwm | 2005-11-16 (3392 days ago) |
| ShineB | 2005-09-29 (3439 days ago) |
| Tehvata | 2005-07-01 (3529 days ago) |
31 rows in set (3 min 51.74 sec)
uk/Ukrainian[edit]
last update: 2008-03-28 (2529 days ago)
| Name | Last edit |
|---|---|
| Ahonc | 2008-03-25 (2531 days ago) |
| Riwnodennyk | 2008-03-25 (2531 days ago) |
| A1 | 2008-02-11 (2574 days ago) |
| Ilyaroz | 2008-01-27 (2590 days ago) |
| Movses | 2008-01-23 (2593 days ago) |
| Yakudza | 2007-11-20 (2657 days ago) |
| Minia | 2007-11-18 (2659 days ago) |
| EvgenyGenkin | 2007-11-13 (2664 days ago) |
| DmRodionov | 2007-08-25 (2744 days ago) |
| Mikolasz | 2007-07-14 (2786 days ago) |
| Hayk | 2007-07-07 (2793 days ago) |
| Panas | 2007-07-01 (2799 days ago) |
| Yms | 2007-04-09 (2882 days ago) |
| Nevermind | 2006-12-18 (2994 days ago) |
| Angryxpeh | 2006-12-14 (2998 days ago) |
| AndriyK | 2006-11-24 (3018 days ago) |
| Martynenka | 2006-11-08 (3034 days ago) |
| Redsunrising | 2006-11-04 (3038 days ago) |
| Ornil | 2006-11-03 (3039 days ago) |
| Jan-ivan | 2005-11-14 (3393 days ago) |
| Inetd | 2005-03-26 (3626 days ago) |
21 rows in set (1 min 55.31 sec)
vi/Vietnamese[edit]
last update: 2008-03-28 (2529 days ago)
| Name | Last edit |
|---|---|
| Vinhtantran | 2008-03-27 (2530 days ago) |
| Neoneurone | 2007-11-15 (2662 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
}}
|
