Page MenuHomePhabricator
Paste P9232

Top linked-to user talk pages on enwiki
ActivePublic

Authored by Catrope on Oct 2 2019, 8:42 PM.
Tags
None
Referenced Files
F30526017: raw.txt
Oct 2 2019, 8:42 PM
Subscribers
None
[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)