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.
ListsEdit
bg/BulgarianEdit
last update: 2008-03-28 (5476 days ago)
| Name | Last edit |
|---|---|
| Spiritia | 2008-03-20 (5483 days ago) |
| Timurberk | 2008-02-04 (5528 days ago) |
| Daggerstab | 2008-01-19 (5544 days ago) |
| 5ko | 2008-01-01 (5562 days ago) |
| Azimski | 2007-09-19 (5666 days ago) |
| Nk | 2007-06-28 (5749 days ago) |
| Vanka5 | 2007-05-25 (5783 days ago) |
| Sharkb | 2007-01-21 (5907 days ago) |
| Bggoldie | 2006-12-19 (5940 days ago) |
| DCLXVI | 2006-08-06 (6075 days ago) |
| Smartech | 2006-04-14 (6189 days ago) |
| Glimz | 2006-04-02 (6201 days ago) |
| Espetkov | 2005-06-05 (6502 days ago) |
13 rows in set (56.82 sec)
bn/BengaliEdit
last update: 2008-03-28 (5476 days ago)
| Name | Last edit |
|---|---|
| Bellayet | 2008-03-26 (5477 days ago) |
| Aeetlrsk | 2008-02-04 (5528 days ago) |
| Frdayeen | 2008-01-08 (5555 days ago) |
| Hermitage17 | 2008-01-08 (5555 days ago) |
4 rows in set (9.26 sec)
fi/FinnishEdit
last update: 2008-03-28 (5476 days ago)
| Name | Last edit |
|---|---|
| AtteL | 2008-03-25 (5478 days ago) |
| Str4nd | 2008-03-24 (5479 days ago) |
| Roosa | 2008-03-05 (5499 days ago) |
| Malhonen | 2008-02-13 (5519 days ago) |
| Ilaiho | 2007-12-25 (5569 days ago) |
| Argus | 2007-11-12 (5612 days ago) |
| Jariola | 2007-10-29 (5626 days ago) |
| Kyzyl | 2007-07-16 (5731 days ago) |
| Skuolfi | 2007-05-13 (5795 days ago) |
| Urvabara | 2007-02-08 (5889 days ago) |
| Jni | 2007-01-29 (5899 days ago) |
| NZ- | 2006-12-30 (5929 days ago) |
| Vilu | 2006-12-26 (5933 days ago) |
| Hartz | 2006-12-15 (5944 days ago) |
| Mzlla | 2006-12-07 (5952 days ago) |
| Inzulac | 2006-10-31 (5989 days ago) |
| Lauranen | 2006-10-02 (6018 days ago) |
| Totuus | 2006-09-05 (6045 days ago) |
| Anchjo | 2006-08-31 (6050 days ago) |
| Pwc | 2006-08-05 (6076 days ago) |
| Kouluhai | 2006-06-23 (6119 days ago) |
| Jniemenmaa | 2006-06-12 (6130 days ago) |
| Bobet | 2006-02-06 (6256 days ago) |
| Finlandia | 2005-12-28 (6296 days ago) |
| Hapsiainen | 2005-12-09 (6315 days ago) |
| Viznut | 2005-07-27 (6450 days ago) |
| Lanahard | 2005-07-21 (6456 days ago) |
| Rdnk | 2005-05-24 (6514 days ago) |
31 rows in set (55.17 sec)
es/SpanishEdit
last update: 2008-03-28 (5476 days ago)
| Name | Last edit |
|---|---|
| Spacebirdy | 2008-03-27 (5476 days ago) |
| Bengoa | 2008-03-27 (5476 days ago) |
| Kylu | 2008-03-27 (5476 days ago) |
| Julie | 2008-03-26 (5477 days ago) |
| Taichi | 2008-03-26 (5477 days ago) |
| Ascánder | 2008-03-26 (5477 days ago) |
| Smeira | 2008-03-26 (5477 days ago) |
| SMP | 2008-03-26 (5477 days ago) |
| Drini | 2008-03-26 (5477 days ago) |
| Rdsmith4 | 2008-03-25 (5478 days ago) |
| Masterches | 2008-03-25 (5478 days ago) |
| Wikimistusik | 2008-03-25 (5478 days ago) |
| Mikel | 2008-03-25 (5478 days ago) |
| Willtron | 2008-03-24 (5479 days ago) |
| CHV | 2008-03-24 (5479 days ago) |
| Tosão | 2008-03-23 (5480 days ago) |
| Redux | 2008-03-21 (5482 days ago) |
| Xic667 | 2008-03-21 (5482 days ago) |
| LaosLos | 2008-03-20 (5483 days ago) |
| BetoCG | 2008-03-17 (5486 days ago) |
| DamianFinol | 2008-03-16 (5487 days ago) |
| Jurock | 2008-03-13 (5490 days ago) |
| Oswaldo2025 | 2008-03-13 (5491 days ago) |
| Damërung | 2008-03-08 (5495 days ago) |
| Alhen | 2008-03-06 (5497 days ago) |
| Fajro | 2008-03-04 (5499 days ago) |
| LadyInGrey | 2008-03-03 (5500 days ago) |
| Barcex | 2008-03-02 (5501 days ago) |
| Alpertron | 2008-02-29 (5503 days ago) |
| Cromwellt | 2008-02-29 (5504 days ago) |
| RedCoat | 2008-02-28 (5504 days ago) |
| Sapey | 2008-02-20 (5512 days ago) |
| Elisardojm | 2008-02-20 (5512 days ago) |
| Lascorz | 2008-02-19 (5513 days ago) |
| Rastrojo | 2008-02-19 (5513 days ago) |
| Cedric31 | 2008-02-19 (5513 days ago) |
| Prevert | 2008-02-16 (5516 days ago) |
| Aleator | 2008-02-15 (5517 days ago) |
| Zuirdj | 2008-02-15 (5517 days ago) |
| Orereta | 2008-02-15 (5517 days ago) |
| FrancoGG | 2008-02-11 (5521 days ago) |
| Loco085 | 2008-02-10 (5522 days ago) |
| Agüeybaná | 2008-02-10 (5522 days ago) |
| Mtmelendez | 2008-02-08 (5524 days ago) |
| TXiKi | 2008-02-08 (5524 days ago) |
| SCPS | 2008-02-07 (5525 days ago) |
| Toliño | 2008-02-07 (5525 days ago) |
| Theklan | 2008-02-07 (5525 days ago) |
| ReyBrujo | 2008-02-05 (5527 days ago) |
| Vilallonga | 2008-01-30 (5533 days ago) |
| Gaudio | 2008-01-25 (5538 days ago) |
| AlimanRuna | 2008-01-24 (5539 days ago) |
| Xtv | 2008-01-19 (5544 days ago) |
| Vriullop | 2008-01-18 (5545 days ago) |
| Desiphral | 2008-01-16 (5547 days ago) |
| DDarkfire | 2008-01-15 (5548 days ago) |
| Jove | 2008-01-08 (5556 days ago) |
| Pepelopex | 2008-01-07 (5556 days ago) |
| Esbardu | 2008-01-07 (5556 days ago) |
| Carles | 2007-12-30 (5564 days ago) |
| Celestianpower | 2007-12-30 (5564 days ago) |
| RRmeta | 2007-12-30 (5565 days ago) |
| Axxgreazz | 2007-12-23 (5571 days ago) |
| Sobreira | 2007-12-22 (5572 days ago) |
| Varano | 2007-12-18 (5576 days ago) |
| Chlewey | 2007-12-17 (5577 days ago) |
| Javierm | 2007-12-13 (5581 days ago) |
| Kipmaster | 2007-12-10 (5584 days ago) |
| Adalbertofrenesi | 2007-12-07 (5587 days ago) |
| JB82 | 2007-12-06 (5588 days ago) |
| Patstuart | 2007-12-04 (5590 days ago) |
| Subtiempo | 2007-11-30 (5594 days ago) |
| Jaranda | 2007-11-30 (5594 days ago) |
| Mac | 2007-11-29 (5595 days ago) |
| Lmbuga | 2007-11-28 (5596 days ago) |
| Janfri | 2007-11-28 (5596 days ago) |
| Banjo | 2007-11-24 (5600 days ago) |
| Malvenko | 2007-11-23 (5601 days ago) |
| Iradigalesc | 2007-11-23 (5601 days ago) |
| Llull | 2007-11-23 (5601 days ago) |
| Lohen11 | 2007-11-21 (5603 days ago) |
| Vibragiel | 2007-11-20 (5604 days ago) |
| Sanbec | 2007-11-20 (5604 days ago) |
| Yrithinnd | 2007-11-19 (5605 days ago) |
| Bdenk715 | 2007-11-14 (5610 days ago) |
| Marianocecowski | 2007-11-12 (5612 days ago) |
| Kuartas | 2007-11-10 (5614 days ago) |
| GlimmerPhoenix | 2007-11-09 (5615 days ago) |
| Fryant | 2007-11-08 (5616 days ago) |
| Edub | 2007-10-28 (5627 days ago) |
| Jynus | 2007-10-24 (5631 days ago) |
| Prietoquilmes | 2007-10-21 (5634 days ago) |
| Spangineer | 2007-10-14 (5641 days ago) |
| Pcongre | 2007-10-13 (5642 days ago) |
| Rodasmith | 2007-10-11 (5644 days ago) |
| JorgeGG | 2007-10-08 (5647 days ago) |
| Battroid | 2007-10-06 (5649 days ago) |
| Morza | 2007-09-30 (5655 days ago) |
| Albdallah | 2007-09-29 (5656 days ago) |
| Albeiror24 | 2007-09-29 (5656 days ago) |
100 rows in set (1 min 17.61 sec)
hi/HindiEdit
last update: 2008-03-28 (5476 days ago)
| Name | Last edit |
|---|---|
| Ashishbhatnagar | 2008-02-22 (5510 days ago) |
| Rajeevmass | 2008-02-07 (5525 days ago) |
| Eukesh | 2008-02-03 (5529 days ago) |
| Shyam | 2008-01-10 (5553 days ago) |
| Srikeit | 2007-12-06 (5588 days ago) |
| Sanjaybafnaji | 2007-07-26 (5721 days ago) |
| Mexxian | 2007-05-27 (5781 days ago) |
| Spundun | 2007-03-30 (5839 days ago) |
| Shreshth91 | 2007-02-16 (5881 days ago) |
| Jdas07 | 2006-09-12 (6038 days ago) |
| Dineshjk | 2005-08-05 (6441 days ago) |
| Abhishekbh | 2005-04-21 (6547 days ago) |
12 rows in set (43.28 sec)
ja/JapaneseEdit
last update: 2008-03-28 (5476 days ago)
| Name | Last edit |
|---|---|
| Tuinui | 2008-03-27 (5476 days ago) |
| Bookman | 2008-03-27 (5476 days ago) |
| Aphaia | 2008-03-27 (5476 days ago) |
| Kahusi | 2008-03-26 (5477 days ago) |
| Me2hero | 2008-03-26 (5477 days ago) |
| Genppy | 2008-03-26 (5477 days ago) |
| Kanjy | 2008-03-25 (5478 days ago) |
| Ninomy | 2008-03-25 (5478 days ago) |
| Kzhr | 2008-03-25 (5478 days ago) |
| LERK | 2008-03-25 (5478 days ago) |
| ZCU | 2008-03-24 (5479 days ago) |
| ゆいしあす | 2008-03-24 (5479 days ago) |
| Marine-Blue | 2008-03-22 (5481 days ago) |
| Courant | 2008-03-22 (5481 days ago) |
| Miya | 2008-03-20 (5483 days ago) |
| Mulukhiyya | 2008-03-12 (5491 days ago) |
| Mzm5zbC3 | 2008-03-11 (5492 days ago) |
| Bletilla | 2008-03-08 (5495 days ago) |
| Aotake | 2008-03-08 (5495 days ago) |
| Widehawk | 2008-03-04 (5499 days ago) |
| おはぐろ蜻蛉 | 2008-02-28 (5504 days ago) |
| ネッツ | 2008-02-27 (5505 days ago) |
| NJT | 2008-02-24 (5508 days ago) |
| 朝彦 | 2008-02-24 (5508 days ago) |
| Yassie | 2008-02-21 (5511 days ago) |
| 辞典の虫 | 2008-02-16 (5516 days ago) |
| Tommy6 | 2008-02-13 (5519 days ago) |
| Peccafly | 2008-02-10 (5522 days ago) |
| Uryah | 2008-02-10 (5522 days ago) |
| Kstigarbha | 2008-02-03 (5529 days ago) |
| Bukki | 2008-02-03 (5530 days ago) |
| Bellcricket | 2008-02-02 (5530 days ago) |
| Sylphie | 2008-02-01 (5531 days ago) |
| Pica | 2008-02-01 (5531 days ago) |
| Quatro | 2008-01-30 (5533 days ago) |
| Miya.m | 2008-01-29 (5534 days ago) |
| Londonbashi | 2008-01-28 (5535 days ago) |
| Kickaha | 2008-01-27 (5536 days ago) |
| Co.kyoto | 2008-01-27 (5536 days ago) |
| Hirokun | 2008-01-27 (5536 days ago) |
| Complex01 | 2008-01-27 (5536 days ago) |
| 千代林檎 | 2008-01-26 (5537 days ago) |
| Lonicera | 2008-01-25 (5538 days ago) |
| ZERBERUS | 2008-01-25 (5538 days ago) |
| Hyolee2 | 2008-01-25 (5538 days ago) |
| Tangotango | 2008-01-18 (5545 days ago) |
| Lemonsquash | 2008-01-16 (5547 days ago) |
| Knua | 2008-01-12 (5551 days ago) |
| Michey.M | 2008-01-05 (5558 days ago) |
| SS95 | 2007-12-27 (5567 days ago) |
| Suzuyoshinine | 2007-12-21 (5573 days ago) |
| Horlicks | 2007-12-21 (5573 days ago) |
| Volfgang | 2007-12-16 (5578 days ago) |
| Watermint | 2007-12-14 (5580 days ago) |
| Schu | 2007-12-14 (5580 days ago) |
| Tietew | 2007-12-10 (5584 days ago) |
| Dekimasu | 2007-12-04 (5590 days ago) |
| Swind | 2007-12-03 (5591 days ago) |
| Kareha | 2007-12-01 (5593 days ago) |
| Tamtarm | 2007-11-29 (5595 days ago) |
| Clarin | 2007-11-29 (5595 days ago) |
| Kasuga | 2007-11-28 (5596 days ago) |
| 11ChamOK | 2007-11-28 (5596 days ago) |
| Kurihaya | 2007-11-28 (5596 days ago) |
| Lusheeta | 2007-11-28 (5596 days ago) |
| Noraneko | 2007-11-28 (5597 days ago) |
| Kotodama-Reverse | 2007-11-26 (5598 days ago) |
| T-coco | 2007-11-26 (5598 days ago) |
| Numerike | 2007-11-26 (5598 days ago) |
| 霧木諒二 | 2007-11-26 (5598 days ago) |
| Takot | 2007-11-25 (5599 days ago) |
| Himetv | 2007-10-24 (5631 days ago) |
| Remington | 2007-10-20 (5635 days ago) |
| SantaClaus | 2007-09-25 (5660 days ago) |
| T.Saito | 2007-09-24 (5661 days ago) |
| Tiens | 2007-09-18 (5667 days ago) |
| Coryjp | 2007-09-05 (5680 days ago) |
| Muyo | 2007-09-03 (5682 days ago) |
| Ribbon | 2007-08-16 (5700 days ago) |
| Penpen | 2007-08-08 (5709 days ago) |
| PiaCarrot | 2007-08-04 (5712 days ago) |
| YouShow | 2007-07-27 (5720 days ago) |
| Chinneeb | 2007-07-03 (5744 days ago) |
| HALPHA | 2007-07-01 (5746 days ago) |
| Tonync | 2007-05-17 (5791 days ago) |
| Araisyohei | 2007-04-21 (5817 days ago) |
| 七星 | 2007-04-21 (5817 days ago) |
| LQVX | 2007-04-16 (5822 days ago) |
| Goncyan | 2007-04-05 (5833 days ago) |
| 端くれの錬金術師 | 2007-04-02 (5836 days ago) |
| Matsumomushi | 2007-03-25 (5844 days ago) |
| かんがへなし | 2007-03-17 (5852 days ago) |
| Rocky7 | 2007-03-16 (5853 days ago) |
| Lonchi** | 2007-03-09 (5860 days ago) |
| っ | 2007-02-17 (5880 days ago) |
| Kkkdc | 2007-02-16 (5881 days ago) |
| Diagraph01 | 2007-02-06 (5891 days ago) |
| Pachayachachic | 2007-02-03 (5894 days ago) |
| Adr6721 | 2007-02-01 (5896 days ago) |
| Su-no-G | 2007-02-01 (5896 days ago) |
100 rows in set (1 min 2.26 sec)
id/Bahasa IndonesianEdit
last update: 2008-03-28 (5476 days ago)
| Name | Last edit |
|---|---|
| Azmi1995 | 2008-03-25 (5478 days ago) |
| IDRex | 2008-03-25 (5478 days ago) |
| IvanLanin | 2008-03-22 (5481 days ago) |
| Mimihitam | 2008-03-19 (5484 days ago) |
| Master2841 | 2008-03-08 (5495 days ago) |
| Chriswaterguy | 2008-03-07 (5496 days ago) |
| Borgx | 2008-03-04 (5499 days ago) |
| Kandar | 2008-02-18 (5514 days ago) |
| Meursault2004 | 2008-02-12 (5520 days ago) |
| Dragunova | 2008-02-08 (5524 days ago) |
| Hariadhi | 2007-08-03 (5713 days ago) |
| Irwangatot | 2007-06-12 (5765 days ago) |
| Anggoro | 2006-12-07 (5952 days ago) |
| Winana | 2006-11-22 (5967 days ago) |
| Anggreani | 2006-08-04 (6077 days ago) |
| HarisX | 2006-05-12 (6161 days ago) |
| Zaidpjd | 2005-11-20 (6334 days ago) |
| Widhiantoro | 2005-11-18 (6336 days ago) |
| Sudiryo | 2005-11-18 (6336 days ago) |
| *drew | 2005-11-08 (6346 days ago) |
20 rows in set (51.73 sec)
ro/RomanianEdit
last update: 2008-03-28 (5476 days ago)
| Name | Last edit |
|---|---|
| SCriBu | 2008-02-24 (5508 days ago) |
| Cuman | 2008-01-25 (5538 days ago) |
| Desiphral | 2008-01-16 (5547 days ago) |
| IulianU | 2008-01-14 (5549 days ago) |
| AQUA | 2007-12-20 (5574 days ago) |
| Romihaitza | 2007-11-27 (5597 days ago) |
| BlueMonday | 2007-11-24 (5600 days ago) |
| Dorothea | 2007-11-19 (5605 days ago) |
| Bogdan | 2007-10-22 (5633 days ago) |
| Mocu | 2007-06-09 (5768 days ago) |
| Lorandka | 2007-01-05 (5923 days ago) |
| TSO1D | 2006-12-01 (5958 days ago) |
| Ronline | 2006-11-18 (5972 days ago) |
| Dmaftei | 2006-10-05 (6016 days ago) |
| Evosphere | 2006-07-14 (6098 days ago) |
| Orioane | 2006-06-29 (6113 days ago) |
| Victort | 2006-01-02 (6291 days ago) |
| NazismIsntCool | 2005-11-06 (6348 days ago) |
18 rows in set (55.09 sec)
sv/SwedishEdit
last update: 2008-03-28 (5476 days ago)
| Name | Last edit |
|---|---|
| Micke | 2008-03-27 (5476 days ago) |
| Robertgreer | 2008-03-26 (5477 days ago) |
| M.M.S. | 2008-03-26 (5477 days ago) |
| Habj | 2008-03-25 (5478 days ago) |
| SvHannibal | 2008-03-24 (5479 days ago) |
| Moralist | 2008-03-24 (5479 days ago) |
| Boivie | 2008-03-14 (5489 days ago) |
| Mikez | 2008-03-04 (5500 days ago) |
| Riggwelter | 2008-02-16 (5516 days ago) |
| Malhonen | 2008-02-13 (5519 days ago) |
| LX | 2008-01-15 (5548 days ago) |
| Skomakarn | 2008-01-07 (5557 days ago) |
| Johngreen | 2007-12-04 (5590 days ago) |
| RaSten | 2007-10-21 (5634 days ago) |
| Pcongre | 2007-10-13 (5642 days ago) |
| Klibbnisse | 2007-08-27 (5689 days ago) |
| Edricson | 2007-08-09 (5707 days ago) |
| Smiddle | 2007-04-21 (5817 days ago) |
| Skagedal | 2007-04-01 (5837 days ago) |
| Yenx | 2007-01-08 (5920 days ago) |
| Kruosio | 2006-12-11 (5948 days ago) |
| NERIUM | 2006-06-29 (6114 days ago) |
| Jniemenmaa | 2006-06-12 (6130 days ago) |
| Marsve | 2006-05-05 (6168 days ago) |
| Aktalo | 2006-01-23 (6270 days ago) |
| Diyako | 2006-01-17 (6276 days ago) |
| Storpilot | 2005-12-12 (6312 days ago) |
| Scoo | 2005-12-08 (6316 days ago) |
| Qwm | 2005-11-16 (6338 days ago) |
| ShineB | 2005-09-29 (6386 days ago) |
| Tehvata | 2005-07-01 (6476 days ago) |
31 rows in set (3 min 51.74 sec)
uk/UkrainianEdit
last update: 2008-03-28 (5476 days ago)
| Name | Last edit |
|---|---|
| Ahonc | 2008-03-25 (5478 days ago) |
| Riwnodennyk | 2008-03-25 (5478 days ago) |
| A1 | 2008-02-11 (5521 days ago) |
| Ilyaroz | 2008-01-27 (5536 days ago) |
| Movses | 2008-01-23 (5540 days ago) |
| Yakudza | 2007-11-20 (5604 days ago) |
| Minia | 2007-11-18 (5606 days ago) |
| EvgenyGenkin | 2007-11-13 (5611 days ago) |
| DmRodionov | 2007-08-25 (5691 days ago) |
| Mikolasz | 2007-07-14 (5733 days ago) |
| Hayk | 2007-07-07 (5740 days ago) |
| Panas | 2007-07-01 (5746 days ago) |
| Yms | 2007-04-09 (5829 days ago) |
| Nevermind | 2006-12-18 (5941 days ago) |
| Angryxpeh | 2006-12-14 (5945 days ago) |
| AndriyK | 2006-11-24 (5965 days ago) |
| Martynenka | 2006-11-08 (5981 days ago) |
| Redsunrising | 2006-11-04 (5985 days ago) |
| Ornil | 2006-11-03 (5986 days ago) |
| Jan-ivan | 2005-11-14 (6340 days ago) |
| Inetd | 2005-03-26 (6573 days ago) |
21 rows in set (1 min 55.31 sec)
vi/VietnameseEdit
last update: 2008-03-28 (5476 days ago)
| Name | Last edit |
|---|---|
| Vinhtantran | 2008-03-27 (5476 days ago) |
| Neoneurone | 2007-11-15 (5609 days ago) |
2 rows in set (11.40 sec)
GeneratingEdit
StructureEdit
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 tableEdit
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 usersEdit
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 tableEdit
SSH output can be converted to wiki table syntax using the following regex:
| search | \| (.+?)\s+\| (\d+) \| (?:\r\n)? |
|---|---|
| replace | {{/user
|1= $1
|2= $2
}}
|