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 (14792101,12854744,14780602,12635859,13296852,14799605,14800265,1908251,12862673,14168942,14803465,14803736,9555018,11825717,14803973,13514351,11599445,1802826,14292126,10959906,14806079,1907765,13249313,14008981,3741342,14809674,12539296,11855115,1749102,13933222,14697516,14803867,2875917,1363251,13583395,10107912,10220019,7635726,11320345,14000564,8527406,14822128,6895418,10285658,14077123,13716883,10507149,14642106,14832057,14833502,12440746,2028481,14838234,310146,8909621,8929055,14593806,1103122,8477461,14842446,14566054,7108147,9536604,12569441,14446610,14845861,14847522,2277013,14029259,11922447,11092785,8518829,11073163,8176989,14851614,9525826,9238547,13060980,768644,11470788,13614627,14731570,12058542,14864062,13473780,8643855,14866411,14782128,14036659,14495553,14832843,14860450,11978862,12339514,1092125,2692787,14111847,14030797,9352703,10808468,14877972,14879322,14286852,14801371,13185569,14884492,14699449,13251261,4678667,14885666,14506531,4319593,360645,11563259,11538508,12354419,7058262,9654131,10844439,5717677,2866844,14895175,14775979,12728609,7839759,5688102,9608347,984299,11006555,3235705,6486738,12396028,9943396,2184449,7210984,4038800,14903671,14815977,7736820,9154249,14909343,13042229,14909244,12426044,14858513,10927622,4692239,4190853,12494235,14914241,12644028,14916203,1938929,14920036,14766689,11698446,14923022,9269308,11702395,14830610,4884141,14241520,9853395,9746130,14700926,14928601,1146785,14892047,14929600,965576,1322811,578,2815227,14933529,14306404,13831472,10635910,9985127,14502079,14499516,3294082,9103897,6483143,14522920,13501348,14049072,14939284,568327,7547793,10629107,14941958,14861689,6115152,7297067,14106263,11538603,12728698,420803,14947981,14240830,9145200,2411243,14266189,9907909,8517454,4394169,4268036,8212944,6089304,8106583,14951389,14153973,9398642,13024732,14961795,11619167,7505502,14968644,11149943,13397790,13969475,2338941,10189042,4798924,11885185,14974987,14709582,7291516,10086530,3581488,5675363,14980194,13331490,14983625,12699191,6997665,14945571,13551307,11601362,11304898,11543881,14490737,8812093,1055918,14993149,14993413,13960989,1251309,14948549,14995440,9796935,245543,15000137,15000235,8403580,14127400,14967324,3238679,14106388,10197738,12930495,13704105,7915175,14967827,3727648,5948628,7418857,15008578,15007803,5662435,10440623,4818171,14982538,14544994,4692158,11538563,14971209,14905161,11228029,7917815,14884004,2135941,10781379,579381,14986016,6274978,14056873,10694438,13804211,14854879,8487774,12989453,13466046,640901,15030939,10991202,11430001,7920139,15008639,9692996,14337514,9010895,14865807,12977605,10184873,8952177,15039093,15039666,14924240,9283016,274163,11034061,12270225,15044990,8338628,7415326,15046223,10504481,14767733,14868111,6359690,15051212,14998877,849076,4415409,15054746,12202637,15057390,11311389,15058675,9785169,12805040,11346858,13912414,13138388,13374249,13315650,6570411,14683069,12705988,15062167,8504523,13649797,15071032,7927036,14296215,14366506,14885752,15072683,12114711,9849118,1322765,13056155,12540502,13704980,14700831,5570764,15080003,9136832,1658617,14509962,15082536,2283260,15083915,14494896,6908317,15047572,14968827,5063263,2806819,12269509,12195552,2402616,4642436,14441956,4610828,9268485,15096035,15096349,14358943,15106360,1870760,15108311,6177601,10834294,14610397,11065180,14554967,3299123,240363,12572596,3159225,6933454,3759377,3152034,3015723,5839462,13920929,12165736,9437118,11907727,14236284,1031021,14910759,13188758,14506128,13145921,3808126,8077270,803978,10298952,1890619,14301445,15124625,890266,10837522,15126436,13661764,2483232,13106853,15124826,4691400,12796266,15112207,15139302,13102124,14627352,15139978,7862811,4671135,14053575,6439001,12342293,15063138,15146908,14647393,3137490,15149290,14294514,14627650,9298528,5066080,5970903,14905794,11652374,110852,6247420,15155646,12379810,1731972,12828174,14897745,4495790,14190502,14723421,2444661,12675457,9169532,15097056,9753863,12877988,1259828,5932667,8763290,2011659,14810048,9694570,10939354,13289551,9918623,12056694,3324932,4417773,15178251,13163286,14326860,15182475,15184586,14362262,14947239,15065657,14473202,14300082,8167565,14211008,13947464,13124032,866171,15115010,15150022,15101067,12645056,15195840,8171079,12657154,12234006,15197127,14785160,9612794,9582195,6304597,13974914,14117609,884257,9806019,6516970,7406832,9592263,13074474,7321251,14341278,15208263,10756089,6129750,15210322,1407368,4075155,9586194,961717,1900131,9378743,14707657,1934798,15218386,10049848,7581022,8262328,15007400,13965278,12343465,13741975,4226045,4730999,14816366,15230392,15234086,9626790,8311567,6114651,15236748,15225182,15171221,3596376,12517461,6224103,12442419,15194643,14841220,15248826,15250454,3424817,894525,15253446,1832409,9095117,14996453,4556597,5513610,10082024,12035916,14551928,11396195,7629384,7916823,15264309,15264336,13966135,14532691,10013975,11485718,10981887,13354801,13126613,878080,3922727,1779480,13561449,14636386,15276484,14924811,11940374,15278446,14757943,13211127,15280028,14726824,13474389,15281255,7581712,3832590,8859356,13969690,4642925,15277790,3644714,1190851,12856596,14140986,14389528,14742134,15286598,12116486,15281212,10800072,9853692,14691533,15291223,11186140,14590375,9874319,14150679,5617293,11823654,13353974,15302593,7868306,9287711,15224310,15278845,7423746,15305488,9052998,6497191,372306,11796986,15216022,1738094,15310639,8413867,8676754,2428817,12854411,13362681,3229062,6063666,6134136,2777063,945550,15281958,9393861,5935863,6659978,15286891,14733247,2057783,15190242,9513183,5430313,15334467,2049833,10084102,6190354,7882899,15337840,13966387,7242490,9007785,15013122,9421002,8947614,10139946,15218064,14964722,15344413,3157429,15347233,14463983,7345423,5129398,13008630,12769927,1821450,15349194,8063541,14239550,15353497,15353713,15191176,3413414,8181378,11472469,2385364,13242312,13105138,12955644,4718423,15348317,6023826,15361936,14394522,8417524,7883955,12728117,15289254,15319349,14468532,14690960,14892272,15376078,15017591,15206206,15212193,6540440,15350822,15379526,12162839,14591200,6460050,10745758,3733276,13379302,15383140,14305603,14555778,15389545,9473420,15390778,4997197,8252267,14785349,9389293,13257217,14362056,15032847,5053483,14564531,13001752,15062511,14359429,15298132,6949454,15369665,15401962,12298650,14744195,8773741,13346542,13528314,11197957,11062555,9437110,13057251,15394533,1934851,9378367,912744,15400212,562752,15332762,15109208,12716573,9198920,15248155,9046497,15424013,14713356,15067451,12838566,11240382,8462383,15385625,5860388,9503559,7518617,14370872,15393431,9632940,15434156,15235039,14587292,7423397,8188060,11386747,15440693,12881003,15239919,15332105,15436369,14929454,11102385,14511793,15403099,15434092,9928908,4863162,15449283,13103887,15451973,4319849,2950931,13240504,14033717,5747098,3830515,6789615,15459753,14763150,12228311,13220924,14473177,15303058,12938030,2976116,5635144,14450593,6848463,12661268,15470998,7153222,5556636,10386345,11355705,2265998,9915328,15118899,15455926,15479096,3546240,2649384,15352088,194813,10015567,15447273,15096228,14798004,1146097,9982458,9274977,15484877,5931091,14100972,15489835,15493094,6541082,13149856,13775115,7880418,13177568,2609653,15388613,15060907,14480343,15500486,7807893,14636746,10778801,3863660,15504418,15264192,15506165,13704922,10771462,12779452,9525277,6744259,2647106,187922,3257191,12695448,15370323,12325896,15521258,15220214,15523926,783421,7871601,12930522,4858253,11322809,15292554,15535496,12124227,15536981,13280370,11305741,13810872,7469699,6760497,8011495,4826487,15542738,14220911,14565413,14385918,12309808,11025822,7485582,15396553,10660645,7929660,14159635,15276691,3552975,2616060,14933947,15109915,1961582,15151836,6056247,15531248,8761554,6061863,15570007,14923227,12810968,3578366,9784499,10319271,11588490,11261546,12320997,8406122,4903336,13349320,7727407,9105549,15324089,15585096,15585609,7106766,13453565,9802213,14861235,5793587,14003905,13045795,1775706,15566266,6423160,15591292,6474021,6621387,13186127,9813346,10046099,827280,15008911,15604519,12336032,12399372,12968673,2805083,15607199,12564187,15612114,9350576,12081563,12964107,7951709,15617833,15621900,14544052,2949897,15624772,15216838,11723707,15636656,8459483,15343651,13466943,11488279,12283181,11402435,14092720,14680048,334201,14169747,2897989,12153679,11415690,15654891,13378266,11481959,14402073,5829577,9780816,8519375,14290260,15567659,15673152,4465168,15278333,15676074,14858238,15376573,13410627,13482676,3017468,7555448,5228065,10567768,10269788,9745091,15186364,14151705,3956651,6438896,7969213,6724628,15285210,5680580,6905822,15067175,2552630,15598537,2039808,12912943,4499080,15308458,15713090,15715394,15578198,13765816,13617486,15717955,15718742,15625503,2777714,15724685,3786740,14630621,15008609,7903797,15486815,13418745,9330290,15364459,14679439,15740089,3305822,5878647,13757444,9165263,3006092,15183743,11038359,11426538,9548111,8223154,15746179,1193647,15751985,11038519,10758351,14254658,9181468,15593142,15760365,9250490,15761761,13675499,6647852,15534741,4383027,10246191,13787515,5919001,11152653,15591210,1820480,8109130,13014864,11689458,15276863,15775439,5081328,11144990,15495499,4090081,10598418,15014525,2693474,15766752,11760953,6864416,9791980,14596580,14538807,14680704,14981771,10797023,15794846,11462302,9048995,5122790,9142729,13627352,9636756,6667653,15801875,15462938,7914355,10116100,14833143,14994085,15788054,14222251,6557487,165201,2528436,4675794,14567418,10136701,8367357,15498235,4242854,8389293,15489839,10221835,4777480,2251968,15826071,4734216,12937971,15834188,14754707,7121783,15809491,15052184,1261959,12058369,15842041,13168629,8738802,3575623,13689347,15845151,15849260,14594208,15834370,11379774,9259357,5483307,15855753,14055309,15857725,15462536,4397753,10385582,15845253,13654153,14585049,10565084,15867435,15867965,6793742,12192463,14779961,10808565,15316370,15873294,15872320,10542696,14304728,12421479,4476840,14775248,5494625,8779395,14045676,5791008,3166449,12094519,2725742,12038909,14873065,14629701,14284006,8728804,15893058,10636599,6652703,2426195,14089179,15897156,14337775,13892646,12110409,11131138,6895966,3333319,6672247,7200959,7477670,15907195,12711820,15371053,5590071,6843348,2722787,12656411,8790126,13495515,35250,4317058,15917932,13483057,2806971,10693813,14309001,6754913,12143823,4039074,15928111,13076369,15929892,15795284,10663073,9558747,15329314,14517943,15674506,7481202,11771479,15936202,13054511,6239096,15417602,15943796,3939867,15944934,10779494,13850694,10609947,14951957,15291532,11715314,9497072,3343490,15962200,13934256,14608852,15913611,7432133,15969524,13273643,15163166,15176150,15703084,13813219,15976095,11800011,13809364,14622999,15947851,10451708,15481403,15983329,4418481,5025608,12348862,13189505,15683412,11769133,7138899,14349010,12943580,11732976,15277612,16001974,8175467,16003002,6411463,16005345,16006121,13814371,15268533,8641766,14199473,15072560,7781906,14758197,12057138,14557971,7442823,6279687,16015121,15446749,12265465,13503512,15888703,4615352,15848869,15954007,15111791,12493545,4675447,6428187,10425214,12091689,5560529,13812363,15751315,7507337,7573499,16043395,14021950,11753385,16047500,10327728,16052735,15530206,8061298,16057223,7383840,10636226,13411545,4991138,16069561,16061199,15495302,8957019,10588164,16076068,10082415,15609738,12859533,15842860,15165962,10514991,14815276,7485317,11497009,827251,15615673,2210282,13319836,12395951,15598379,14301911,5145643,11673733,430083,15284943,2882236,15062395,12230864,12442137,8288974,16012297,2045185,11693292,16107919,5959175,5249708,16125383,15992173,11451325,16126666,13889787,14934348,5210701,13342246,15464167,15120569,16132396,8857390,16134636,12516704,15371558,14642001,16141026,13798770,16005658,16142529,11643973,13885384,15769359,11704106,13807261,14051329,16150767,16079601,1698143,2299939,13125550,7256570,3556197,14808299,11780744,16089447,7949574,15411070,2482123,16168284,13100162,9235000,16173915,1467600,5714363,1711271,4052745,3436634,5034971,3815000,16145501,16179262,6078432,15288054,15376668,8542257,5085064,3453901,15338095,13500716,6890926,13905998,13037272,11612733,16195863,5836933,10090558,16184402,12319355,12652313,9844342,16207259,13549586,13758294,16208773,16208926,7369112,14896806,16220065,16220260,13161402,3087094,9213402,13876554,11348652,16232405,12778760,16237470,1447389,12695023,13639985,11319463,14658051,16245589,16139327,730584,13803295,9363736,3405113,16248827,14970007,16249223,10958507,2296226,7614000,16254756,5917787,16256485,10346788,14393382,13497079,13787948,14608493,15951623,14428505,16276211,14986826,6939848,1118709,7329454,8769304,14052333,12320969,10257611,515663,5212614,14354509,15963455,2526794,9691276,4310218,8714992,15293048,16292414,8779831,14512961,16298687,16244131,11070439,15173384,16302012,10037886,16232045,12255620,7641046,8306256,8971365,15408069,16309170,16311146,16312955,6355745,5852692,15506606,1857125,10808904,15818111,15824971,15683058,15770993,14181512,9681732,16325195,16014809,12984137,4981715,5450305,16326708,11238057,16243980,12104825,14481226,10094205,16262207,12342425,15982124,13947877,2431184,8695312,4204413,16336830,7875842,10082297,9511034,6877936,11725268,16350941,15542251,6650769,2336165,16353128,16353305,8463684,12984701,3720792,16357490,9482302,16238148,11969403,15456277,8365922,14387696,16349825,10286835,12169560,15304775,16369336,15776999,16320566,7450491,12487632,13766948,11750108,15998771,14830199,8218954,16085371,16325490,5209210,13626080,16380436,16380822,3475912,16381970,1356110,13667070,12243094,16316878,15663244,15262464,15349296,8796676,6225622,13767076,7561507,16393910,14039173,14485046,11703015,16014729,8961994,3835201,15864414,10425369,16400244,14259165,12378060,16202205,16313394,11598249,16356720,14868619,1197025,8264070,12218554,16392647,9642458,16417958,16418917,15392195,12152331,9746134,16421212,13469836,11130128,2560666,16422577,11306372,4292114,12016688,16084581,5025885,4605359,3123657)
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