Page MenuHomePhabricator
Paste P9233

Top linked-to user talk pages on metawiki
ActivePublic

Authored by Catrope on Wed, Oct 2, 8:54 PM.
mysql:research@dbstore1003.eqiad.wmnet [metawiki]> 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 |
+----------------------------+---------+
| Meta-Wiki Welcome | 8107657 |
| COIBot | 121256 |
| Billinghurst | 28355 |
| Mikhailov Kusserow | 4547 |
| Tegel | 4195 |
| I JethroBT (WMF) | 3896 |
| Liuxinyu970226 | 3510 |
| Herbythyme | 3392 |
| Mike.lifeguard | 2550 |
| MarcoAurelio | 2464 |
| MediaWiki message delivery | 2238 |
| PiRSquared17 | 2130 |
| Trijnstel | 2070 |
| Spacebirdy | 2065 |
| Ottava Rima | 1980 |
| Ajraddatz | 1832 |
| Sj | 1675 |
| Dferg | 1606 |
| Defender | 1605 |
| Stryn | 1595 |
| DerHexer | 1535 |
| Teles | 1526 |
| Rschen7754 | 1425 |
| Thogo | 1423 |
| Thehelpfulone | 1418 |
| Cbrown1023 | 1355 |
| NickK | 1341 |
| Bluerasberry | 1277 |
| Matiia | 1265 |
| Abigor | 1261 |
| Slade | 1246 |
| Mardetanha | 1242 |
| Beetstra | 1236 |
| Pmlineditor | 1231 |
| Ruslik0 | 1206 |
| Ruy Pugliesi | 1174 |
| Glaisher | 1160 |
| Alexmar983 | 1147 |
| Snowolf | 1139 |
| Barras | 1107 |
| StevenJ81 | 1056 |
| Savh | 1048 |
| Peteforsyth | 1032 |
| Vituzzu | 1013 |
| Dungodung | 976 |
| Syum90 | 959 |
| Mathonius | 927 |
| Shanmugamp7 | 919 |
| AWang (WMF) | 914 |
| Steinsplitter | 857 |
| Vogone | 855 |
| Alexanderps | 853 |
| Cometstyles | 834 |
| Xaosflux | 830 |
| Cirt | 811 |
| WizardOfOz | 804 |
| Shizhao | 780 |
| Majorly | 779 |
| Pine | 779 |
| Risker | 771 |
| MER-C | 768 |
| Mike Peel | 755 |
| Wolliff | 752 |
| Another Believer | 749 |
| Ijon | 749 |
| Davidpar | 746 |
| Anonymous Dissident | 745 |
| Quentinv57 | 732 |
| Nick1915 | 707 |
| Cekli829 | 705 |
| Innv | 703 |
| Doc James | 699 |
| Micki | 693 |
| Fastily | 688 |
| MBisanz | 683 |
| Jonathan Balima WMFr | 672 |
| Mjohnson (WMF) | 656 |
| Lar | 651 |
| Pharos | 646 |
| Samwalton9 (WMF) | 644 |
| CindyDavidWMFr | 639 |
| Hoo man | 630 |
| Matanya | 626 |
| QuiteUnusual | 622 |
| Tiptoety | 621 |
| A. B. | 615 |
| Juliancolton | 615 |
| NaBUru38 | 607 |
| Aphaia | 602 |
| Slowking4 | 598 |
| Base | 592 |
| Jusjih | 591 |
| John Vandenberg | 581 |
| RadiX | 579 |
| WereSpielChequers | 574 |
| Pbsouthwood | 569 |
| NahidSultan | 562 |
| Wittylama | 553 |
| Varnent | 547 |
| Yeza | 542 |
+----------------------------+---------+
100 rows in set (1 min 5.32 sec)