From Wikimedia Foundation Governance Wiki
SELECT
SUBSTRING_INDEX(page_title, '/', 1),
COUNT(*)
FROM page
WHERE page_namespace IN (2,3)
GROUP BY SUBSTRING_INDEX(page_title, '/', 1)
ORDER BY COUNT(*) DESC;
+-------------------------------------+----------+
| SUBSTRING_INDEX(page_title, '/', 1) | COUNT(*) |
+-------------------------------------+----------+
| Cbarr | 115 |
| Tom- | 46 |
| Seddon | 44 |
| Cbrown1023 | 25 |
| JSeddon | 23 |
| Pcoombe | 21 |
| DavidStrauss | 20 |
| Jalexander | 20 |
| Jseddon | 18 |
| NeilK | 17 |
| Jd | 14 |
| Pathoschild | 12 |
| Az1568 | 12 |
| Mono | 11 |
| Yuyu | 10 |
| Monomium | 10 |
| Jsoby | 10 |
| Meno25 | 9 |
| Legoktm | 8 |
| Thehelpfulone | 7 |
| Pgehres_(WMF) | 5 |
| MHolmquist | 5 |
| Tim_Starling | 5 |
| Isarra | 5 |
| Philippe_(WMF) | 5 |
| Alexsh | 5 |
| Anthere | 5 |
| Korg | 5 |
| Aphaia | 5 |
| Azariv | 5 |
| Sean_Whitton | 5 |
| Jean-Christophe_Chazalette | 4 |
| Daniel | 4 |
| Geraki | 4 |
| Eloquence | 4 |
| Timwi | 4 |
| MZMcBride | 4 |
| Daniel_Mayer | 4 |
| Chb | 4 |
| AKlapper | 4 |
| Suisui | 4 |
| Nemo_bis | 4 |
| MarcoAurelio | 4 |
| っ | 4 |
| Habj | 4 |
| Walter | 3 |
| Amire80 | 3 |
| Rjd0060 | 3 |
| Fetchcomms | 3 |
| Trần_Nguyễn_Minh_Huy | 3 |
| NonvocalScream | 3 |
| SPQRobin | 3 |
| Elian | 3 |
| ABCD | 3 |
| Dungodung | 3 |
| Killiondude | 3 |
| Yonidebest | 3 |
| Jamesofur | 3 |
| Jvandavier | 3 |
| Emperyan | 3 |
| Spacebirdy | 3 |
| AGK | 3 |
| Jwild | 3 |
| Ali_Haidar_Khan | 3 |
| JayWalsh | 3 |
| Huji | 3 |
| Tfinc | 3 |
| Pete_Forsyth_(WMF) | 3 |
| Zackexley | 3 |
| Mbecker | 3 |
| Guillom | 3 |
| Mike.lifeguard | 3 |
| Effeietsanders | 3 |
| Sj | 3 |
| Hwalls | 3 |
| PiRSquared17 | 3 |
| Kaganer | 3 |
| Mike_Peel | 3 |
| Erwin | 3 |
| Waldir | 3 |
| Eleassar | 3 |
| Ijon | 3 |
| Gbyrd | 2 |
| Stevie_Benton | 2 |
| Jacob.jose | 2 |
| Trevor_Parscal | 2 |
| Jtmorgan | 2 |
| LeslieCarr | 2 |
| AVrana | 2 |
| Archenzo | 2 |
| Nlaxstrom | 2 |
| Drini | 2 |
| SLakshmanan | 2 |
| Sebmol | 2 |
| Hahnw | 2 |
| Tango | 2 |
| Kchelini | 2 |
| Akl | 2 |
| BJones_(WMF) | 2 |
| REX | 2 |
| Slasner | 2 |
| Ilario | 2 |
| Tim_Shell | 2 |
| Jmh649 | 2 |
| Wpedzich | 2 |
| Kurt_Jansson | 2 |
| Maryana_(WMF) | 2 |
| Mschlindwein | 2 |
| Bnewstead | 2 |
| Gciampaglia | 2 |
| Sthommen | 2 |
| Jtud | 2 |
| Li-sung | 2 |
| AWight | 2 |
| Messedrocker | 2 |
| ArielGlenn | 2 |
| Cdeubner | 2 |
| Ppena | 2 |
| Drosenthal | 2 |
| Hayabusa_future | 2 |
| Tangotango | 2 |
| Jennifer_Riggs | 2 |
| WarX | 2 |
| Kgladstone | 2 |
| Miya | 2 |
| BJorsch | 2 |
| Dan | 2 |
| RKwon | 2 |
| Sma | 2 |
| Isam | 2 |
| John_Vandenberg | 2 |
| Wutsje | 2 |
| Kwadhwa | 2 |
| Massimiliano_Lincetto | 2 |
| Anders_Wennersten | 2 |
| Boberger | 2 |
| David_Gerard | 2 |
| Rmacgeorge | 2 |
| Fflorin | 2 |
| Sthottingal | 2 |
| JamesR | 2 |
| Ugur_Basak | 2 |
| Ljames | 2 |
| Notafish | 2 |
| Chadspencer | 2 |
| Preilly | 2 |
| Dtaraborelli | 2 |
| SPage | 2 |
| Sgardner | 2 |
| Hfung | 2 |
| Tanvir_Rahman | 2 |
| Jeremy_Tobacman | 2 |
| Wayne_Mackintosh | 2 |
| Khorn_(WMF) | 2 |
| MWalker | 2 |
| Alers | 2 |
| Pavlo_Shevelo | 2 |
| RKwon_(WMF) | 2 |
| Ellywa | 2 |
| Yann | 2 |
| Kwj2772 | 2 |
| AndrewCates | 2 |
| NNahata_(WMF) | 2 |
| Dbl2010 | 2 |
| Finnrind | 2 |
| Stu | 2 |
| VBamba_(WMF) | 2 |
| Juxn | 2 |
| Lodewijk | 2 |
| Abartov | 2 |
| Mhernandez | 2 |
| Arria_Belli | 2 |
| Nraval | 2 |
| Chaos | 2 |
| Prevert | 2 |
| SPrashar | 2 |
| Shaihulud | 2 |
| Hillgentleman | 2 |
| Tarawneh | 2 |
| Jessamyn | 2 |
| MYukie_(WMF) | 2 |
| Alex756 | 2 |
| Mokapantages | 2 |
| BarkingFish | 2 |
| Daniel_Kinzler_(WMDE) | 2 |
| Rand_Montoya | 2 |
| Smerrick | 2 |
| Itzike | 2 |
| Jon_Harald_Søby | 2 |
| Kzhr | 2 |
| ACrush | 2 |
| Mathonius | 2 |
| Angela | 2 |
| Brian0918 | 2 |
| Dchen_(WMF) | 2 |
| Flcelloguy | 2 |
| Samat | 2 |
| SueG | 2 |
| VasilievVV | 2 |
| Looxix | 2 |
| Abigor | 2 |
| Michael_Snow | 2 |
| Obradovic_Goran | 2 |
| Chase_me_ladies,_I'm_the_Cavalry | 2 |
| E | 2 |
| Hshammaa | 2 |
| Tbayer | 2 |
| Jimbo_Wales | 2 |
| Whahn | 2 |
| Bdamokos | 2 |
| Pedist | 2 |
| Rbraceysherman | 2 |
| Fluffernutter | 2 |
| JForrester | 2 |
| Tipiac | 2 |
| Jorm | 2 |
| LLogan | 2 |
| Ndannibale | 2 |
| Brian_McNeil | 2 |
| Phoebe | 2 |
| Ddavis | 2 |
| RobLa-WMF | 2 |
| Sannse | 2 |
| GerardM | 2 |
| Sue_Gardner | 2 |
| VeroniqueKessler | 2 |
| Lyzzy | 2 |
| Achild | 2 |
| Mido | 2 |
| Odder | 2 |
| Putnik | 2 |
| EOrtega | 2 |
| Shuhari | 2 |
| Who | 2 |
| Daniel_Phelps | 2 |
| Emufarmers | 2 |
| JMathewson | 2 |
| Tle | 2 |
| ZBernard | 2 |
| LWelling | 2 |
| Maximaximax | 2 |
| Anya_Shyrokova | 2 |
| Brianmc | 2 |
| Pholm_(WMF) | 2 |
| Dfoy | 2 |
| Sara_Crouse | 2 |
| Vgrigas | 2 |
| KLove_(WMF) | 2 |
| M7 | 2 |
| Ahalfaker | 2 |
| Midom | 2 |
| Awhite | 2 |
| Olivneh | 2 |
| Christine_(WMF) | 2 |
| Pyb | 2 |
| ESanders_(WMF) | 2 |
| Jkelly | 2 |
| Wiki_blue | 2 |
| ManuelGR | 2 |
| Alin | 2 |
| Moushira | 2 |
| Danny | 2 |
| Frieda | 2 |
| Spanigrahi | 2 |
| JQadir | 2 |
| Tlogmer | 2 |
| Lankiveil | 2 |
| Aotto | 2 |
| Brion_VIBBER | 2 |
| Phroziac | 2 |
| Dgultekin | 2 |
| Sbouterse | 2 |
| Sumanah | 2 |
| Jcuriel | 2 |
| Vipuser | 2 |
| Kaare | 2 |
| MBisanz | 2 |
| Ahonc | 2 |
| Awjrichards | 2 |
| Oscar | 2 |
| Church_of_emacs | 2 |
| Pyoungmeister | 2 |
| The_wub | 2 |
| Jking | 2 |
| Wikitanvir | 2 |
| Mpande | 2 |
| Beria | 2 |
| Peteforsyth | 2 |
| Danny_B. | 2 |
| Redux | 2 |
| Erosen | 2 |
| Sstierch | 2 |
| Jredmond | 2 |
| Zanimum | 2 |
| Lar | 2 |
| ARoberts | 2 |
| Mbimmler | 2 |
| Nick1915 | 2 |
| Cary_Bass | 2 |
| RoseParks | 2 |
| Swatjester | 2 |
| Vogone | 2 |
| MBlack_(WMF) | 2 |
| Ainali | 2 |
| Pabix | 2 |
| QGil | 2 |
| Egg | 2 |
| IPoirier_(WMF) | 2 |
| Jking_(WMF) | 2 |
| Wikiwooster | 2 |
| Krinkle | 2 |
| Mardetanha | 2 |
| Alison_Wheeler | 2 |
| Mpaulson_(WMF) | 2 |
| PeterSymonds | 2 |
| Danutz | 2 |
| Gaillimh | 2 |
| Steinninn | 2 |
| JTrias | 2 |
| Ldavis | 2 |
| ASengupta | 2 |
| Mbrown | 2 |
| Aprabhala | 2 |
| Nikola_Smolenski | 2 |
| PinkAmpersand | 2 |
| Runab_WMF | 2 |
| Schutz | 2 |
| Gyoung | 2 |
| Szhang_(WMF) | 2 |
| Jdavis | 2 |
| Waerth | 2 |
| Kaldari | 2 |
| MBrown_(WMF) | 2 |
| Akapoor | 2 |
| Mikegodwin | 2 |
| DFox | 2 |
| Qgil | 2 |
| ElC | 2 |
| Sky_Harbor | 2 |
| Ibaker | 2 |
| Jlewis | 2 |
| Wing | 2 |
| Kul | 2 |
| Alno | 2 |
| Mpinchuk | 2 |
| Billinghurst | 2 |
| Pfctdayelise | 2 |
| Reedy | 2 |
| Everton137 | 2 |
| Gbrigham | 2 |
| Jack_Phoenix | 2 |
| とある白い猫 | 2 |
| ASengupta_(WMF) | 2 |
| Mdennis | 2 |
| Pitke | 2 |
| Drbug | 2 |
| Ryo | 2 |
| Jdforrester | 2 |
| Kat_Walsh | 2 |
| MFlaschen_(WMF) | 2 |
| Akhanna | 2 |
| MikkoM | 2 |
| BJones | 2 |
| R.O.C | 2 |
| Slaporte_(WMF) | 2 |
| Thunderhead | 2 |
| Jlewis(WMF) | 2 |
| Wolliff | 2 |
| Kulac | 2 |
| Mark_Pellegrini | 2 |
| Alvaro | 2 |
| Mroth | 2 |
| Bishdatta | 2 |
| Pgehres | 2 |
| Datrio | 2 |
| Rfarrand | 2 |
| Fantasy | 2 |
| AMiller_(WMF) | 1 |
| JGonera_(WMF) | 1 |
| Slavik_IVANOV | 1 |
| Polimerek | 1 |
| Ccivil | 1 |
| MGodwin | 1 |
| LVilla_(WMF) | 1 |
| Mindspillage | 1 |
| ZFilipin | 1 |
| DamianFinol | 1 |
| Electric_goat | 1 |
| 1ne | 1 |
| Dkultura | 1 |
| Pmachon | 1 |
| AVossbrinck_(WMF) | 1 |
| Jason_Quinn | 1 |
| Ssastry | 1 |
| Chandres | 1 |
| Alchimista | 1 |
| Marcus_Cyron | 1 |
| Patti_Melton | 1 |
| 555 | 1 |
| Dschoonover | 1 |
| Pmaharaj | 1 |
| Mzlla | 1 |
| PhiLiP | 1 |
| Gemijssen | 1 |
| Julien_Fayolle | 1 |
| Amgine | 1 |
| Aaharoni | 1 |
| Jeremyb | 1 |
| Mhalprin | 1 |
| ArnoLagrange | 1 |
| Storiescontact | 1 |
| CristianCantoro | 1 |
| Mcollins | 1 |
| Moka_Pantages | 1 |
| Bapti | 1 |
| Smazeland | 1 |
| Timichal | 1 |
| Jollyroger | 1 |
| EBlanchard_(WMF) | 1 |
| Masti | 1 |
| RBhattacharjee_(WMF) | 1 |
| BradPatrick | 1 |
| Philippe | 1 |
| Rmoen | 1 |
| James_Owen | 1 |
| Anna.h.bauer | 1 |
| Jlohr | 1 |
| Tchay | 1 |
| Webbyj | 1 |
| Csteipp | 1 |
| Michael_Davis | 1 |
| Erwin_Mulialim | 1 |
| RLewis_(WMF) | 1 |
| Naoko_Komura | 1 |
| RobH | 1 |
| Geraki1 | 1 |
| Arobeson | 1 |
| Jmayall | 1 |
| Ascánder | 1 |
| Theodoranian | 1 |
| Prolineserver | 1 |
| Shizhao | 1 |
| Kkay | 1 |
| DAndreescu | 1 |
| Mwpnl | 1 |
| Esperluette | 1 |
| MaxSem | 1 |
| RMiller_(WMF) | 1 |
| Jan-Bart | 1 |
| Astronomo | 1 |
| Jmorgan | 1 |
| Austin | 1 |
| ThurnerRupert | 1 |
| Htchien | 1 |
| Teemu | 1 |
| Jjones | 1 |
| Klyman | 1 |
| DBoskovich | 1 |
| Manjithkaini | 1 |
| Neeru_Khosla | 1 |
| Benjamin_Mako_Hill | 1 |
| Perohanych | 1 |
| Rdsmith4 | 1 |
| Frank_Schulenburg | 1 |
| Spangineer | 1 |
| Joseaprez | 1 |
| GGrossmeier_(WMF) | 1 |
| Ral315 | 1 |
| Romihaitza | 1 |
| Gmeijssen | 1 |
| Barbara | 1 |
| Jtmorgan_(usurped) | 1 |
| Trevor_Neilson | 1 |
| Siebrand | 1 |
| DDunican_(WMF) | 1 |
| Nina | 1 |
| Benoit_Rochon | 1 |
| Rebecca_Handler | 1 |
| EpochFail | 1 |
| Jpostlethwaite | 1 |
| APPER | 1 |
| HMcandrew_(WMF) | 1 |
| Ram_(WMF) | 1 |
| Rory | 1 |
| CE | 1 |
| KBaker | 1 |
| Tychay | 1 |
| Kpeterzell | 1 |
| Dbenoit | 1 |
| AlisonW | 1 |
| Ocastro | 1 |
| Fruggo | 1 |
| Tlogmer_ | 1 |
| Heather_Ford | 1 |
| Rbracysherman | 1 |
| Dittaeva | 1 |
| Schapman | 1 |
| Gwicke | 1 |
| CJohnson | 1 |
| KPulec | 1 |
| Vishal-WMF | 1 |
| Cooper53 | 1 |
| Skenmy | 1 |
| Dchen | 1 |
| Patricio.lorente | 1 |
| Bgong | 1 |
| Redwolf24 | 1 |
| Tnekevets | 1 |
| Husky | 1 |
| Roger_McNamee | 1 |
| Catrope | 1 |
| Dmgultekin | 1 |
| Carolyn | 1 |
| Katherine_Bavage_(WMUK) | 1 |
| WKelly | 1 |
| Parul_Vora | 1 |
| Theo_(WMF) | 1 |
| Ddejarnatt | 1 |
| Mark_Bergsma | 1 |
| Pharos | 1 |
| DarTar | 1 |
| Steven_(WMF) | 1 |
| IVazquez_(WMF) | 1 |
| Arash_Boostani | 1 |
| Sandra_Ordonez | 1 |
| Nimish_Gautam | 1 |
| Szwedzki | 1 |
| Cbocknek | 1 |
| LBocknek | 1 |
| Yonatan | 1 |
| Parulvora | 1 |
| DaeX | 1 |
| Dfinzer | 1 |
| Platonides | 1 |
+-------------------------------------+----------+
534 rows in set (0.07 sec)
