[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)