SELECT id, COUNT(DISTINCT player_name) AS players, GROUP_CONCAT(DISTINCT player_name) FROM map m GROUP BY id HAVING COUNT(DISTINCT player_name) > 1 ORDER BY players DESC LIMIT 100

idplayersGROUP_CONCAT(DISTINCT player_name)
2983319daviddavid1,illieens,boyzzzboy,gtserg,TigerToffie,JuckEEE,attackbäver,biblan,saarinen
3240809Dungore,edde247,mlinn,Rutan,Samir96,hurfen,fogo01,jullankrullan,Sareth
2848248Belial,abborre,jossa,-kingofthehill-,lala,Ralloj,hampusforsberg,DeathRug
3849298SunShine_08,I love strul,Rovder,BigMac,roffi,dynastymarcus5,pont,Wandaler
2543207nikkenyfiken,skumnappen,cowboy4,gallern 113,Dr.citrus,Mowgley,_vinkelslip_
2663737nisse4,Lassefix,blomman30,Beengan,JesperN,lattiaharja,TrickySasquatch
2686737memlis,knillbald,bajskorven00,Menjok,deminison,thekiller,Lamo
3104587foxh,jonsson24,Mackabananen,Shakeit,sefa,Winnee,phenix
3407367jojjo,Astax,maryjanejane,DUDE00!,Piojosa,sotis,jensev
3760227ibbe,hatafolk,Tvi,BöhserOnkel,kan,hejsan96,plingolainen
3960957fly-away,NFL-Man,Gramseboy,babbelan,linux_man,styran88,Temograa
2447076Hugin,SimonW,Lord Zeratul,??? ?S.f.S? ???,biffen,nalle20
2550786hdclob,fisenswe001,Rolexx,GuybrushT,Karlie,johanlol
2551146arre1986,orion,warrioranton,mackan88,maxerlaxer,rallymully
2551716cruzan,Noob4ever,justdancing,earnshaw,Zaphod,najpztah
2766786vanderlie,Sanko,bajsmajs96,pet_ax,tanig,Greencooling
2783316Kjelly,Jaavior,trike,wii60,delfin,Viktorfl0w
2856276Nitto,margareta,harrysnopper,slomo15,xynemis,supertjejen0102
2886906sampa,falco,fillepena,tommy__,mange,Whatsdignity
3022906gustafp,alexc,dojjan_,Netsara,egon419,kaled
3080766Våttarna,Linkin,P.D,soffe,sphongle,jakuma
3150946anlide,shishi,candy,mkj,ballong,Torstens arme
3495426Terk,Muppen,isberg86,fredlig,xXGlasSXx,edghar94
3519546Elemental Lord,darkfille,roten,hajlajf,hanna998,arki
3529246yusea,waern,Hanni,Soma,Pudding,milkshake
3553146pennybridge,Zerorex,kajjan,homo,Jonas_s,Indiann
3591826Esther,pontairos,mimosasallad,Raggen,blood kingdom,gos
3649316Drunkskunk,img,Mirocix,baobei,zenzal,bubbis88
3737366Limpan Lindberg,pedo mom,Fridge,Cyanea,tortilla,Danne king
3800756brandty,HwangChul,mountainman,frello,hanny,t90t
3841296Maldox,fille.da.man,Jockevik,pääp,mimo0o,forcey
3920796mc10,macke äger,erikzzonftw,forskarn,cornelia77,rasmjau
3929266bronto,dfbgfdgbf,niley,pippi,sweeteee,cernaSMRTKA
3944986Fermus,Palomides,Amis,Nichlas,D-amon,adadad00
2398755angelshadow,ilow,Jack X,paapeli2,emmadrottz
2406715Miko,lisaDN,krockhuntah,marsipanen,I eat u xD
2415205Slaktaren,supermums,Cissi,sarus,kobbe
2439255tezzan,towiz,dekker,whitearchon,aqvxikr
2455435Csingiszkán,jaha_78,Golaby,Muxii,anders889
2463385tohan,Kipfle,kingen_,ColtJola,Krilleman
2486655Tyrannen,Ester Maria,hdjs,rickaka22,nadja
2486855simpab,Lord_proppmätt,white god,suunken,Tussen
2511535Elvirakatanja,KimberlyLarson,Lil K,frozman2,Nasse
2543575läder pojken,Travian49,97popper1,coolis107,Thelmis
2550845hannes,mannen,ToriAntony,Revy,no anglesh
2566755VIKE!,ralle,EMMON,kakakaka,Delilah
2567325mjuff,SkylineGTR,hebster,Kajat,fregra
2591535kheel,matttiii,--RooRoo--,Jagr,swedenboy
2615585Skalitor,sokol,Fredrikpo,Rubolus,smosh
2726685zezymaloy,sebbe12,Adrianos,Scipio,the_ist
2736075isen krigaren,Mkriborg,Sheena,Xeon,elvira
2776055jimbo91,Gabriel,PhantomFuria,Sesaliita,crazy_ivar
2782855emilking7,hellmen,Clanzman,daniel87,Exalius
2862635tovalova,BacoN,korpskit,BenPool,Mr.Mask
2870695jimjim,krills,bregor,celeron,Robotnik
2878895oscis,ArTooSwE,zacen12,turbolina,Pedbor
2879065lollen234,Knarky,träsktroll,Mandis,Cyckel
2950795zipp,jonis arme,hammarsving,Bamsebjörn,R3DH3AD
2984705bellner,tofz,naxxos,errkan,Frolle
3000515jonsilver,arschinel,asdfghjklöä,Ekorren,förorten
3024705Numinus,nezik,HannaMarie,puling,xatzy
3094845Sabbe,xX PG Xx,blackorwhite,Cloud,Narishma
3158975mike73,dinoman395,gripen92,josch,Madlez
3216905ViperJr,vandal,LillenNr14,rockollasallad,innebandy
3223205jono,cooling,risböle6,dalle97,Kmork II
3271045Kvark,victooria,Zebsag1,ricke99,Spoon
3271255koka,eddul,thariana,karrascon,Sharwaro
3287075April77,jollepelle70,UGGLAN,eddeman,xBorntobeemo
3335195isak,Harrybarry,Sören,kiss,hejhej
3337075Enivid,Freddie,GiBoN,vilmaz,dsjflkdjflkjsdk
3353115FoF,hawe,olismart,hampusb,fannyholopainen
3383205hero,Garet Jax,nallepuh95,idisen,pet
3407255TheKengStar,kalle111,zezor,kungen,Larry
3409025korven123456789,Noobdistruck,LonelyFox,XivaX,qattis
3417255Hiro Nakamura,dSid,mane703,tomka,bebbe-96
3441175Malfin,Froog,domacio,Frodo,haddy
3503545Matius,Meile,Nena,Laika,misse78
3551515TRAD,Canine,lissie,Germania,J.F.Kennedy
3601405gak,zho purezhot,reddiamond29,Lord_Sars,lowieds
3671825hans,Lilith,frasse,ante111,alhussin
3737325minisen,speedy313,adde95,rodent,Naabzzor
3817395Lime_AT_GOD,Gosnoken ffs,fjoert,moa08,rikoxett2
3856335Ramlösa,FROGMAN,Crafoord,sonako,villeh
3856945anwe83,lundan,Zorre,siar,heaton
3864935Lord pungis,simerklingbing,razor,saneen,Bajjan
3921275Adam,Ahanana,dabojing,gloken,greldik1
3929305hannazz,mAh,Sparven3000,Serach,Sven_Achmed
3944555flummkanin,Elegost,bobo,nisse2004,Akilles
3977395Emmi,TessanTherese,oerat,jos,mollypolly
4016945lilleman,skoglund,carrocarro94,erbert,alundur
4024965knekten,willemannen,adde,maxe,MANIAX2
4033155aboow!,RebekkaÄrSötast,xtro,zorias,cammiz
4041145majsi,fredrik,sydling,uzgmar,kulu kongen
2398804SIMMAN,real,Leila,zangos
2414984Tadawa,nallen,roban111,Delight
2415304xBadBoyx,koj,Mega_Power,soberano
2422764Dr.Pepper,ozze,flodde,masjdfnas
2430824Henupompeli,Psycho,steven007,hampusmannen
2446804tuna,simon388,Love Maria,hejaajaja
2446834Odovakar II,Jarlmo,owh,prinsessan