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 (11142138,9940760,9135328,11142591,9574048,9924147,5179470,2681540,11145420,9134945,10982701,6086057,6503522,6652751,7948115,6715311,6542610,9442892,8929596,9358022,7822957,10339036,3044940,11112262,8163401,3592668,5785385,2391813,9203291,11160657,11160954,1758857,6304213,11163244,10395580,296635,7067557,4526336,10328030,11007266,11166330,9154384,9009470,6741384,8855783,7221808,11172237,11033904,4115477,7493840,11174964,5225378,10826591,9713583,244297,7896089,4288725,3501283,7681272,3580058,10708920,1826783,11179805,7998812,7068954,10572038,5706610,5698535,4941264,1243186,3771755,8901259,2844527,1421332,11190317,2557909,11190971,954427,9279421,9541789,11069497,6499133,8882173,5633478,11077964,1071416,11196694,8010295,10631085,11198568,4513062,4521552,6323796,10897535,10927002,7185816,5136955,11204631,8801429,8630902,3577482,9472421,4212922,10999933,11207887,3752992,6775087,10111567,10985418,4380321,4364157,5901226,2112406,7068559,10969858,10872342,7981626,11223220,9750100,7248917,3831948,9897722,5550969,10028830,6467512,1791317,1580801,9287300,5905103,11028909,4939287,8156875,158060,11240218,7568839,11139846,3442460,2936170,2577692,10332991,8095827,5981011,9503633,9336582,11082866,9008218,3496846,8624708,10567693,11239302,7686668,10153299,6701493,6723450,11061587,11254641,5932433,11257834,9592759,3796338,10410243,10698499,9046508,2887461,9617451,4673558,4802156,10947033,11031366,6619774,11202584,11265420,8088074,9254010,10438719,8426238,4590335,3643544,5670858,413597,11271855,11158162,7736341,1892304,2126809,1303324,3597039,3818285,11156911,11276363,9828314,9541574,10638608,11277082,7280073,2236403,4051748,2916975,11274560,6907255,3759528,8550083,11282962,11283093,9918273,5676189,11284502,10045255,6851483,2799466,3810227,10516686,11218868,5380294,7852426,3547551,1864182,10421156,4104728,2682481,552279,11297948,6295390,5377893,4958229,4682302,1541012,6674213,1431591,9571479,6695082,11305809,8046232,8660264,9583282,1082308,10353987,1748944,288703,4751508,8353168,10692419,8390303,11319284,9785313,8350666,5531761,11046080,11320049,9424625,6280857,3101952,8363043,4309038,4392991,5875052,10565873,11263349,5501407,4924866,10869227,9885236,6194518,2886575,4891717,8952648,10047777,10795935,11210476,3186274,11303413,5594068,2184946,4510954,2090474,3806183,10072740,8869570,10729497,10473469,7211701,7474201,11300028,9834214,11342308,7012554,10420711,11344740,5399598,11345240,10984178,10314409,11136506,7010109,11278878,10217152,5565602,10991321,9358962,11351232,10762057,11352312,6238723,10480032,11350701,2292621,11081236,2429966,11020429,2031542,6746612,593995,5233151,79111,1485311,8989505,2346131,11119825,6594887,2962931,11359454,11348543,11080154,11266849,8406937,10187723,1384608,6581983,11371796,11376572,7877309,7886438,687739,6167321,4012913,11365727,10768127,11365256,7721600,10693298,3697643,5692730,11385378,11175653,8599715,11384370,10671347,9330069,10533827,4811292,10990318,11390780,4677549,8577452,2991243,3000502,11218494,4291360,8769361,3337494,10155229,3447634,8120556,9620890,10232988,11002494,10268559,6271986,10793067,609201,11402857,587587,9233881,11403723,6312337,9898813,11407296,4938574,11408220,11282814,1924235,10155317,10014088,9728120,11363114,11411777,11405466,11287199,8960351,5640761,1487756,11406452,3706051,6471247,10161396,1606345,10793746,9935932,11249030,3978009,9615326,5835694,11422204,10636761,7096730,288174,11424108,4790099,9515210,11426350,10883427,6608664,6848984,9999035,11413239,2562137,4022272,2709770,11086964,9150520,10523739,6001133,11217049,1443630,3346661,11142761,11436671,9499497,11439142,4791668,11439334,11439481,11440033,5554751,11442981,11119252,6472523,6137889,10011538,5108665,8923320,728023,3537677,2961558,11440659,10861035,6499614,9039177,11449827,10677323,2148758,3767239,6715153,8638267,11107238,9997212,10800562,10343053,5574096,10053275,1757149,9055733,11461399,6719819,1731866,1476114,6541472,11207516,8762084,7008190,10200349,9520935,5111128,1021959,1497597,1936946,10711194,11471874,11132610,216356,9750088,11418143,3376800,10815924,9785459,11257266,4331739,10836483,1490278,1175614,11478748,10835681,1693073,6692917,2025319,10048661,11131391,3729944,8957025,9492965,11484569,1644444,11323884,7122385,11485424,2588788,4835426,11486657,10572727,7973514,11489139,5729177,11359529,8577917,9883438,11225631,11495271,1742531,5686712,11226508,1179272,6793328,1845619,8834483,9785024,6026545,7267866,11502457,966344,2013672,2320456,6025680,11503487,11504938,11468892,10553067,6699735,1902610,11184441,11507511,11362151,10109962,6844481,7878793,8009541,1459253,630971,2769705,11103289,11464394,8388005,4559988,3120842,11519748,11158240,11437601,6661222,7187074,7475879,6436759,9046894,10982941,11525115,7469017,11527682,1305541,8041658,11530177,9905185,11533258,9477777,1191635,10352780,10537235,10804423,8398485,3491987,11509920,9651493,11030903,7119427,1868793,11544643,3592396,2284240,4042267,11539008,9136498,6860886,8493865,5651419,2836140,6334399,11554434,7795205,11244919,10129894,11050581,11236470,10601377,4002204,1031569,4172807,4375983,5045787,6667905,7386830,11186083,1392814,11559275,11454699,10836778,1798717,7993493,3414943,9945307,8787393,11571329,11571441,3748410,9725909,10537213,6053974,11576170,2961927,4616299,9507078,9798664,11045998,2169845,11580587,4225199,3921660,10625896,11250152,4806587,1925388,11281919,6458245,11497428,453803,11589854,10303871,9078799,4932316,9582313,10761206,6230282,11436239,11321559,11595529,11597907,11598532,11378438,3059665,9882573,7104681,11352278,7595643,11532153,9081354,2950325,10999949,11602730,2122995,1734698,3887851,6476193,7026806,3101071,11605538,9751423,7723047,2723396,2099318,11454595,7938632,11611723,6652565,7478525,11322178,1814446,7667248,7934786,8290699,11622735,297435,11618984,11500420,5257473,242814,10948109,7380827,11601118,9956007,5765649,8889938,11192937,11631404,11600676,4794676,7370379,4014075,3352254,11403211,5718153,1298426,629530,7696162,2815060,11641528,7122567,9027057,5067233,5104162,5410802,8704463,3895353,8196801,720893,10641797,9022307,11534001,3043260,10039400,5609233,3602057,5697,10060417,11619448,11653084,11556612,11644589,11654988,9382874,8107977,11656194,10992797,11628187,7882621,8897778,11658889,11657627,10618010,10148688,8360465,9511771,9887329,5890981,6230304,9191947,11659532,7629588,860721,938126,10106756,11672569,8013026,6008619,5365363,8539780,10853066,4044412,9814710,6180444,10425249,11602116,9027796,5938759,9666018,4185276,10184550,11240574,1889329,11688399,4434202,11161537,5651117,7607878,10773504,11688885,1811669,5769506,11630864,5040440,11695862,7362261,7997294,9684149,10823932,7435733,4465200,5853871,2582137,11690205,6843935,3633953,11706946,9442142,10785302,7115078,11710327,11673062,11712737,10230809,2486792,1596433,10999049,2711071,11717010,6618669,11486562,7002858,9648041,10529199,10369460,11234942,3412998,11311650,2986984,5593661,8855010,1186165,9683118,11736359,9960006,11722678,7553230,5211007,6618817,11720369,9288117,11073400,40868,10910863,8229421,11748395,6872717,11751611,11750051,11751737,10671200,2300299,11755027,4974439,11755423,8184342,9242492,11728903,9649858,3910919,11637906,7645968,10488206,7719882,4341121,5304915,11716370,10154952,8809992,9815465,8440939,9371703,9057272,5383451,11737597,5333733,11769717,7017404,7938152,5687475,9756816,8952375,11771855,3592078,9433569,7879074,11776061,11755053,11776951,2634349,8723205,375556,10370985,11491585,11211536,3288380,10670381,10535704,10499368,11739326,10655262,10435242,7953092,781700,11400833,10666066,11107722,7725203,2072504,3238611,11794161,1862823,11795433,10610632,11797196,10084649,5636805,4087512,11800497,2447119,7097867,2406208,11802766,1609514,3375487,9884248,5102533,10309342,10310461,11799369,5953635,11325867,5920324,5568405,4680581,9048996,7253178,11813393,1442450,1668622,3678998,11814645,8860764,2119737,11815300,10464334,7188099,9730327,10837450,11035850,6800513,10152456,11791988,7576827,11713652,8657639,10542491,9786129,4702983,7127824,841830,11787970,10004713,10769300,395029,10465707,11821062,4903014,2983211,11014800,6665916,11820707,14817780,11822427,11646935,1021504,7454890,4831083,11503237,10692380,3573995,7899374,2092258,9174015,9047633,2449656,11846982,10635632,6036363,1812633,10402319,4281872,8513730,3128796,11768006,3306294,10637036,11783672,10756778,10308549,8374202,8313965,3218736,9320488,5967798,9719505,11857461,10106578,11624242,11143781,5424931,10683888,5655783,8066678,11866639,10001688,8811193,10789983,958464,11869200,947419,10168686,11391560,9271266,1730082,3396283,4182556,148496,11583672,6233807,9232077,11661202,4203930,6273496,11657250,8076386,6763224,11880142,11880659,11880728,10752734,10409093,3349551,11883580,1178000,11510681,11885056,6652689,7620783,10672112,11848917,4222629,10594994,11883571,8353611,11889240,9974726,3732793,10262013,4582220,8354083,11895332,10692258,10928672,5764943,11862742,6553328,7329742,11558108,11015597,7276107,11895031,8109278,6194027,4046605,11905680,6351322,11779248,8596503,10522671,11034193,1884155,8018636,11014463,9613040,11909479,10348108,11913650,8860610,8508907,9932521,3831776,11837213,366064,11918459,11654569,10713992,8383236,7960933,11919008,2332975,4146534,11409776,3996548,10512917,4441172,11153062,11813316,3758745,5386338,9200502,11933257,4893537,6485674,11935327,9012487,9179925,11932885,11824543,10438410,1270865,3018377,11939297,11619839,9146784,8972295,2014112,11618039,11751646,11480856,9183824,707618,10912105,4450330,4402433,443704,2358165,11169057,8473031,11765487,10396548,11633355,9431520,9172344,4180822,6653602,8256328,9773651,8020018,11966213,11907141,10190084,11958375,11732342,6678549,4416304,9820538,3252401,2759064,8185618,7026958,2815551,10468505,7158603,6431585,5729509,11909458,7123913,11130261,8731750,7644243,11773268,11921418,5384568,11328122,1860372,5767124,1461482,4163923,1157368,4143533,10215770,10829044,419399,8997372,7696590,11941232,11910661,11997358,3208351,12001628,11686383,10536169,11838115,10337470,10054049,6621898,9621700,4281051,11457399,9024698,7109755,11948285,10936591,8844309,6081551,6839670,10193815,11699772,632046,3186070,6264539,12024882,1820086,5545017,11123197,200759,434822,2372500,6875778,1880247,2362671,11374051,6765460,438273,12037247,1621736,4285295,5619766,11765408,7250309,9502313,7556522,3478726,4136124,12044750,9888641,1315400,10546122,10590099,11957767,5943616,11730914,10908536,3722772,7687213,10604604,10369214,92,594456,6630230,11954842,6038204,11702962,5544791,3204706,10478247,696460,12039860,11137122,1248361,9533133,6108934,9072136,8219358,11307098,11879492,6781312,11104068,12069120,10351165,10610280,10530951,1060051,4162737,10780320,12074922,12076789,12072545,11943543,9978943,12078089,2893733,11903343,8958641,1903162,5309950,12085303,4983056,3019105,12085723,10462735,7867536,12035343,9959589,84128,3945762,5127818,7390918,12093812,8748314,5208406,807275,1821364,12097004,12097547,204658,3981486,9384858,12098480,11931029,12097232,9058538,12057122,12100533,9463531,11596021,8443899,12084504,12103631,8355837,12104082,5305638,8217266,12105351,11749095,8282055,3386918,10134974,12027061,1467082,368254,12040179,5458742,12113521,6376464,4738685,7879423,7215853,11308756,3054025,6452137,1343196,10344290,11984533,10493338,7098722,1667760,11642178,5345646,11486181,10946624,12129243,11802015,1392568,12130146,6002165,11819103,12069468,10716984,256016,12135317,12135423,3950745,11625023,9436520,8724953,2556528,12138592,11838279,12038646,12141850,11858512,5313253,3431557,10361047,12150236,3320585,1611187,8714563,12156525,10919766,10970934,4257296,3639530,5899345,4727200,2524304,8728909,3433805,6646922,12139034,4332316,12163164,9475488,11212725,6114993,11918677,12030362,12166567,10003205,6724526,12168441,12168589,11611558,11459802,212378,2618812,11532609,7659694,3711421,8732793,11356272,5916686,12175851,6804284,9032310,12176642,2315238,6949663,2989788,10696798,8804039,10549039,12063657,11805298,2097240,2265190,8013752,10237648,8388057,3004003,2468587,12109703,5832619,12183625,775582,11635253,11392827,1927753,9273406,7502962,12188258,5611077,10491603,10122154,8188120,8184859,6628562,5666489,8094704,12143459,3623247,12129980,9853206,11581586,8850917,7994355,7787367,10818522,12202969,6062972,9327142,11782577,8110010,5995440,12200276,11857961,12142452,12207471,12208914,9043873,12209865,7281675,9987309,12213218,8741615,5134722,8044351,12093066,12216971,6094930,11352180,12220465,12222512,3448634,2259192,12060599,6044207,950244,10693483,6155022,12227020,12127661,4100114,92560,3472827,12229306,6673009,12199254,12231707,12030143,5326540,1092555,12233846,11283034,730606,8311849,11975952,12229666,11993090,7475429,12226877,6877559,6654947,7185102,8194166,9886044,1005607,12241060,12241149,12241147,11556603,12005049,8096817,10567717,6269246,10906779,4938616,8818353,7956906,7393155,5123730,11493867,326389,12177150,7521138,4741752,12189367,12028319,11694834,12214258,11226409,10623338,8734264,10129180,6621346,5733078,11976978,12261404,6787398,7341904,7891326,5117267,133584,8203057,11769345,3077484,9165191,6447529,2750743,6833372,4003581,12227742,6595663,12010454,6717178,10539746,9636451,4832342,11539875,11946272,3749058,12009071,11694850,6939221,4003476,12236313,5620511,8483900,11873063,7447660,9367990,1678893,2581360,10696220,1477700,1959596,4526139,12022658,11848868,12283740,9912116,497600,11136641,12286156,11176533,2685083,12288659,4820772,12289393,7892517,11889425,8045346,11892842,4042640,8241568,11002188,4451072,8378816,9182179,3030406,6418023,12182220,4160770,10872199,11401387,9271092,4554471,11503182,205606,12075307,12127699,1329147,10426831,1418882,12188792,7351009)
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