Page MenuHomePhabricator
Paste P9235

Top linked-to user talk pages on frwiki
ActivePublic

Authored by Catrope on Oct 2 2019, 9:09 PM.
Tags
None
Referenced Files
F30526381: raw.txt
Oct 2 2019, 9:09 PM
Subscribers
None
[frwiki]> 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 |
+---------------------------+--------+
| Salebot | 286146 |
| Gribeco | 139303 |
| VIGNERON | 93454 |
| Trizek | 92719 |
| Sammyday | 90727 |
| Frakir | 88154 |
| Moumou82 | 85723 |
| Cedalyon | 83486 |
| Erdrokan | 81105 |
| YanikB | 65330 |
| Gratus | 59809 |
| Chris a liege | 56866 |
| Lomita | 53978 |
| Binabik | 52396 |
| 6PO | 48667 |
| Rome2 | 48352 |
| Chatsam | 45234 |
| Symac | 45065 |
| Superjuju10 | 42392 |
| Mathis B | 41884 |
| Jules78120 | 36119 |
| Omnilaika02 | 33703 |
| Arthur Crbz | 30423 |
| Julien1978 | 29934 |
| Phe | 29763 |
| Etiennekd | 29460 |
| VateGV | 29029 |
| Bastenbas | 27901 |
| Framawiki | 27652 |
| 0x010C | 27451 |
| 3Jo7 | 26998 |
| Mattho69 | 24793 |
| HenriDavel | 24043 |
| Le sourcier de la colline | 23880 |
| Suprememangaka | 23820 |
| Orikrin1998 | 23635 |
| Olivier LPB | 23303 |
| Kormin | 22744 |
| Ltrlg | 22166 |
| Euterpia | 21447 |
| Floflo | 20102 |
| Apipo1907 | 19570 |
| Akadians | 19567 |
| Soboky | 19140 |
| Hégésippe Cormier | 19007 |
| Niridya | 18177 |
| Darkoneko | 18154 |
| Patrick Rogel | 18008 |
| Esprit Fugace | 17757 |
| Kelson | 17487 |
| Enrevseluj | 17049 |
| Philippe rogez | 16740 |
| Escaladix | 16703 |
| Mathieudu68 | 16500 |
| GrandCelinien | 15674 |
| IuvenesIos | 14922 |
| Guillaume70 | 14909 |
| Theoliane | 14904 |
| Litterae | 14496 |
| Harrieta171 | 13591 |
| Kyro | 13316 |
| Ariel Provost | 13279 |
| Cédric Boissière | 13219 |
| Macadam1 | 12605 |
| ℳ𝒄𝓛𝒖𝒔𝒉FR | 12150 |
| Letartean | 12133 |
| JessydeVilly | 11709 |
| ZéroBot | 11594 |
| Quentinv57 | 11575 |
| 3(MG)² | 11360 |
| Azurfrog | 11128 |
| Schlum | 11086 |
| Rifford | 10996 |
| OT38 | 10487 |
| Kropotkine 113 | 10479 |
| LPLT | 10443 |
| Do not follow | 10207 |
| Hatonjan | 10191 |
| VinceReddington | 10114 |
| DocteurCosmos | 9893 |
| Gemini1980 | 9621 |
| Arroser | 9267 |
| Padawane | 9206 |
| Woozz | 9179 |
| Habertix | 9167 |
| Speculos | 9002 |
| Céréales Killer | 8912 |
| Auregann | 8901 |
| Titlutin | 8888 |
| TigH | 8843 |
| Phe-bot | 8709 |
| Stef48 | 8567 |
| Jean-Jacques Georges | 8425 |
| Matpib | 8328 |
| Jacques Ballieu | 8211 |
| Xic667 | 8178 |
| Éric Messel | 8013 |
| Pixeltoo | 7651 |
| Arcyon37 | 7595 |
| Escalabot | 7491 |
+---------------------------+--------+
100 rows in set (13.20 sec)