[enwiki]> 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       |
+----------------------------+---------+
| ClueBot NG                 | 2017150 |
| InternetArchiveBot         |  914825 |
| ClueBot                    |  468609 |
| Materialscientist          |  395292 |
| XLinkBot                   |  257842 |
| HasteurBot                 |  163684 |
| MediaWiki message delivery |  160564 |
| Oshwah                     |  149026 |
| HostBot                    |  147690 |
| Cyberbot II                |  147285 |
| Gilliam                    |  128008 |
| I dream of horses          |  127439 |
| BracketBot                 |  111583 |
| Gene93k                    |  106988 |
| Widr                       |  103279 |
| Jim1138                    |   96419 |
| J.delanoy                  |   88113 |
| Shellwood                  |   82564 |
| BetacommandBot             |   79898 |
| Alansohn                   |   77122 |
| CAPTAIN RAJU               |   75088 |
| Donner60                   |   71513 |
| Alexf                      |   71409 |
| DGG                        |   71055 |
| DPL bot                    |   69410 |
| Mattythewhite              |   69115 |
| Serols                     |   68303 |
| Tide rolls                 |   68140 |
| Northamerica1000           |   67575 |
| SwisterTwister             |   62855 |
| NawlinWiki                 |   62251 |
| Excirial                   |   62206 |
| Drmies                     |   57379 |
| JMHamo                     |   54574 |
| CorenSearchBot             |   53611 |
| CLCStudent                 |   52795 |
| Diannaa                    |   51376 |
| JohnCD                     |   51195 |
| Pseudomonas                |   50257 |
| SineBot                    |   49685 |
| Cirt                       |   49677 |
| Gogo Dodo                  |   47733 |
| Favonian                   |   47520 |
| PseudoBot                  |   45234 |
| Ian (Wiki Ed)              |   44684 |
| Binksternet                |   43878 |
| Discospinster              |   43540 |
| ImageTaggingBot            |   42464 |
| C.Fred                     |   41704 |
| JamesBWatson               |   41634 |
| KylieTastic                |   40783 |
| Ronhjones                  |   39652 |
| Edgar181                   |   39471 |
| Epbr123                    |   39349 |
| Pinethicket                |   38225 |
| Ohnoitsjamie               |   38013 |
| Onel5969                   |   37414 |
| Wikipelli                  |   36867 |
| COIBot                     |   36765 |
| Acroterion                 |   36611 |
| JJMC89                     |   36528 |
| Legacypac                  |   35705 |
| ReferenceBot               |   35631 |
| MusikAnimal                |   35222 |
| Sfan00 IMG                 |   34501 |
| Orangemike                 |   33844 |
| STBotI                     |   33797 |
| GiantSnowman               |   33602 |
| Red Director               |   33345 |
| DASHBot                    |   32944 |
| Dcirovic                   |   32655 |
| Coren                      |   32553 |
| Robert McClenon            |   32487 |
| B-bot                      |   32273 |
| DVdm                       |   32266 |
| CommonsNotificationBot     |   32211 |
| Mark Arsten                |   31293 |
| Wtmitchell                 |   31144 |
| BJBot                      |   31107 |
| Bongwarrior                |   31025 |
| NeilN                      |   30903 |
| MBisanz                    |   30840 |
| Eeekster                   |   30807 |
| K6ka                       |   30466 |
| TenPoundHammer             |   29801 |
| Flyer22 Reborn             |   29637 |
| Biografer                  |   29416 |
| Juliancolton               |   29123 |
| Lugia2453                  |   28883 |
| Stefan2                    |   28804 |
| Walter Görlitz             |   28239 |
| Jimfbleak                  |   28126 |
| IronGargoyle               |   28116 |
| Chzz                       |   27974 |
| Marek69                    |   27692 |
| Community Tech bot         |   27521 |
| Theroadislong              |   27432 |
| Rosiestep                  |   26618 |
| Abelmoschus Esculentus     |   26356 |
| Piotrus                    |   26309 |
+----------------------------+---------+
100 rows in set (1 min 30.74 sec)