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 (1873 days ago)
| Name | Last edit |
|---|---|
| Spiritia | 2008-03-20 (1880 days ago) |
| Timurberk | 2008-02-04 (1925 days ago) |
| Daggerstab | 2008-01-19 (1941 days ago) |
| 5ko | 2008-01-01 (1959 days ago) |
| Azimski | 2007-09-19 (2063 days ago) |
| Nk | 2007-06-28 (2146 days ago) |
| Vanka5 | 2007-05-25 (2181 days ago) |
| Sharkb | 2007-01-21 (2304 days ago) |
| Bggoldie | 2006-12-19 (2338 days ago) |
| DCLXVI | 2006-08-06 (2472 days ago) |
| Smartech | 2006-04-14 (2586 days ago) |
| Glimz | 2006-04-02 (2598 days ago) |
| Espetkov | 2005-06-05 (2899 days ago) |
13 rows in set (56.82 sec)
bn/Bengali [edit]
last update: 2008-03-28 (1873 days ago)
| Name | Last edit |
|---|---|
| Bellayet | 2008-03-26 (1874 days ago) |
| Aeetlrsk | 2008-02-04 (1925 days ago) |
| Frdayeen | 2008-01-08 (1952 days ago) |
| Hermitage17 | 2008-01-08 (1953 days ago) |
4 rows in set (9.26 sec)
fi/Finnish [edit]
last update: 2008-03-28 (1873 days ago)
| Name | Last edit |
|---|---|
| AtteL | 2008-03-25 (1875 days ago) |
| Str4nd | 2008-03-24 (1876 days ago) |
| Roosa | 2008-03-05 (1896 days ago) |
| Malhonen | 2008-02-13 (1916 days ago) |
| Ilaiho | 2007-12-25 (1966 days ago) |
| Argus | 2007-11-12 (2009 days ago) |
| Jariola | 2007-10-29 (2023 days ago) |
| Kyzyl | 2007-07-16 (2129 days ago) |
| Skuolfi | 2007-05-13 (2192 days ago) |
| Urvabara | 2007-02-08 (2286 days ago) |
| Jni | 2007-01-29 (2296 days ago) |
| NZ- | 2006-12-30 (2326 days ago) |
| Vilu | 2006-12-26 (2330 days ago) |
| Hartz | 2006-12-15 (2341 days ago) |
| Mzlla | 2006-12-07 (2349 days ago) |
| Inzulac | 2006-10-31 (2386 days ago) |
| Lauranen | 2006-10-02 (2415 days ago) |
| Totuus | 2006-09-05 (2442 days ago) |
| Anchjo | 2006-08-31 (2447 days ago) |
| Pwc | 2006-08-05 (2473 days ago) |
| Kouluhai | 2006-06-23 (2516 days ago) |
| Jniemenmaa | 2006-06-12 (2527 days ago) |
| Bobet | 2006-02-06 (2653 days ago) |
| Finlandia | 2005-12-28 (2693 days ago) |
| Hapsiainen | 2005-12-09 (2712 days ago) |
| Viznut | 2005-07-27 (2848 days ago) |
| Lanahard | 2005-07-21 (2853 days ago) |
| Rdnk | 2005-05-24 (2911 days ago) |
31 rows in set (55.17 sec)
es/Spanish [edit]
last update: 2008-03-28 (1873 days ago)
| Name | Last edit |
|---|---|
| Spacebirdy | 2008-03-27 (1873 days ago) |
| Bengoa | 2008-03-27 (1873 days ago) |
| Kylu | 2008-03-27 (1874 days ago) |
| Julie | 2008-03-26 (1874 days ago) |
| Taichi | 2008-03-26 (1874 days ago) |
| Ascánder | 2008-03-26 (1874 days ago) |
| Smeira | 2008-03-26 (1874 days ago) |
| SMP | 2008-03-26 (1874 days ago) |
| Drini | 2008-03-26 (1874 days ago) |
| Rdsmith4 | 2008-03-25 (1875 days ago) |
| Masterches | 2008-03-25 (1876 days ago) |
| Wikimistusik | 2008-03-25 (1876 days ago) |
| Mikel | 2008-03-25 (1876 days ago) |
| Willtron | 2008-03-24 (1876 days ago) |
| CHV | 2008-03-24 (1876 days ago) |
| Tosão | 2008-03-23 (1877 days ago) |
| Redux | 2008-03-21 (1879 days ago) |
| Xic667 | 2008-03-21 (1879 days ago) |
| LaosLos | 2008-03-20 (1880 days ago) |
| BetoCG | 2008-03-17 (1883 days ago) |
| DamianFinol | 2008-03-16 (1885 days ago) |
| Jurock | 2008-03-13 (1887 days ago) |
| Oswaldo2025 | 2008-03-13 (1888 days ago) |
| Damërung | 2008-03-08 (1892 days ago) |
| Alhen | 2008-03-06 (1894 days ago) |
| Fajro | 2008-03-04 (1897 days ago) |
| LadyInGrey | 2008-03-03 (1897 days ago) |
| Barcex | 2008-03-02 (1898 days ago) |
| Alpertron | 2008-02-29 (1900 days ago) |
| Cromwellt | 2008-02-29 (1901 days ago) |
| RedCoat | 2008-02-28 (1901 days ago) |
| Sapey | 2008-02-20 (1909 days ago) |
| Elisardojm | 2008-02-20 (1909 days ago) |
| Lascorz | 2008-02-19 (1910 days ago) |
| Rastrojo | 2008-02-19 (1910 days ago) |
| Cedric31 | 2008-02-19 (1910 days ago) |
| Prevert | 2008-02-16 (1913 days ago) |
| Aleator | 2008-02-15 (1914 days ago) |
| Zuirdj | 2008-02-15 (1914 days ago) |
| Orereta | 2008-02-15 (1914 days ago) |
| FrancoGG | 2008-02-11 (1918 days ago) |
| Loco085 | 2008-02-10 (1919 days ago) |
| Agüeybaná | 2008-02-10 (1919 days ago) |
| Mtmelendez | 2008-02-08 (1921 days ago) |
| TXiKi | 2008-02-08 (1922 days ago) |
| SCPS | 2008-02-07 (1922 days ago) |
| Toliño | 2008-02-07 (1922 days ago) |
| Theklan | 2008-02-07 (1922 days ago) |
| ReyBrujo | 2008-02-05 (1925 days ago) |
| Vilallonga | 2008-01-30 (1930 days ago) |
| Gaudio | 2008-01-25 (1935 days ago) |
| AlimanRuna | 2008-01-24 (1936 days ago) |
| Xtv | 2008-01-19 (1941 days ago) |
| Vriullop | 2008-01-18 (1942 days ago) |
| Desiphral | 2008-01-16 (1944 days ago) |
| DDarkfire | 2008-01-15 (1946 days ago) |
| Jove | 2008-01-08 (1953 days ago) |
| Pepelopex | 2008-01-07 (1953 days ago) |
| Esbardu | 2008-01-07 (1954 days ago) |
| Carles | 2007-12-30 (1961 days ago) |
| Celestianpower | 2007-12-30 (1961 days ago) |
| RRmeta | 2007-12-30 (1962 days ago) |
| Axxgreazz | 2007-12-23 (1969 days ago) |
| Sobreira | 2007-12-22 (1969 days ago) |
| Varano | 2007-12-18 (1973 days ago) |
| Chlewey | 2007-12-17 (1974 days ago) |
| Javierm | 2007-12-13 (1978 days ago) |
| Kipmaster | 2007-12-10 (1981 days ago) |
| Adalbertofrenesi | 2007-12-07 (1984 days ago) |
| JB82 | 2007-12-06 (1986 days ago) |
| Patstuart | 2007-12-04 (1988 days ago) |
| Subtiempo | 2007-11-30 (1991 days ago) |
| Jaranda | 2007-11-30 (1991 days ago) |
| Mac | 2007-11-29 (1992 days ago) |
| Lmbuga | 2007-11-28 (1993 days ago) |
| Janfri | 2007-11-28 (1993 days ago) |
| Banjo | 2007-11-24 (1997 days ago) |
| Malvenko | 2007-11-23 (1998 days ago) |
| Iradigalesc | 2007-11-23 (1998 days ago) |
| Llull | 2007-11-23 (1998 days ago) |
| Lohen11 | 2007-11-21 (2000 days ago) |
| Vibragiel | 2007-11-20 (2001 days ago) |
| Sanbec | 2007-11-20 (2001 days ago) |
| Yrithinnd | 2007-11-19 (2002 days ago) |
| Bdenk715 | 2007-11-14 (2008 days ago) |
| Marianocecowski | 2007-11-12 (2009 days ago) |
| Kuartas | 2007-11-10 (2011 days ago) |
| GlimmerPhoenix | 2007-11-09 (2012 days ago) |
| Fryant | 2007-11-08 (2013 days ago) |
| Edub | 2007-10-28 (2024 days ago) |
| Jynus | 2007-10-24 (2028 days ago) |
| Prietoquilmes | 2007-10-21 (2031 days ago) |
| Spangineer | 2007-10-14 (2038 days ago) |
| Pcongre | 2007-10-13 (2040 days ago) |
| Rodasmith | 2007-10-11 (2041 days ago) |
| JorgeGG | 2007-10-08 (2044 days ago) |
| Battroid | 2007-10-06 (2047 days ago) |
| Morza | 2007-09-30 (2052 days ago) |
| Albdallah | 2007-09-29 (2053 days ago) |
| Albeiror24 | 2007-09-29 (2054 days ago) |
100 rows in set (1 min 17.61 sec)
hi/Hindi [edit]
last update: 2008-03-28 (1873 days ago)
| Name | Last edit |
|---|---|
| Ashishbhatnagar | 2008-02-22 (1908 days ago) |
| Rajeevmass | 2008-02-07 (1922 days ago) |
| Eukesh | 2008-02-03 (1926 days ago) |
| Shyam | 2008-01-10 (1951 days ago) |
| Srikeit | 2007-12-06 (1985 days ago) |
| Sanjaybafnaji | 2007-07-26 (2119 days ago) |
| Mexxian | 2007-05-27 (2178 days ago) |
| Spundun | 2007-03-30 (2236 days ago) |
| Shreshth91 | 2007-02-16 (2279 days ago) |
| Jdas07 | 2006-09-12 (2435 days ago) |
| Dineshjk | 2005-08-05 (2838 days ago) |
| Abhishekbh | 2005-04-21 (2945 days ago) |
12 rows in set (43.28 sec)
ja/Japanese [edit]
last update: 2008-03-28 (1873 days ago)
| Name | Last edit |
|---|---|
| Tuinui | 2008-03-27 (1874 days ago) |
| Bookman | 2008-03-27 (1874 days ago) |
| Aphaia | 2008-03-27 (1874 days ago) |
| Kahusi | 2008-03-26 (1874 days ago) |
| Me2hero | 2008-03-26 (1874 days ago) |
| Genppy | 2008-03-26 (1875 days ago) |
| Kanjy | 2008-03-25 (1875 days ago) |
| Ninomy | 2008-03-25 (1875 days ago) |
| Kzhr | 2008-03-25 (1875 days ago) |
| LERK | 2008-03-25 (1875 days ago) |
| ZCU | 2008-03-24 (1876 days ago) |
| ゆいしあす | 2008-03-24 (1876 days ago) |
| Marine-Blue | 2008-03-22 (1879 days ago) |
| Courant | 2008-03-22 (1879 days ago) |
| Miya | 2008-03-20 (1881 days ago) |
| Mulukhiyya | 2008-03-12 (1888 days ago) |
| Mzm5zbC3 | 2008-03-11 (1889 days ago) |
| Bletilla | 2008-03-08 (1893 days ago) |
| Aotake | 2008-03-08 (1893 days ago) |
| Widehawk | 2008-03-04 (1897 days ago) |
| おはぐろ蜻蛉 | 2008-02-28 (1901 days ago) |
| ネッツ | 2008-02-27 (1902 days ago) |
| NJT | 2008-02-24 (1906 days ago) |
| 朝彦 | 2008-02-24 (1906 days ago) |
| Yassie | 2008-02-21 (1908 days ago) |
| 辞典の虫 | 2008-02-16 (1914 days ago) |
| Tommy6 | 2008-02-13 (1917 days ago) |
| Peccafly | 2008-02-10 (1920 days ago) |
| Uryah | 2008-02-10 (1920 days ago) |
| Kstigarbha | 2008-02-03 (1926 days ago) |
| Bukki | 2008-02-03 (1927 days ago) |
| Bellcricket | 2008-02-02 (1927 days ago) |
| Sylphie | 2008-02-01 (1929 days ago) |
| Pica | 2008-02-01 (1929 days ago) |
| Quatro | 2008-01-30 (1930 days ago) |
| Miya.m | 2008-01-29 (1931 days ago) |
| Londonbashi | 2008-01-28 (1932 days ago) |
| Kickaha | 2008-01-27 (1933 days ago) |
| Co.kyoto | 2008-01-27 (1933 days ago) |
| Hirokun | 2008-01-27 (1933 days ago) |
| Complex01 | 2008-01-27 (1934 days ago) |
| 千代林檎 | 2008-01-26 (1935 days ago) |
| Lonicera | 2008-01-25 (1935 days ago) |
| ZERBERUS | 2008-01-25 (1935 days ago) |
| Hyolee2 | 2008-01-25 (1936 days ago) |
| Tangotango | 2008-01-18 (1942 days ago) |
| Lemonsquash | 2008-01-16 (1944 days ago) |
| Knua | 2008-01-12 (1948 days ago) |
| Michey.M | 2008-01-05 (1955 days ago) |
| SS95 | 2007-12-27 (1964 days ago) |
| Suzuyoshinine | 2007-12-21 (1970 days ago) |
| Horlicks | 2007-12-21 (1971 days ago) |
| Volfgang | 2007-12-16 (1975 days ago) |
| Watermint | 2007-12-14 (1977 days ago) |
| Schu | 2007-12-14 (1978 days ago) |
| Tietew | 2007-12-10 (1982 days ago) |
| Dekimasu | 2007-12-04 (1988 days ago) |
| Swind | 2007-12-03 (1989 days ago) |
| Kareha | 2007-12-01 (1990 days ago) |
| Tamtarm | 2007-11-29 (1992 days ago) |
| Clarin | 2007-11-29 (1993 days ago) |
| Kasuga | 2007-11-28 (1993 days ago) |
| 11ChamOK | 2007-11-28 (1993 days ago) |
| Kurihaya | 2007-11-28 (1993 days ago) |
| Lusheeta | 2007-11-28 (1993 days ago) |
| Noraneko | 2007-11-28 (1994 days ago) |
| Kotodama-Reverse | 2007-11-26 (1995 days ago) |
| T-coco | 2007-11-26 (1995 days ago) |
| Numerike | 2007-11-26 (1995 days ago) |
| 霧木諒二 | 2007-11-26 (1995 days ago) |
| Takot | 2007-11-25 (1996 days ago) |
| Himetv | 2007-10-24 (2029 days ago) |
| Remington | 2007-10-20 (2032 days ago) |
| SantaClaus | 2007-09-25 (2057 days ago) |
| T.Saito | 2007-09-24 (2058 days ago) |
| Tiens | 2007-09-18 (2065 days ago) |
| Coryjp | 2007-09-05 (2077 days ago) |
| Muyo | 2007-09-03 (2079 days ago) |
| Ribbon | 2007-08-16 (2098 days ago) |
| Penpen | 2007-08-08 (2106 days ago) |
| PiaCarrot | 2007-08-04 (2109 days ago) |
| YouShow | 2007-07-27 (2117 days ago) |
| Chinneeb | 2007-07-03 (2142 days ago) |
| HALPHA | 2007-07-01 (2143 days ago) |
| Tonync | 2007-05-17 (2188 days ago) |
| Araisyohei | 2007-04-21 (2214 days ago) |
| 七星 | 2007-04-21 (2215 days ago) |
| LQVX | 2007-04-16 (2220 days ago) |
| Goncyan | 2007-04-05 (2231 days ago) |
| 端くれの錬金術師 | 2007-04-02 (2234 days ago) |
| Matsumomushi | 2007-03-25 (2242 days ago) |
| かんがへなし | 2007-03-17 (2250 days ago) |
| Rocky7 | 2007-03-16 (2250 days ago) |
| Lonchi** | 2007-03-09 (2258 days ago) |
| っ | 2007-02-17 (2277 days ago) |
| Kkkdc | 2007-02-16 (2278 days ago) |
| Diagraph01 | 2007-02-06 (2289 days ago) |
| Pachayachachic | 2007-02-03 (2292 days ago) |
| Adr6721 | 2007-02-01 (2294 days ago) |
| Su-no-G | 2007-02-01 (2294 days ago) |
100 rows in set (1 min 2.26 sec)
id/Bahasa Indonesian [edit]
last update: 2008-03-28 (1873 days ago)
| Name | Last edit |
|---|---|
| Azmi1995 | 2008-03-25 (1876 days ago) |
| IDRex | 2008-03-25 (1876 days ago) |
| IvanLanin | 2008-03-22 (1878 days ago) |
| Mimihitam | 2008-03-19 (1881 days ago) |
| Master2841 | 2008-03-08 (1892 days ago) |
| Chriswaterguy | 2008-03-07 (1894 days ago) |
| Borgx | 2008-03-04 (1897 days ago) |
| Kandar | 2008-02-18 (1911 days ago) |
| Meursault2004 | 2008-02-12 (1917 days ago) |
| Dragunova | 2008-02-08 (1922 days ago) |
| Hariadhi | 2007-08-03 (2111 days ago) |
| Irwangatot | 2007-06-12 (2162 days ago) |
| Anggoro | 2006-12-07 (2350 days ago) |
| Winana | 2006-11-22 (2364 days ago) |
| Anggreani | 2006-08-04 (2475 days ago) |
| HarisX | 2006-05-12 (2559 days ago) |
| Zaidpjd | 2005-11-20 (2731 days ago) |
| Widhiantoro | 2005-11-18 (2734 days ago) |
| Sudiryo | 2005-11-18 (2734 days ago) |
| *drew | 2005-11-08 (2744 days ago) |
20 rows in set (51.73 sec)
ro/Romanian [edit]
last update: 2008-03-28 (1873 days ago)
| Name | Last edit |
|---|---|
| SCriBu | 2008-02-24 (1905 days ago) |
| Cuman | 2008-01-25 (1935 days ago) |
| Desiphral | 2008-01-16 (1944 days ago) |
| IulianU | 2008-01-14 (1946 days ago) |
| AQUA | 2007-12-20 (1971 days ago) |
| Romihaitza | 2007-11-27 (1994 days ago) |
| BlueMonday | 2007-11-24 (1997 days ago) |
| Dorothea | 2007-11-19 (2002 days ago) |
| Bogdan | 2007-10-22 (2030 days ago) |
| Mocu | 2007-06-09 (2165 days ago) |
| Lorandka | 2007-01-05 (2320 days ago) |
| TSO1D | 2006-12-01 (2355 days ago) |
| Ronline | 2006-11-18 (2369 days ago) |
| Dmaftei | 2006-10-05 (2413 days ago) |
| Evosphere | 2006-07-14 (2495 days ago) |
| Orioane | 2006-06-29 (2510 days ago) |
| Victort | 2006-01-02 (2689 days ago) |
| NazismIsntCool | 2005-11-06 (2746 days ago) |
18 rows in set (55.09 sec)
sv/Swedish [edit]
last update: 2008-03-28 (1873 days ago)
| Name | Last edit |
|---|---|
| Micke | 2008-03-27 (1873 days ago) |
| Robertgreer | 2008-03-26 (1874 days ago) |
| M.M.S. | 2008-03-26 (1874 days ago) |
| Habj | 2008-03-25 (1875 days ago) |
| SvHannibal | 2008-03-24 (1876 days ago) |
| Moralist | 2008-03-24 (1876 days ago) |
| Boivie | 2008-03-14 (1886 days ago) |
| Mikez | 2008-03-04 (1897 days ago) |
| Riggwelter | 2008-02-16 (1913 days ago) |
| Malhonen | 2008-02-13 (1916 days ago) |
| LX | 2008-01-15 (1945 days ago) |
| Skomakarn | 2008-01-07 (1954 days ago) |
| Johngreen | 2007-12-04 (1987 days ago) |
| RaSten | 2007-10-21 (2031 days ago) |
| Pcongre | 2007-10-13 (2040 days ago) |
| Klibbnisse | 2007-08-27 (2086 days ago) |
| Edricson | 2007-08-09 (2104 days ago) |
| Smiddle | 2007-04-21 (2214 days ago) |
| Skagedal | 2007-04-01 (2234 days ago) |
| Yenx | 2007-01-08 (2317 days ago) |
| Kruosio | 2006-12-11 (2345 days ago) |
| NERIUM | 2006-06-29 (2511 days ago) |
| Jniemenmaa | 2006-06-12 (2527 days ago) |
| Marsve | 2006-05-05 (2565 days ago) |
| Aktalo | 2006-01-23 (2667 days ago) |
| Diyako | 2006-01-17 (2674 days ago) |
| Storpilot | 2005-12-12 (2709 days ago) |
| Scoo | 2005-12-08 (2713 days ago) |
| Qwm | 2005-11-16 (2736 days ago) |
| ShineB | 2005-09-29 (2783 days ago) |
| Tehvata | 2005-07-01 (2873 days ago) |
31 rows in set (3 min 51.74 sec)
uk/Ukrainian [edit]
last update: 2008-03-28 (1873 days ago)
| Name | Last edit |
|---|---|
| Ahonc | 2008-03-25 (1875 days ago) |
| Riwnodennyk | 2008-03-25 (1875 days ago) |
| A1 | 2008-02-11 (1918 days ago) |
| Ilyaroz | 2008-01-27 (1934 days ago) |
| Movses | 2008-01-23 (1937 days ago) |
| Yakudza | 2007-11-20 (2001 days ago) |
| Minia | 2007-11-18 (2003 days ago) |
| EvgenyGenkin | 2007-11-13 (2008 days ago) |
| DmRodionov | 2007-08-25 (2088 days ago) |
| Mikolasz | 2007-07-14 (2130 days ago) |
| Hayk | 2007-07-07 (2137 days ago) |
| Panas | 2007-07-01 (2143 days ago) |
| Yms | 2007-04-09 (2226 days ago) |
| Nevermind | 2006-12-18 (2338 days ago) |
| Angryxpeh | 2006-12-14 (2342 days ago) |
| AndriyK | 2006-11-24 (2362 days ago) |
| Martynenka | 2006-11-08 (2378 days ago) |
| Redsunrising | 2006-11-04 (2382 days ago) |
| Ornil | 2006-11-03 (2383 days ago) |
| Jan-ivan | 2005-11-14 (2737 days ago) |
| Inetd | 2005-03-26 (2970 days ago) |
21 rows in set (1 min 55.31 sec)
vi/Vietnamese [edit]
last update: 2008-03-28 (1873 days ago)
| Name | Last edit |
|---|---|
| Vinhtantran | 2008-03-27 (1874 days ago) |
| Neoneurone | 2007-11-15 (2007 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
}}
|
