Wikimedia:Sandbox: Difference between revisions
Content deleted Content added
once more |
m Testing T338023 |
||
(21 intermediate revisions by 4 users not shown) | |||
Line 1: | Line 1: | ||
foo |
|||
<source lang="sql"> |
|||
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; |
|||
</source> |
|||
<pre> |
|||
+-------------------------------------+----------+ |
|||
| 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) |
|||
</pre> |
Latest revision as of 15:08, 3 June 2023
foo