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