Page MenuHomePhabricator
Paste P9234

Top linked-to user talk pages on dewiki
ActivePublic

Authored by Catrope on Wed, Oct 2, 9:08 PM.
[dewiki]> select user_name, count(*) as c from user join pagelinks on pl_title=REPLACE(user_name, ' ', '_') and pl_namespace=3 group by user_name order by c desc limit 100;
+------------------------------+--------+
| user_name | c |
+------------------------------+--------+
| GiftBot | 205376 |
| Xqbot | 28129 |
| Lutheraner | 24663 |
| XenonX3 | 22360 |
| Nolispanmo | 13893 |
| Eingangskontrolle | 12059 |
| Schnabeltassentier | 9907 |
| Matthiasb | 9803 |
| Pittimann | 9686 |
| Hyperdieter | 8910 |
| He3nry | 8886 |
| C-M | 8757 |
| Jergen | 8720 |
| Doc.Heintz | 8560 |
| Horst Gräbner | 8166 |
| Spuk968 | 7955 |
| Regi51 | 7901 |
| Kriddl | 7894 |
| Chaddy | 7853 |
| Wahrerwattwurm | 7703 |
| Sicherlich | 7480 |
| H7 | 7465 |
| Zinnmann | 7437 |
| Marcus Cyron | 7435 |
| H-stt | 7433 |
| JD | 7406 |
| Alnilam | 7403 |
| Wo st 01 | 7388 |
| Uwe Gille | 7317 |
| Gripweed | 7179 |
| Codc | 7165 |
| Kuebi | 7151 |
| Nicola | 7101 |
| DerHexer | 7088 |
| PaterMcFly | 7064 |
| Rax | 6969 |
| Felix Stember | 6816 |
| Perrak | 6678 |
| Peng | 6629 |
| Pentachlorphenol | 6593 |
| Jón | 6478 |
| Karsten11 | 6474 |
| MBq | 6373 |
| Emes | 6359 |
| Oliver S.Y. | 6326 |
| WWSS1 | 6281 |
| Drahreg01 | 6141 |
| Schlesinger | 6100 |
| Ra'ike | 6016 |
| WolfgangRieger | 5972 |
| Informationswiedergutmachung | 5920 |
| Label5 | 5916 |
| Don-kun | 5857 |
| Man77 | 5644 |
| Grey Geezer | 5627 |
| Scooter | 5625 |
| Liesel | 5618 |
| Andy king50 | 5506 |
| Majo statt Senf | 5283 |
| Fossa | 5180 |
| Si! SWamP | 5170 |
| Orci | 5121 |
| Jbergner | 5097 |
| Rainer Zenz | 5042 |
| AndreasPraefcke | 4993 |
| J budissin | 4975 |
| MediaWiki message delivery | 4972 |
| Hannes 24 | 4971 |
| Zollernalb | 4966 |
| Kurator71 | 4894 |
| EvaK | 4887 |
| Schniggendiller | 4762 |
| W!B: | 4760 |
| Martin1978 | 4748 |
| Doc Taxon | 4713 |
| FritzG | 4675 |
| Braveheart | 4662 |
| Tilla | 4621 |
| Lómelinde | 4353 |
| Xocolatl | 4318 |
| Kh80 | 4306 |
| Mazbln | 4305 |
| Rosenzweig | 4261 |
| Goesseln | 4256 |
| Xqt | 4232 |
| Phi | 4218 |
| Church of emacs | 4189 |
| Emergency doc | 4164 |
| Wahldresdner | 4162 |
| Artregor | 4159 |
| Capaci34 | 4157 |
| Didionline | 4066 |
| Achim Raschka | 4038 |
| MBurch | 4028 |
| Redlinux | 4027 |
| Jensbest | 4023 |
| Cvf-ps | 4012 |
| Berihert | 3993 |
| Koenraad | 3923 |
| Atamari | 3902 |
+------------------------------+--------+
100 rows in set (9.99 sec)