SELECT u.Id AS UserId, u.CreationDate AS ProfileCreationD...

0

Please login or register to vote for this query.

(click on this box to dismiss)

Music Fans Meta

Q&A about the site for music historians, critics, and fans

SELECT 
    u.Id AS UserId,
    u.CreationDate AS ProfileCreationDate,
    u.Reputation,
    u.Views AS ProfileViews,
    COUNT(CASE WHEN b.Class = 1 THEN 1 END) AS GoldBadges,
    COUNT(CASE WHEN b.Class = 2 THEN 1 END) AS SilverBadges,
    COUNT(CASE WHEN b.Class = 3 THEN 1 END) AS BronzeBadges
FROM 
    Users u
LEFT JOIN 
    Badges b ON u.Id = b.UserId
WHERE 
    u.Id IN (4725226,16330041,15023361,16429860,2773206,14714183,4034593,15852807,15117090,16401975,5538678,15803650,10158066,16437037,13246559,13110605,13882425,6023471,16441005,16255612,4477269,16446094,5825574,12250028,13365886,4104420,8810800,16454615,3117972,12203155,16457759,14399584,9244904,1418533,12314856,2802340,8209489,14694660,13477535,4437844,14834563,8247748,10852096,13434118,7750402,16473232,16473354,16475364,11971528,10862652,4879877,16270491,13658008,1867093,16479595,16439301,9743386,15394304,16307208,11914758,15351725,14501177,12973147,10122390,10068131,16496149,5646269,16498465,16220485,16504752,14856250,12857953,10075437,16459931,4354017,15992512,13482179,15695071,9816507,16488031,16510552,16518852,10033765,9910316,9255360,15981366,8684764,8259352,2224727,13759596,16237146,10289090,14540754,16537820,10181987,13341980,16539979,16420723,15397174,16529820,11250327,15991365,4442212,16450225,13137221,595833,16550140,11353092,10398264,12994302,7093073,6370844,13993723,4581287,11526227,16558243,14352525,16313756,8028981,15632299,14124846,16552047,15671081,14740055,16565102,7225236,16569215,16569250,146234,10690992,11039170,10732825,16574064,14000422,7974115,13987304,4387652,15507166,1678770,10034632,16582713,4688595,16586273,16291988,4883598,16542915,15967967,14393261,936456,16081039,14145740,12338760,16389692,12899840,16595906,11424626,11254744,7240135,14971720,8035804,5075778,9127614,16553790,6135469,10805528,12203998,1862808,2999096,14005005,77273,11718370,15199888,13461260,14349397,11938399,13295481,12107089,13949231,12875409,6533983,15016891,6894653,16627453,14329083,5795014,6138564,16635783,12649687,12158252,1049397,12786102,14865374,8311330,652341,16642209,16643386,14292155,12003833,14482885,14348664,16359523,16370054,10600152,7325599,16324679,16655343,16655382,14617228,11753262,10275029,8275139,5403155,5725589,16630090,16662520,16539977,1455649,15013119,5924373,16330083,2758471,16666983,2631934,9006846,10588118,14508019,16660763,2490074,13662551,13769660,16378078,16621497,7808104,14656699,12397235,6544266,16688925,16632694,16690133,6279152,16084423,16696292,10661291,16699209,10102998,15646439,7590303,15176749,7407224,9920930,14207187,5800846,16717296,15973729,10671866,13275449,15601741,16722579,13386449,16508872,13199180,2497351,15593050,14504673,16713556,15320579,3701753,14731559,15175378,9954110,16608456,8954799,12852544,6715469,10251555,3758396,16751925,9140632,1942603,16563242,14206374,16535529,16406196,12319705,2529441,14471826,13731477,16197542,16750229,12163005,8386378,16763380,14921211,16775191,6763963,16623246,10341337,13674384,16782779,5735036,16787979,1678467,16793621,4074980,16765762,7529022,9916154,4601598,14984834,11304461,8939178,11522973,9412096,14381081,16809005,1583274,16810248,15707025,3818277,7870662,3460791,10311197,10052515,14750918,1277239,8256347,11606097,10846193,11207870,14236237,16825503,14848796,10413624,14707182,9194639,16838085,9535697,2897115,6833801,6510836,13566458,7042795,16573587,7337777,16181141,2272986,3286527,8263882,16851334,3705191,10283072,16758377,8044045,16712069,12283863,13836955,1315599,13091039,10907711,13826047,12543827,10488313,13004811,16224660,15630842,10730719,2355463,13916295,8812124,13408230,9676381,10667703,11712834,2152321,12819882,16063957,16896022,9911560,6286882,12543122,16867486,646979,12199212,16912989,10773877,16914146,13091580,14533390,8953274,16918637,16633330,16878392,7168877,8466292,12042622,14088215,8681249,14802426,9665417,839846,13645324,15951465,3520697,10059652,12037411,12177456,11225013,9042297,13143525,304522,16893481,8889824,12586089,15343982,11985806,16946622,3772506,13787721,12063969,15835112,16900362,13249082,15876073,11877678,13822182,15529332,16955377,16957100,13586157,16960394,16687233,16963351,14755530,16686934,2271360,842755,6376297,5848607,14298113,7943920,6384676,12073583,16931006,4343563,16979149,16824394,13325970,8568914,13424444,13057903,16930502,16986234,15532692,6298969,10948364,1539932,7694859,4894427,6797267,10712575,16993503,15817092,15178375,3813789,11771367,1284956,17002136,6649786,6387233,17007876,9325038,17010001,6279283,16983458,14023300,15799105,14347880,15602614,12068948,7051888,2291036,17023717,10352328,4973297,14437399,8853390,16386919,14733252,14002836,15889782,16958679,13100783,15154712,16995009,12541277,10106073,16854107,14851554,14427128,6680470,12938151,8236728,16601580,17003225,15277414,2875641,6946693,9567948,15909890,17055922,17057841,14703784,7252065,17064437,12579513,17068193,16335399,15887250,17045291,17074666,11204560,9825870,16650865,14080309,17039430,3848398,14770901,17091076,17091567,13631591,11963834,15439132,12519771,13947115,17101778,17103593,9274940,2920861,17106471,17108642,8178880,1639594,6892837,8953562,12948877,2009377,13785243,17120560,4396778,8531224,15523162,6319067,9222161,4691180,14751525,5059265,5477975,16253841,17120183,6696948,13756061,17137159,12173865,11035290,10968586,11721935,14718428,10590749,16827591,2701443,12269587,17146371,15136558,1088468,11129502,3108189,17150388,11245255,32914,15800148,12846524,17046741,8316405,10061212,14166523,5613367,2786933,17166590,17166724,6672893,6805982,11231350,15398219,17169047,15274474,17047853,8755974,14486187,13777188,16645289,13177703,17179598,6715629,16836477,11884426,17184707,17184898,17185711,14131752,3321588,15240109,126537,16115954,17060730,15031671,17198253,14863019,13660249,2074831,7439761,11813339,4539787,17059658,15465206,17134711,16608027,2801589,9484595,13927375,13921132,17220945,17221279,17221603,16483750,15429371,15671786,11225065,7190674,13053656,11780625,17219844,16854761,9461258,13407686,1268941,14428944,17201453,17235420,5676603,3951138,16218760,12236389,17242590,17242710,14955623,17209469,11500602,6867232,17244425,3825010,11190888,17251385,17252448,17253435,14448463,17196390,16587276,15865608,17084030,16939052,15979321,13769773,1760946,1300757,1101025,17261586,17261574,12293384,14166027,5594621,15233108,11629229,36590,13834264,1720266,14422079,16095527,16930381,9111244,10375568,15680552,17286372,4170822,7375639,1821998,11481590,5570089,17112482,3147156,10285413,2720256,17293622,16542616,13611738,17147840,16334871,232017,17299916,14027701,16946731,9851404,12308324,17306410,6124796,12344862,4861613,12068277,17244669,16398170,17313144,9360751,17224399,6950159,13032644,17270684,14141469,17319877,11832749,14678400,5023456,2440970,13178930,14346231,14339712,17328137,3667264,17333381,17310522,8709603,8433044,9256127,4098607,16965892,15612010,17221142,17342320,7487283,9068493,16585189,14074435,1907376,956482,14453043,12102246,17357598,15944582,5423576,5100166,1036405,3727308,16887933,11563602,9304291,15566755,15995551,2433679,6141885,2907940,7027346,15815482,14560046,16674436,4645121,2998036,17381271,546678,17382906,16755045,10194999,17385469,13701348,16374395,9206735,17351698,12229372,16369817,17383799,11189118,16894486,17396507,1591156,13776511,5680507,4279446,2998077,13701706,17406923,16188928,17081736,17384310,11225660,17042618,15316184,10470363,11270332,10705248,16636054,15198571,16123112,17040855,9542989,15113917,13119299,7400630,11010727,12701119,17441991,3137368,17442430,17419233,17102262,16751401,14917976,17448779,14437898,13276395,15874938,17138706,17382373,10916209,10300611,13087100,15584403,14319593,17426838,12424991,8830328,16353926,17468592,14241197,9385136,17472657,17472857,15005927,6283906,593461,13847406,15223504,17194313,9115313,17291617,655306,17190872,8935174,13917424,7144225,17497936,7088017,14849100,896122,10007003,17499674,17487718,6222331,17495877,17010193,17507874,3665480,13715250,1036082,14075401,16338573,7913428,14311598,749658,4975198,17468631,3422977,11771418,404861,2611539,17365975,72178,13068538,15439569,3042117,15209993,12818693,17528508,16995723,13106734,11887633,17527708,15458086,17539088,1165717,12758565,10764332,13112714,17380412,9984028,16943229,16217248,3353167,14416505,14271145,2344313,17551666,14664513,17557401,14585338,17444485,8607250,12400312,8858840,12446704,8785163,17391995,17204973,17566803,5870333,12778629,17440988,337772,4838235,15032408,17265513,586006,17528842,2744139,17578637,17581836,9913239,17397259,16796468,539251,16725399,13242812,12802838,7369067,17590816,17398625,17500406,10603510,6728441,14800725,289588,1289967,13828452,15952169,2473770,13592426,12683269,16611068,17606018,16467154,4559589,14491360,17368336,17616857,11761881,6724000,11906119,13771538,7780673,5005800,14349575,11071681,17228484,4581844,11389120,10224744,13636787,17524405,14700391,13637915,14923024,3701393,3955765,15758793,16949520,11836527,9066015,17326987,17650287,8577441,12683457,15897202,14657890,9519322,17660037,7462275,17070021,1624277,17514610,15799839,17672967,17674395,17649781,17674460,15979930,16414043,17570985,6386056,12377329,612580,5254229,16826842,15829610,17679667,11486763,8063044,10961558,15559606,17570313,1254257,16363897,988901,7067164,17695964,17696392,10054794,17700412,14033684,15229040,12914945,5075715,14639281,13775438,7427208,17704911,13879370,16910436,17063325,11837657,17689879,17715441,11226666,9485286,10601715,17698684,7804087,17637851,9200210,11981324,11785459,15823673,16410554,14110861,15826299,13697196,17353685,12002856,17115688,14438350,11419201,17240666,4874204,7965040,10542235,7714681,14458518,17749984,17750010,9275224,14335420,3328245,15024787,13501846,14328509,6410157,17688030,17758024,14345947,11764091,16495257,13482504,17376448,10919349,10890520,12074479,14758591,12137400,13298274,1590588,15230517,13241440,7036732,17773513,17739817,14177386,15751486,17059713,17769487,11756427,11357695,7114172,5915898,17782519,8713172,11452298,8383592,17715480,8741,17318395,15140258,16927834,12724403,13101068,16504687,17554361,16662003,12010984,10434391,4710351,15646542,5150274,7694971,12729577,13451794,17085787,4450874,15238246,17375573,17573224,16604440,17831595,4316594,13588126,10187359,347764,2461281,17781347,13350168,17834887,14208968,17835403,17835725,15568187,14890683,17008868,2329968,16716087,4371533,2457026,17558496,17852779,15821959,2900314,10382003,16529798,11903486,12816359,10803280,17862419,4105475,5205393,15218381,8870206,17873336,17873551,14132104,17873994,11233380,11085824,2763895,12667161,6617951,17883269,13898258,17882054,12587714,12300186,5958431,14463724,17726280,9077175,17532171,17909847,14628838,17913142,16087209,9500949,17877484,10035337,17708773,16974375,17272130,6038249,14943850,17448869,12921492,13517174,17932826,17933450,17936369,17431690,16477114,17939999,10866307,13123680,9415264,10980057,17630515,17814425,17255940,17216925,7808581,17952446,6588261,12737780,17959012,17959417,580082,4348570,14306691,7323384,6642245,772485,14458657,10607799,4443091,17481778,17974981,17802146,17978758,7313108,17566880,12986506,16212897,12196899,13334935,8925494,4569694,15909037,11685763,5371582,1630959,1048258,14760298,9703090,14559610,15252134,16625029,14271622,1075247,7800760,18004276,8408137,16518823,14040962,10992997,14805898,2934534,11590027,18012866,4497505,17657568,16513013,9766517,15824604,14230948,10893917,15078279,14146188,17834223,2551700,17765515,17215327,4678940,18027303,8060814,14902644,18030502,16939698,16736654,15960158,18035174,6498712,13040723,2551431,17221621,1705786,18046681,1353391,6183925,8358537,17970696,14459522,13998894,14283186,18059123,15071502,6011211,7013518,15518990,16959486,17402348,8234055,11252069,5256048,6778204,9476814,18076442,12870750,16759752,11956781,11155319,18081063,18081311,18061626,15357044,18087051,2188846,9988517,17115806,17931715,17997711,17895280,16209116,16585659,18091936,12744338,18080326,11996455,1827955,15730940,11033122,17037421,9658618,2178942,6173932,18120213,16814677,4116268,17642901,11746037,15296423,16828832,10915084,3002936,4265293,1929678,1909123,17584574,13125581,7656420,2903635,918959,4968963,15220916,13328228,10798665,2065083,858991,599019,18127079,4699607,11388090,11740548,13629133,1848172,7637702,11303048,14399705,14713552,18165643,16962493,14343045,8747586,7502901,8633189,4945721,999556,15903727,15601531,12311742,7524010,17616443,16197470,15741966,17824877,9407799,16558006,10377294,17407649,4838427,13209831,12822933,17520902,13606924,10267917,13584481,16157952,13628676,11662477,17136974,12743202,255577,6398670,8773999,13091658,18217162,18190284,18220855,9855442,17185867,18222551,16130450,18225406,17231480,9958677,12891981,18229367,836376,13007041,18235293,18228740,4666828,1291743,18244080,10117884,18249732,18250140,15833313,4050340,15049827,16447452,16668387,18191344,18258170,18219047,16778838,16895587,14706468,14729041,17728287,16555911,18257273,14631885,10387655,8853131,16972377,14408557,18282410,14409562,15247779,10002140,15040818,6418543,18290189,1836943,17751265,14755460,14787964,11227051,10972607,1058591,12264298,16746141,13545697,18218301,18185181,18304441,16920105,6408972,2612592,11390889,18310744,15936680,16051075,18313818,5650322,18314405,16816224,13133525,15865407,8461786,7774469,289206,15589858,14096170,18208667,18294408,3996969,14465124,16757174,9612000,18332640,16889834,6395580,18334538,4392781,16960660,3810747,14434906,6623294,10571437,18341243,18134242,1281264,5327161,4829218,18172302,18352664,17835230,12868854,13416847,16641359,17526213,14333466,12947039,18357736,18279040,15318424,18358513,11651773,1034272,18366034,2429702,18369263,16511455,7772947,8258660,4537160,16707817,11283980,17467057,9401029,5439065,17876621,15794281,18387634,10391186,15852262,17500339,18155079,16395730,11157247,18398798,17386518,12687061,13540564,13888307,497912,17671531,18406129,17327955,7224685,4022255,15338650,7454765,18412644,14549241,18034496,16320822,18041958,1594322,14040749,13957273,16159917,18024637,5236173,18430748,11573877,5963087,18437133,12367917,18445267,2270806,18448548,359179,15922454,18455730,17660574,18457600,6339623,12653071,18192601,15673766,18095673,14618354,13635263,13174544,15509581,14725709,12711388,17476544,8779652,14879595,5713407,16827270,13731361,16610200,11292047,18246294,17933019,18485158,18485709,3881777,15427519,11120051,18497787,5778280,18313645,10250845,11189133,18493162,10481744,18503961,6099042,15588863,16264924,14272509,12452049,2657549,1433826,18515100,15238846)
GROUP BY 
    u.Id, u.CreationDate, u.Reputation, u.Views
ORDER BY 
    u.CreationDate;

Enter Parameters

Options:
Switch to main site
loading Hold tight while we fetch your results