mysql> SELECT -> SUBSTRING_INDEX(page_title, '/', 1), -> COUNT(*) -> FROM page -> WHERE page_namespace = 2 -> GROUP BY SUBSTRING_INDEX(page_title, '/', 1) -> HAVING COUNT(*) > 50 -> ORDER BY COUNT(*) DESC; +-------------------------------------+----------+ | SUBSTRING_INDEX(page_title, '/', 1) | COUNT(*) | +-------------------------------------+----------+ | ClueBot_III | 9817 | | UBX | 5828 | | AlexNewArtBot | 4751 | | Taxobot | 3020 | | Ohms_Law_Bot | 2434 | | WP_1.0_bot | 1810 | | C | 1397 | | Geo_Swan | 1196 | | NE2 | 1045 | | Tom_Danson | 842 | | Aditya.krishnan.82 | 810 | | Polbot | 793 | | CheMoBot | 777 | | Amit6 | 737 | | Emijrp | 704 | | SelectionBot | 647 | | Rich_Farmbrough | 601 | | Charles_Matthews | 585 | | ProteinBoxBot | 583 | | Presidentman | 558 | | Java7837 | 497 | | Scepia | 474 | | VeblenBot | 410 | | Wavelength | 396 | | Kingbotk | 389 | | JonSDSUGrad | 376 | | Myrecovery | 366 | | Daniel_Christensen | 364 | | Alexanderalgrim | 356 | | Chzz | 351 | | Nyttend | 348 | | Mrchris | 345 | | GeorgeMoney | 344 | | Disavian | 343 | | Cs32en | 341 | | StatusBot | 334 | | The_Transhumanist | 330 | | Murgh | 325 | | Danbarnesdavies | 302 | | Kithira | 294 | | AnomieBOT | 292 | | Sj | 277 | | Tony_Sidaway | 268 | | IronGargoyle | 251 | | Veinor | 248 | | Secretmessages | 242 | | Xy7 | 242 | | FF2010 | 242 | | Carabinieri | 236 | | SharkD | 236 | | SuggestBot | 232 | | Mitchazenia | 229 | | COIBot | 227 | | Iune | 225 | | Morwen | 224 | | X! | 224 | | LinkBot | 213 | | Filll | 212 | | Aeon1006 | 212 | | FireFox | 208 | | Ikip | 207 | | Nixeagle | 204 | | RichardF | 203 | | Dvyjones | 202 | | Paulmcdonald | 202 | | Davidcannon | 199 | | Morgan_Wick | 197 | | Halvorsen_brian | 196 | | Anhamirak | 195 | | 4 | 194 | | Me2hero | 189 | | Madhero88 | 188 | | Richard0612 | 187 | | Phaedriel | 187 | | Ashley_Y | 184 | | MacGyverMagic | 183 | | David_Kernow | 182 | | Ral315 | 182 | | TonyTheTiger | 180 | | Kevinalewis | 178 | | Casper2k3 | 178 | | New_Age_Retro_Hippie | 177 | | White_Cat | 177 | | Soman | 174 | | Propaniac | 171 | | Blofeld_of_SPECTRE | 171 | | Eagle_101 | 169 | | Dinokid | 169 | | Rfrisbie | 166 | | Alai | 166 | | Bwilkins | 164 | | Malpass93 | 163 | | MBisanz | 161 | | Ganeshbot | 159 | | Master_son | 157 | | Dsp13 | 156 | | Melab-1 | 155 | | Franamax | 154 | | Robertgreer | 154 | | DarknessLord | 154 | | The_Anome | 154 | | Korg | 153 | | Alistairjh | 153 | | Husond | 150 | | Dsouzaron | 149 | | Buchanan-Hermit | 149 | | Octane | 148 | | Richardguk | 148 | | Lexigator | 145 | | Patricknoddy | 145 | | Neurolysis | 144 | | Zimbabwe_is_Mine | 144 | | Benjah-bmm27 | 144 | | Gangleri | 144 | | ST47 | 143 | | Abdul_Qayyum_Ahmad | 143 | | The_Obento_Musubi | 142 | | Proteins | 142 | | Beetstra | 142 | | Bci2 | 142 | | Nihonjoe | 141 | | KYPark | 140 | | Deckiller | 140 | | Bahamut0013 | 140 | | Lights | 140 | | Ottava_Rima | 140 | | SPUI | 139 | | Storm05 | 139 | | MartinBotIII | 138 | | RadicalOne | 138 | | Femto | 138 | | Smallman12q | 138 | | 12george1 | 137 | | John_Carter | 137 | | Ilmari_Karonen | 136 | | Ed_Poor | 136 | | Bcperson89 | 135 | | Allstarecho | 135 | | CrowzRSA | 135 | | LouisPhilippeCharles | 134 | | לערי_ריינהארט | 133 | | Abyssal | 133 | | Reedy_Bot | 132 | | Ruud_Koot | 132 | | Soundslikeorange | 132 | | Ebyabe | 131 | | Lumdeloo | 131 | | TheNewPhobia | 131 | | Hersfold | 130 | | Gregbard | 130 | | Daanschr | 129 | | Balloonman | 129 | | EVula | 129 | | Diego_Grez | 129 | | TimR | 128 | | Choess | 128 | | Gary_King | 127 | | KevinalewisBot | 127 | | Rursus | 127 | | MC10 | 127 | | Lenoxus | 127 | | Flcelloguy | 126 | | Prodego | 125 | | Interiot | 124 | | Sengkang | 124 | | Monkeyblue | 124 | | Pee_Tern | 123 | | Jonathan | 123 | | Pengo | 122 | | Michael_Snow | 122 | | AzaToth | 122 | | Quarl | 122 | | Asenine | 121 | | Lar | 121 | | Chrislk02 | 120 | | Tassedethe | 120 | | Wikid77 | 120 | | Jw21 | 120 | | Tomruen | 120 | | TheDJ | 119 | | I'm_Spartacus! | 119 | | Skysmith | 119 | | Phantomsteve | 117 | | DumbBOT | 117 | | Davidgothberg | 117 | | WebCiteBOT | 117 | | Fetchcomms | 116 | | Mtmelendez | 116 | | Kwib | 116 | | Rocketmaniac | 116 | | GW_Simulations | 116 | | Soxred93 | 116 | | NoSeptember | 116 | | Balloonman_(usurped) | 116 | | RussBot | 116 | | Nabil_rais2008 | 115 | | WilyD | 115 | | The_ed17 | 115 | | Cyclonebiskit | 115 | | MJF2000 | 114 | | Aude | 114 | | Stolilv87 | 114 | | Selfworm | 114 | | Mr.Z-man | 112 | | Qwerty786 | 112 | | Ragesoss | 112 | | MadMax | 112 | | Legoktm | 110 | | Dylan620 | 110 | | Trident13 | 110 | | Coastergeekperson04 | 110 | | IJA | 109 | | Dubaduba | 109 | | Juliancolton | 109 | | Omegatron | 109 | | Halibutt | 108 | | Patrick | 108 | | VitaleBaby | 108 | | Victuallers | 107 | | Will_Pittenger | 107 | | Carcharoth | 107 | | CrazyC83 | 107 | | Useight | 107 | | Primate | 107 | | Zocky | 107 | | SpikeToronto | 107 | | Headbomb | 106 | | INVERTED | 106 | | Omtay38 | 106 | | FastLizard4 | 105 | | Drilnoth | 104 | | Blast_san | 104 | | Tyw7 | 104 | | Ijanderson977 | 104 | | Someone_the_Person | 103 | | Jondel | 103 | | Don_Garellos | 103 | | Lupin | 103 | | Richard_Arthur_Norton_(1958-_) | 102 | | Avicennasis | 102 | | L'Aquatique | 102 | | Tedius_Zanarukando | 102 | | Mackensen | 101 | | Scapler | 101 | | Luna_Santin | 101 | | Neutralhomer | 101 | | Ais523 | 101 | | Schwede66 | 100 | | Masky | 100 | | Roux | 100 | | Miwasatoshi | 100 | | Jorge_Stolfi | 100 | | Springeragh | 99 | | Steven_Zhang | 99 | | Russavia | 99 | | David.Mestel | 99 | | Protactinium-231 | 99 | | Fox | 99 | | Od_Mishehu | 98 | | Plastikspork | 98 | | DASHBot | 97 | | Nat | 97 | | Mathbot | 97 | | Z4ns4tsu | 97 | | Peter_M_Dodge | 97 | | Mathieugp | 97 | | SportsAddicted | 96 | | Peregrine_Fisher | 96 | | Titoxd | 96 | | Vassyana | 96 | | Toa_Nidhiki05 | 96 | | JLogan | 96 | | Garden | 96 | | Steve_Crossin | 96 | | Ahunt | 96 | | Ancient_Apparition | 96 | | Bellhalla | 95 | | Goethean | 95 | | Jengod | 95 | | Abd | 95 | | AndyZ | 95 | | Timbouctou | 95 | | Necrothesp | 95 | | Lquilter | 95 | | Life_in_General | 94 | | SlimVirgin | 94 | | Ganeshk | 94 | | Fridae'sDoom | 94 | | FT2 | 94 | | Wildroot | 94 | | Vedranf | 94 | | PullUpYourSocks | 94 | | DGG | 93 | | Wizardry_Dragon | 93 | | FPAtl | 93 | | Tillman | 93 | | Patelurology2 | 93 | | Raul654 | 93 | | Mdd | 92 | | MarkAHershberger | 92 | | QwerpQwertus | 92 | | Mkdw | 92 | | Gmaxwell | 92 | | J.Steinbock | 91 | | Allen3 | 91 | | Strdst_grl | 91 | | Toussaint | 91 | | StanMarsh19 | 91 | | Anomie | 91 | | BD2412 | 91 | | Dr._Blofeld | 91 | | Cuckooman4 | 91 | | Cenarium | 91 | | Topbanana | 90 | | Sceptre | 90 | | Archanamiya | 90 | | Drew_R._Smith | 89 | | Tbone55 | 89 | | Sgeo | 89 | | Lucimundatene89 | 89 | | Dragons_flight | 88 | | Physchim62 | 88 | | Slakr | 88 | | Pizza1512 | 88 | | PHDrillSergeant | 88 | | Willscrlt | 88 | | Alansohn | 87 | | Fl | 87 | | CWii | 87 | | Mdupont | 87 | | Wrestlinglover | 87 | | Next-Genn-Gamer | 87 | | Cacycle | 86 | | King_of_Hearts | 86 | | Jared | 86 | | Chubbennaitor | 86 | | Leon2323 | 86 | | Happy5214 | 86 | | Guettarda | 86 | | Gadget850 | 86 | | Ruby2010 | 85 | | Violetriga | 85 | | Dendodge | 85 | | Kubek15 | 85 | | Random832 | 85 | | Cuyler91093 | 84 | | Candlewicke | 84 | | Irdicent | 84 | | Matthew_hk | 84 | | General_Eisenhower | 84 | | Triddle | 84 | | Ssolbergj | 83 | | Alainr345 | 83 | | Irmela | 83 | | CFeyecare | 83 | | Andrevan | 83 | | Dailynetworks | 82 | | WillowW | 82 | | Hesperian | 82 | | Editor510 | 82 | | Jerzy | 82 | | R._Koot | 82 | | IvoShandor | 81 | | Tony1 | 81 | | Foxy_Loxy | 81 | | J.P.Lon | 81 | | Xiong | 81 | | D4g0thur | 81 | | Lightdarkness | 81 | | Diligent_Terrier | 80 | | Moonriddengirl | 80 | | Tisane | 80 | | Royalguard11 | 80 | | Epsilon60198 | 80 | | Gears_of_War | 80 | | Mevans86 | 80 | | Masem | 79 | | Froth | 79 | | He!ko | 79 | | Viridiscalculus | 79 | | Falastur2 | 79 | | Spacepotato | 79 | | Eubot | 79 | | Wasted_Time_R | 79 | | Visviva | 78 | | The_Earwig | 78 | | Redvers | 78 | | OrganicReactions | 78 | | Koman90 | 78 | | Animum | 78 | | Angr | 78 | | Peregrinefisher | 77 | | SatyrBot | 77 | | Ta_bu_shi_da_yu | 77 | | Yellow_Evan | 77 | | Frickative | 77 | | Shereth | 77 | | Pilover819 | 77 | | KoshVorlon | 77 | | Dinoguy1000 | 77 | | Wiki_Raja | 77 | | Doncram | 76 | | Aaron_Schulz | 76 | | JonMoore | 76 | | World_Cinema_Writer | 76 | | Sp3000 | 76 | | Matthew_Yeager | 76 | | Piotrus | 76 | | ChildofMidnight | 76 | | Wyatt915 | 76 | | Crest_of_London | 76 | | Dan_arndt | 76 | | MichaelQSchmidt | 76 | | Shannon1 | 76 | | Eddideigel | 76 | | W_guice | 75 | | DionysosProteus | 75 | | Londo06 | 75 | | JP06035 | 75 | | ISD | 75 | | Lucasbfr | 75 | | Nostalgic34 | 75 | | Jarry1250 | 75 | | Techfast50 | 75 | | Secret_Saturdays | 75 | | Mk32 | 75 | | Jimbo_Wales | 75 | | Gaia_Octavia_Agrippa | 74 | | The_Userboxer | 74 | | GeeJo | 74 | | Jnestorius | 74 | | Richard_Ye | 74 | | CompuHacker | 74 | | Jeremygbyrne | 74 | | Tivedshambo | 74 | | Mrmusic16 | 74 | | FisherQueen | 74 | | Luk | 74 | | Enochlau | 73 | | Phoebe | 73 | | Qwerpoiu | 73 | | Celestianpower | 73 | | Bishonen | 73 | | Voice_of_All | 73 | | Silence | 73 | | TSRL | 73 | | December21st2012Freak | 73 | | DeltaQuad | 73 | | Son | 73 | | Croquant | 73 | | Thedjatclubrock | 73 | | Mr.crabby | 73 | | Gatoclass | 73 | | Stantheman8609 | 73 | | Jackyd101 | 73 | | UpstateNYer | 72 | | Promethean | 72 | | Muhandes | 72 | | BrownHairedGirl | 72 | | SebastianHelm | 72 | | AmiDaniel | 72 | | Mattgirling | 72 | | Striver | 71 | | LB22 | 71 | | Damon.cluck | 71 | | Scarce | 71 | | Mattisse | 71 | | Z-vap | 71 | | AllyUnion | 71 | | O | 71 | | SatyrTN | 71 | | Ceres3 | 71 | | Universal_Hero | 71 | | TUF-KAT | 71 | | Anikingos | 71 | | Calliopejen1 | 70 | | Hut_8.5 | 70 | | Flyingidiot | 70 | | Giano | 70 | | Rjanag | 70 | | John_Z | 70 | | Jeff_G. | 70 | | Djr_xi | 70 | | Cyde | 70 | | Stilltim | 70 | | Jonathan_W | 70 | | RekonDog | 69 | | Sophie | 69 | | Scriberius | 69 | | Whytecypress | 69 | | Lord_Cornwallis | 69 | | Wcquidditch | 69 | | Simetrical | 69 | | LightSpectra | 69 | | Rbpolsen | 69 | | Rebecca | 68 | | Access_Denied | 68 | | WhatGuy | 68 | | Tim_Starling | 68 | | Einsteinewton | 68 | | William_M._Connolley | 68 | | Trevor_MacInnis | 68 | | AMK152 | 68 | | Dcmacnut | 68 | | ErrantX | 68 | | Chuq | 68 | | Jammydodger | 68 | | Deacon_of_Pndapetzim | 68 | | Neddyseagoon | 68 | | Glen | 68 | | Miller17CU94 | 68 | | David_Newton | 67 | | A_Werewolf | 67 | | Xaosflux | 67 | | Wpollard | 67 | | Runningonbrains | 67 | | Tmorton166 | 67 | | Randfan | 67 | | Mgreason | 67 | | ClueBot | 67 | | Arilang1234 | 67 | | TFOWR | 67 | | Pascal666 | 67 | | Nageh | 67 | | Chillum | 66 | | Erik | 66 | | Zephyris | 66 | | Glen_S | 66 | | Freshgavin | 66 | | Lympathy | 66 | | WeepingBritney | 66 | | Mattfranko81 | 66 | | Holderca1 | 66 | | Snowolf | 66 | | SadanYagci | 66 | | Manishearth | 66 | | Booksworm | 66 | | Porturology | 66 | | Tiamut | 66 | | Rfl | 66 | | Stuj24 | 66 | | Vishwin60 | 66 | | Msrasnw | 66 | | Elena85 | 66 | | Redwolf24 | 65 | | The_Dark_Side | 65 | | SBN4004 | 65 | | A._B. | 65 | | Maddie! | 65 | | Ambi | 65 | | BrokenSphere | 65 | | Will_Beback | 65 | | Linuxerist | 65 | | Thisisborin9 | 65 | | R3m0t | 65 | | Avenged_Eightfold | 65 | | Saintrain | 65 | | Nigel_Ish | 65 | | Mono | 65 | | Grutness | 65 | | Coppercanuck | 64 | | Ryan_Postlethwaite | 64 | | EpochFail | 64 | | SoxBot | 64 | | Wiki_User_68 | 64 | | Fabartus | 64 | | Lady_Aleena | 64 | | Penubag | 64 | | Hutcher | 64 | | ArielGold | 64 | | KimvdLinde | 64 | | Doczilla | 64 | | LinguistAtLarge | 64 | | Sephiroth_BCR | 64 | | Mistman123 | 64 | | Sulmues | 64 | | Jj137 | 64 | | Sphilbrick | 64 | | Sherurcij | 63 | | Misza13 | 63 | | Thukyd1des | 63 | | Yume_no_Kishi | 63 | | L07ChLeo3 | 63 | | Kzzl | 63 | | Jacoplane | 63 | | YellowMonkey | 63 | | Eternal_dragon | 63 | | Mav | 63 | | Decltype | 63 | | Ale_jrb | 63 | | Inclusionist | 63 | | Ohconfucius | 63 | | Red_Thunder | 63 | | Tenmei | 63 | | Mifter | 63 | | Spebi | 63 | | Mikhailov_Kusserow | 63 | | DanTD | 63 | | MarsJenkar | 62 | | Bine_Mai | 62 | | Jamesontai | 62 | | ReyBrujo | 62 | | MickMacNee | 62 | | Webdinger | 62 | | Speckler | 62 | | RyanCross | 62 | | Jonjonbt | 61 | | Luasóg_bot | 61 | | John_Vandenberg | 61 | | Deon | 61 | | AlisonW | 61 | | B.C.Schmerker | 61 | | Durova | 61 | | Minesweeper.007 | 61 | | Ched_Davis | 61 | | Fir0002 | 61 | | Buggie111 | 61 | | Carnildo | 61 | | Bsroiaadn | 61 | | Btilm | 61 | | Nsgaeverine | 61 | | Dylan_Lake | 61 | | Matthewedwards | 60 | | AeronPeryton | 60 | | SoWhy | 60 | | TreyMarsh20 | 60 | | Sillyfolkboy | 60 | | Basketball110 | 60 | | Morenooso | 60 | | Father_Goose | 60 | | Chaosdruid | 60 | | Keithgreer | 60 | | Johntex | 60 | | Johan_Elisson | 60 | | Rodhullandemu | 60 | | Ginkgo100 | 60 | | W_Nowicki | 60 | | Scartol | 60 | | Tabletop | 60 | | CompactDisc17 | 60 | | Addict_2006 | 60 | | Cobi | 59 | | Smith609 | 59 | | YumeChaser | 59 | | BGinOC | 59 | | BozMo | 59 | | Phil_Sandifer | 59 | | Xeworlebi | 59 | | Farkas_János | 59 | | SonPraises | 59 | | Ezekiel_7:19 | 59 | | Eitch | 59 | | Paranomia | 59 | | Prom3th3an | 59 | | Snowman_Guy | 59 | | Knowzilla | 58 | | Ukexpat | 58 | | ClockworkSoul | 58 | | Alekjds | 58 | | Njaker | 58 | | PleaseStand | 58 | | Jason_Rees | 58 | | Pablo_X | 58 | | El3ctr0nika | 58 | | Nihiltres | 58 | | Pdfpdf | 58 | | Marek69 | 58 | | Fæ | 58 | | Mike_Dillon | 58 | | Liberlogos | 58 | | Nanobear | 58 | | Ftbhrygvn | 58 | | Lord_Shivan | 58 | | Andries | 58 | | Splarka | 58 | | Daedalus969 | 58 | | UzEE | 57 | | MZMcBride | 57 | | KrakatoaKatie | 57 | | Talskiddy | 57 | | Amarkov | 57 | | LeyteWolfer | 57 | | Rschen7754 | 57 | | Color_probe | 57 | | Giggy | 57 | | Sundostund | 57 | | Kayau | 57 | | Kitty53 | 57 | | Samsara | 57 | | AnnaKucsma | 57 | | Stwalkerster | 57 | | Alaney2k | 56 | | Who | 56 | | White_Shadows | 56 | | JB82 | 56 | | Admiral_Norton | 56 | | WBOSITG | 56 | | Hopiakuta | 56 | | Hemanshu | 56 | | BullRangifer | 56 | | Ageofempires | 56 | | Vagary | 56 | | WiiRocks566 | 56 | | Kotniski | 56 | | Parker2334 | 56 | | Andrewa | 56 | | IL7Soulhunter | 56 | | Cactus.man | 56 | | Leobold1 | 56 | | Mystytopia | 56 | | SuperHamster | 56 | | Shimgray | 56 | | RyRy | 56 | | Rajofcanada | 56 | | SGCommand | 56 | | SpecialWindler | 56 | | Secret | 56 | | Parent5446 | 56 | | AstroHurricane001 | 55 | | Sha-Sanio | 55 | | Topaz | 55 | | YUL89YYZ | 55 | | Lewisskinner | 55 | | Andros_1337 | 55 | | AnemoneProjectors | 55 | | LuciferMorgan | 55 | | Blackwatch21 | 55 | | Billy | 55 | | Jc37 | 55 | | Bamse | 55 | | Joseph_A._Spadaro | 55 | | TheFearow | 55 | | Zaui | 55 | | Herostratus | 55 | | Stadtpark | 55 | | Sardanaphalus | 54 | | Pyrospirit | 54 | | Bookofjude | 54 | | Allied45 | 54 | | Venustas_12 | 54 | | The_Bushranger | 54 | | Doron | 54 | | Babbage | 54 | | TheGrappler | 54 | | Maralia | 54 | | FloNight | 54 | | Kumioko | 54 | | Aaroncrick | 54 | | Ianblair23 | 54 | | TakuyaMurata | 54 | | Jacnoc | 54 | | Bedford | 54 | | Dreftymac | 54 | | MichaelACookII | 54 | | Armando12 | 53 | | Adam1213 | 53 | | Martinp23 | 53 | | Sango123 | 53 | | Miranda | 53 | | MathCool10 | 53 | | Wintran | 53 | | Swatjester | 53 | | Spinningspark | 53 | | J.delanoy | 53 | | NerdyScienceDude | 53 | | The_wub | 53 | | Deon555 | 53 | | Lcawte | 53 | | Piotr_Mikołajski | 53 | | Tuvalkin | 53 | | Botlaf | 53 | | Labant | 53 | | Pseudo-Richard | 53 | | Sean_gorter | 53 | | CT_Cooper | 52 | | Nishkid64 | 52 | | Bugboy52.40 | 52 | | Nefariousopus | 52 | | Bluegoblin7 | 52 | | Dschwen | 52 | | BQZip01 | 52 | | John_Reid | 52 | | DiverDave | 52 | | Alan_Liefting | 52 | | Crash_Underride | 52 | | H | 52 | | Ucucha | 52 | | Enigmaticanant | 52 | | Theunicyclegirl | 52 | | Thebainer | 52 | | Mateuszica | 52 | | Robert_Skyhawk | 52 | | Rick570 | 52 | | Robbstrd | 52 | | Neier | 51 | | Stmrlbs | 51 | | Elaragirl | 51 | | Darth_Stabro | 51 | | Cool3 | 51 | | Tompw | 51 | | AndrewGNF | 51 | | Emesee | 51 | | Spacevezon | 51 | | Sdsds | 51 | | Aaron_Brenneman | 51 | | Anthere | 51 | | Crazycomputers | 51 | | Haus | 51 | | Shardsofmetal | 51 | | Lord_Gøn | 51 | | JohnManuel | 51 | | Richardshusr | 51 | +-------------------------------------+----------+ 812 rows in set (1 min 3.10 sec) mysql>