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 (6378506,10829405,13839762,14351788,18525537,18525179,16703162,14285851,18484087,18528221,17540839,11156387,3607738,17660052,17616509,17851099,18534946,18536141,6183282,16562611,18541926,7211596,18547053,15514474,15574775,7200174,17590495,17006981,9262339,7291176,17749698,8250424,15167728,6200611,6419723,17564445,14517101,18578077,13096448,18581181,8103683,14398957,18506922,9903449,15011793,18238422,10091200,5710793,16776569,14988107,15157092,17098225,11291508,4505512,755371,9842514,17478126,10957279,14725633,18226649,11019185,17726874,8031875,18618951,18624806,17138796,18628161,16957532,7575924,4236181,18639018,14169836,2844366,5091483,12367119,6150899,18660119,14735307,10032294,3699804,12968928,18685883,18686168,4402572,18310078,12568156,16941929,17646108,18693514,12238287,18677317,16271643,13471744,15649966,9065706,10609451,8838420,18700958,18704548,15782057,10678505,13855451,16346226,15352261,18541354,4641984,18118242,1843511,13672123,18142329,18715372,2520359,15493645,13173633,2876983,11085495,9986195,1999917,11774587,18642521,16293100,6630851,1815449,3091408,6225525,18410740,11109346,18749257,18749472,8134421,8109057,5927926,4171008,1487069,3976361,18741631,14721066,836018,17806898,6091187,18016959,18740236,14478240,3917,17512814,15188394,16265174,12645199,18045244,18701595,13687718,4967403,18786241,14379288,14990990,14844438,12912245,18793949,18741684,5833159,13314829,1026892,12682136,17450256,18192780,12490047,12246961,15675376,11360421,18832539,2538352,17109540,5085211,18756370,18523444,14319953,6581649,10365325,18846600,4625086,5452439,12586465,13221816,15529718,13172903,10383650,18594243,527037,18628468,18875522,10798630,17396583,17599893,18881531,14013882,17727394,6818069,15300604,18620006,1745291,14808001,18908671,11672259,12786037,7899979,18925890,14955658,16319933,13511223,16431395,16036629,14640064,17607853,11293742,16562662,14150125,13739092,13882018,18589288,16019660,18942169,17119612,15878256,18864135,13412377,4142927,16346152,17465934,1029088,18960640,18958253,14453002,17879386,18963402,6767102,16118686,10520696,7607751,17823123,6203107,2317685,9665117,12067966,15670527,10592812,14319964,3459685,18972217,18629711,3150636,15648066,17614770,18698553,18991702,15638272,18726774,18172784,16609435,18935218,13174239,15121032,7675470,16968868,14417844,12999319,15596825,18523547,1998844,9661091,11810596,17618559,17140510,10421103,19006853,17841882,13104490,6785949,15743591,17505462,15009108,17411570,13292756,7189732,19019959,14608235,15853075,14984937,1714029,9981447,10889650,4365886,5858752,4695271,3666612,14670557,13082464,8822747,9542563,5638513,2232149,16510444,18733659,11035763,15314674,12192973,13941830,14051188,17107678,15418929,11816230,18282219,19076263,2837434,7322456,17020923,12171469,3811481,16896125,18248018,18544110,19084257,14006468,18813714,4875631,11610033,18447872,17989014,6555209,617845,12506871,6560375,19092876,14647918,1542523,17176201,17863435,19080787,14188938,19097764,13370365,17335824,19108002,15147942,19108159,9933571,19054256,3936878,8941316,14858963,19109061,19113872,3438578,18716816,15338745,11371936,7369790,16985713,3133027,17438609,18928520,8959976,19124817,14451075,6295517,18725546,18991455,19127357,19129565,13507488,8049982,19131317,3733534,16539675,19135994,14136139,10282471,11405048,16225389,1430703,17120434,16223654,3662181,1707162,17873999,19148276,19148569,7251685,12092576,18995569,1143162,4932340,13983450,19081318,11743016,16511613,824952,17944510,5075065,384936,13522177,19169509,2816215,19178673,17023496,85936,6905166,8184326,19060454,8899386,17816079,17244044,14690903,11341931,11833842,5989396,19204330,19204555,18712167,19180332,16106176,15942055,8898382,6753317,16781087,19208825,19001258,13595540,3051741,19212163,11714498,19214950,15928156,19197581,3261932,19197634,17933798,7600834,19169227,19222521,14264687,5334552,1168582,8880833,16610762,8694730,6155341,17803283,15255146,16795292,17381639,1838334,7367060,19169791,19225636,4823392,5607457,9555173,15993069,16255669,14452555,13262692,19251428,14098341,19256335,11491606,19259458,12665199,4638615,11356859,18071806,8885740,10943917,14089774,14425327,6852127,12395473,7760910,19270012,13337516,16169684,13281230,3174208,15478299,7885317,3357352,5607735,18480976,12888632,15823356,15886080,9550744,15783095,3832676,10193693,13323411,13467482,17898592,11719797,11344576,16388591,16814318,12858582,19307675,19309337,15002954,17868852,13921399,14492954,13581629,18318487,19316252,14433929,19210262,18778624,19317524,18468519,14105067,17913318,19321051,17355412,4810705,19126934,19288982,14340115,19319892,3416725,15101476,18677870,12880493,7588726,13999386,19340400,7330585,11814768,1068980,5269048,14731794,19350036,8443963,18057231,14842709,14596851,19065806,1326784,19359292,19124883,18021766,19271119,19235920,6020972,19360223,6212918,16777220,19069889,7994895,19202065,9380238,19372977,17575435,13185457,14537239,12293801,19239269,19092006,16911576,15737778,17870327,19391923,19362000,13329082,8238533,19275776,18917060,3429266,19396165,14328098,14736913,18467492,19403846,1336427,19162484,18742237,14553609,5166365,10870968,17771369,11061645,19416310,7874693,18179297,11692496,2629879,13148212,16557590,14136601,5846981,19427107,17672640,9341643,9071943,18873112,16354660,16945470,1778275,18012443,11520765,3580621,19429306,19440249,13361176,7013684,15954508,7723320,19381459,9632099,19415634,12263957,19142651,1320636,15198635,4621358,16736621,19216516,14978865,2195440,14973231,11860860,8876735,19467657,14516525,16837497,14328643,7032062,19472668,14312178,19354807,14681152,19222764,9666551,6670282,18289649,1687356,13797956,15581801,19478283,14247573,19483022,17961236,6539606,19485852,6938902,2164703,14026393,19213568,9355500,10259848,15909123,13115116,6615113,19426256,19131359,19387449,18311567,9386871,19508208,17939527,19510037,19510373,16394610,14106191,17431300,2060530,16751858,19169850,8096611,4700548,19436766,19458543,19488107,13292557,17754106,17032101,15303299,8134995,10416012,19492991,19479450,18175624,13813440,19529648,14622724,19531204,9041947,16545718,12246941,1717173,16192427,2044454,19535793,19537908,15233212,8127588,19538334,4510252,9446319,3113356,19543090,13038260,14985387,19545469,19546682,1127809,12227633,2128915,11467279,4533205,13516633,11055368,10631590,19554861,16427252,13762763,1067339,13493570,17390263,19557401,10132168,19565633,17769960,4135570,17994414,11154545,11986167,19573182,16192705,8430792,2913715,16727699,10671013,18783808,10216112,19300413,19582741,19584581,18007256,19587249,19588425,1336336,12894091,14602767,19564385,19592022,19592636,8340761,19382015,7301680,19591467,19576917,19595744,19445253,2576671,7824560,16029660,9735528,11300261,13002088,16728958,11012817,10873733,4393136,17601629,19607018,19607296,15673208,14377954,17547190,18102425,18935522,5471451,9489849,18297195,5169790,7516523,19620199,14309052,19598216,19372215,10726504,6076424,10984729,19620526,19588519,15537109,9021715,1230884,10649860,9156530,14993973,3687475,4596327,16719512,19633413,16641034,18733163,12328911,14366712,2825118,19641787,13667392,18719109,17212169,10675556,19649129,12075149,17705701,19654211,16532802,3668936,18411878,19657424,19338726,18835228,13401839,19234424,12281931,13393743,3586940,13579707,4619106,14155869,13312159,11770390,12028540,19527947,13015570,19675751,15585490,19676757,18863228,19681070,14137474,1910236,15400820,19491527,16581921,18606837,4875624,15219428,6174047,19579515,9969906,18716082,11649202,12894878,19698768,19698894,13518907,19700646,12937828,8973620,16199278,19703480,18786445,13069299,10978325,19708082,15543871,18378560,1001532,19327078,9631848,14586682,19117609,10226695,19468277,18438112,15774229,19651829,7862279,13604662,6739732,11710457,3652240,19697370,16673416,19225092,19738266,18373969,17520188,17704218,14250641,17231317,19749559,19742228,5405596,19752924,17494344,19756755,18105174,17114459,19759261,17187713,19761901,18727166,13287992,19271847,14115129,2523881,14140941,2450280,10022571,12425736,1364636,5426835,19773402,16281064,19721295,6554760,18365438,18838284,15954959,11328614,16407186,10088866,14212278,9115288,14829276,19789298,16998718,10595183,19336886,12733585,12915321,19209944,19799819,4364202,19237641,17112488,10543310,6218858,18864445,2551645,13206688,15725483,5382248,13757540,18827703,17017832,8272769,12975882,19816277,7804387,7014126,15137802,19419510,11786796,19797660,17119254,16636422,19824196,14748984,19828152,19386963,19836178,14836806,19838994,19839062,17908089,17186197,14117912,17118493,19459377,10546223,6836629,14725103,13118859,19681078,19244821,19852194,14812528,19854191,19854513,17867420,19604644,19832969,13500182,19811983,19459114,19865914,12658094,9443671,19871188,12201585,15094353,10911317,10021083,1870400,19214720,13836950,4247079,534298,15812328,4891964,19681418,7471760,7742855,14625822,19190248,8072841,19890163,17134679,14693830,11469171,14882862,13925260,4897021,19171684,14210975,19902449,10671367,10407899,10894103,14725599,19840375,4417806,1317018,19259059,14851574,19921681,11017672,19853004,19526132,19574505,19929643,11452928,17517821,14671285,11351647,18703997,12137722,10735588,19941739,736910,19944047,19944661,19946223,10839538,12699458,13404522,19270089,19670875,19929737,17724014,19963790,9911671,11004423,19708877,18531134,8094926,18471608,17027654,19934192,11317931,11849478,9131311,14072362,19490339,19870246,13357176,14979773,9847607,10417023,16333852,19077379,16841473,19950066,19804254,3503711,9837166,18181444,16708103,19613764,19994189,16587414,17394853,17452296,9451696,20003042,14156233,15064501,1292378,195957,16566759,19801460,9856240,20012486,20014033,13191928,19429849,5852506,7710758,2804980,18806082,9972592,18295038,19550657,19910214,17762917,18897610,7809652,19832299,20030539,17701409,17395225,858944,20041217,20024462,13951623,1044137,20018861,955444,16300815,13893919,11850938,20053601,13529043,3318542,7394743,1466158,16906826,17593050,18909694,19923865,3890560,14123506,19650316,19562529,20082492,15746057,10404569,469203,15061709,19495316,18845587,7343177,15237498,17665627,4437750,20099732,2567998,19394678,19360436,13361469,13818430,14619678,19390353,14747507,5837992,20112894,17243842,18239939,10633743,12068208,20126513,18492054,5925291,20132166,19574867,19999439,20070917,11345445,13584940,9215367,4022511,14739761,16571116,17273649,15881484,13954798,1999969,15275032,10443592,18576593,11013499,20105511,20158986,17398182,8027970,10474388,15743379,16071304,12282361,18556006,19010792,8777946,14688090,16994868,20020130,16018684,7312760,199247,20176991,1043529,2449857,7926413,20180082,4098013,8018902,19910496,11367139,20185043,19952690,16368306,20193138,11436382,14382835,1956082,14678910,8824397,15204047,10460447,20208080,19310940,4009959,4062818,18668656,18918606,1160022,19934620,20217596,12663515,20188402,7766024,19133539,7741128,14268786,6510866,7212748,20227015,17981328,20248185,20248449,14385066,11187611,20075046,12314164,15261015,17883409,19566271,2658200,18109197,17421675,20257123,20257171,20257424,18270421,10461625,19724348,18218109,5088513,20173589,12008421,12224131,12042615,19727965,1723231,20275918,9251484,20279362,10561318,5726763,20282322,2625402,20033803,3622232,8304719,20285022,20286778,9813502,8495458,16494728,9659080,13585087,8362224,20295486,7893438,15951473,20299352,20303618,9372023,20304479,20305903,20306231,20306413,10020470,20307062,13286705,20242091,20316440,6811697,3999647,7496039,9867326,20030435,9794423,1590265,17781468,20328629,18071854,16961158,19997982,7758213,3367144,20278443,7791963,12612352,20338677,13727798,6329331,13695391,12460488,16498831,14057695,8956723,20346244,3019281,11580012,15910780,16292661,5235321,14631264,18815165,18615293,1324023,20360455,19820043,19292346,20253976,6712966,12498785,18375727,13977826,12938285,8378256,15402043,1653771,20374132,20374510,15916361,147202,10308289,20377712,20379331,16441180,2047436,2758414,20371693,17463100,12692236,14449776,20275859,10469210,18432556,20387372,18195488,19899372,15229197,20215993,13380450,20393019,19231322,20222958,8981368,1864003,12497141,19860082,20403425,20401296,13745656,18836219,14432525,17685810,18715651,7052933,19944087,6936570,20412926,15086379,13476754,18551908,20380308,6729983,19110980,15418907,17101330,16420414,18368555,11445194,19845658,10750387,19297945,14608372,20387248,12391090,5231110,14170108,20082648,20382038,8741999,20171621,3410351,20446134,17048058,9222745,3342825,20449423,20449028,15282464,20451990,15067728,19933011,16400339,12509647,12868641,3769082,13532174,16240635,17736660,17944655,9519132,7768598,19693550,6240756,11059237,2890343,14508616,14538687,7244031,10885530,20280771,20232657,20467824,20372799,20468581,20441537,20469584,12395025,20473417,20475752,17420501,2115332,19809278,11476950,20452398,20479866,18990922,4139780,15844125,20485030,19009428,11239629,15768582,20490989,20494879,18209945,20496192,16694896,9476690,20183885,16698040,20500173,7128910,20501559,20504851,20506257,20509660,18032631,16544164,9439634,19362230,20509797,20488787,1308692,11989132,17954646,18389691,16797605,7906642,20524946,20526462,18875957,20527299,11239996,8143322,18217687,20532996,20292772,17220834,18992987,20534478,5640258,16951957,1211142,15388288,19638654,18950910,15235825,19628700,15266522,13097920,20357149,19963199,16743990,20557167,9231525,11280182,20561407,6799861,20495822,2125172,8085276,4903995,7556646,20138466,14902147,4552691,773595,7787537,20323181,16508859,14673832,20577808,20138135,13440165,15690088,9565145,9095818,20582811,20583415,11993580,11697553,4261809,19607175,20586371,15060554,2980891,16513535,17660385,11127962,14812107,7214510,4570550,19665553,17587281,17936179,20604228,18984369,9167911,20534662,10425289,17304056,19951485,13555930,20611237,20594260,18290946,13440680,20430376,19821502,14726548,13461021,15603181,7115354,14053689,12429692,20627646,20628792,3128341,12700110,20633018,20633828,20633685,17896393,20317420,9636730,15342599,8592452,10501423,17947910,13941802,14810457,18801452,10967961,14833479,1674940,8816299,7588202,20380423,2597213,12030069,14941320,17215983,20672627,17934589,20675958,19568665,20681092,18998364,20401500,17277357,20682332,12536057,19136165,8384910,2842356,20301450,20679867,4814085,19326815)
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