Wikimedia:Sandbox: Difference between revisions
Content deleted Content added
all right |
once more |
||
| Line 1: | Line 1: | ||
<source lang="sql"> |
<source lang="sql"> |
||
SELECT |
SELECT |
||
SUBSTRING_INDEX(page_title, '/', 1), |
|||
il1.il_to, |
|||
COUNT(*) |
COUNT(*) |
||
FROM page |
FROM page |
||
WHERE page_namespace IN (2,3) |
|||
JOIN imagelinks AS il1 |
|||
GROUP BY SUBSTRING_INDEX(page_title, '/', 1) |
|||
ON il1.il_from = page_id |
|||
ORDER BY COUNT(*) DESC; |
|||
JOIN imagelinks AS il2 |
|||
ON il1.il_to = il2.il_to |
|||
WHERE page_namespace = 10 |
|||
AND page_title = 'Staff_and_contractors' |
|||
GROUP BY il1.il_to |
|||
ORDER BY COUNT(*) ASC; |
|||
</source> |
</source> |
||
<pre> |
<pre> |
||
+ |
+-------------------------------------+----------+ |
||
| SUBSTRING_INDEX(page_title, '/', 1) | COUNT(*) | |
|||
| il_to | 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 | |
|||
| Sage_Ross_self-portrait_in_Creative_Commons_t-shirt,_2012-12-16.jpg | 24 | |
|||
| |
| 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 | |
|||
| Renee_Bracey_Sherman_Wikimedia_Foundation_Staff_May_1_2012-1.jpg | 25 | |
|||
| |
| 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 | |
|||
124 rows in set (0.00 sec) |
|||
| 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> |
</pre> |
||
Revision as of 05:44, 12 March 2013
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)