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 (10900030,13334536,1552192,13569389,11253065,9585304,9477950,9410469,12563240,8631776,6242613,12649452,7508046,1289844,12217897,5629358,3094625,11866231,13608141,997088,13192225,12828370,13499542,13624055,10978642,13625697,3906884,10165763,11414768,11765418,13632026,13338498,5539351,12161275,8192894,12329765,10677636,3722635,13635745,1200914,13600495,4523226,12838920,13637837,8348634,12333542,10249208,2324133,5357986,13562914,13643036,11973565,11409011,10615733,6059213,6237880,13428397,9186380,13602076,13648595,13562449,10057173,1676448,11330582,11520161,353512,281313,5305415,9341540,13653436,12953596,169278,12316727,11846568,13655700,9772691,5740428,7269177,3252285,13469674,10426546,5257342,5709159,13658724,13653676,2118665,10225590,7721886,13199018,6430676,7027129,12979850,13666226,13666778,6786718,13555490,12126503,10426919,6066784,5921203,7082339,7122224,12208261,12216280,2358233,6057289,10172499,12770999,13536686,2934716,12731348,12114587,5347360,8471995,13408652,10233875,13666282,10797481,13682569,8034652,5960819,10165426,13587380,4094390,5364135,9974148,10089257,2124814,12778682,13645184,13691288,11495722,12284396,13371656,13536203,12042545,13681569,8499604,12489338,9438568,3054684,8340508,13061135,11913315,12203794,13650883,11739249,8121995,11803732,5661001,11079546,9709825,13690008,11316746,13130432,12649889,7610701,6545542,7616649,10654327,13519364,6500450,13650982,10022917,11219989,654602,12294601,3882729,5139284,10570197,10577976,13521358,4884156,13695066,13724272,11686526,13120115,7462256,13725918,13652671,7153012,9262075,11472268,11127624,13474159,13734975,10777939,365104,7531988,13736085,6634997,13712512,3112339,12777835,13011536,13599087,13742194,9290434,12201107,3226367,12672814,11428584,13532349,7993857,9279753,3234321,11952235,13609893,13227771,4237080,4934531,13748796,12612615,13576794,10464276,7293283,2693146,13744854,13752702,10535296,11149305,9781499,1518100,2261550,13383036,8229265,6540361,9282668,8971854,13602109,13743294,12273958,2959627,13758423,6307331,13705558,2056823,3207882,13759708,13529855,13016512,2515265,143548,9167762,13202447,3625655,13364818,13669210,1677646,12391986,8523583,11045704,7046042,11742329,12232652,5025009,11935558,11200247,12897971,7569787,1350066,13426157,3849939,6106508,5477588,8193814,11722159,8420856,12644421,10853121,2989330,446791,11779489,12757690,13781097,12388054,12842866,13251529,5222092,6034380,13732474,13732724,944251,8518930,11597069,13670025,11749384,10891108,5743692,13737490,11161652,13638088,7709936,6673576,11778079,6066670,13409883,13476560,2761201,13799087,10291823,7745011,13441667,1188758,13801485,7451837,7601346,8459264,10364943,5492786,4252274,8378586,13662339,11933459,2019133,8551618,13041848,8725149,5960363,8167554,13811940,13812020,13807698,13486304,7879199,7990420,6843496,13819793,12535090,12937285,12648193,11407167,13650874,13823509,2382280,13092203,13824359,8637876,13619897,8137847,13825548,13825994,4539385,12684060,12516727,13414236,13825050,7402323,13713996,12322186,13395015,13503519,4530731,13809664,13833608,8765135,13632128,13143047,8271180,5602689,13683188,13725909,5707848,7436844,7985855,11296199,152349,11130844,13841307,13381793,10100234,11817119,13762810,11326110,9563043,13844850,11055992,4397297,8086153,13181639,1364242,13847770,11151457,8795358,80779,13841217,13669263,7535209,11493659,42024,10876551,13824554,6359141,8162719,13496373,5949308,117839,2762800,9653178,12808129,13781189,13860872,1459248,13340183,10241207,13698858,13402779,7730795,12537795,13584688,11125577,13723121,12358222,13753022,8917048,12498401,4373421,9213538,11007722,12276557,13731009,13175857,10325018,11560784,13881826,13336210,5581893,13736727,13874203,1745866,12842932,13591150,10767629,13873230,5567976,13886913,8541840,12348816,11281015,13064271,12240497,13892339,13798097,13875739,2877689,8810271,9832947,13748443,13668347,8907687,13047827,13901862,1332817,8960720,3188445,2316478,11121103,2491639,13425224,13905944,13813625,13906840,13494472,7523558,2912218,11909972,9543999,6155387,3276533,5413709,12195705,11102816,13916065,13916548,3961841,10753549,13794921,13175708,13649465,12266046,5536388,3083304,13920900,10482976,13851769,8488985,10203244,11569163,13722367,13887401,12023199,13925963,13926893,13769705,12507261,5818059,10766043,13686510,10311873,13930866,13259978,12962996,11721385,599184,13437498,13427818,5676613,10589966,5071607,11930998,1251070,7399330,10475540,13609858,11757687,9861846,12001081,13944751,10535329,1940392,13946221,12921954,13948731,11846473,13859339,11013728,7048606,9033446,12369606,12743240,13950295,13809728,11905630,13318158,11915653,4236861,12811796,13824147,12822863,13952307,13962803,13392041,13899946,9099678,11292747,13965678,1544278,13959593,10952062,13967157,12997511,11598353,13969169,13524418,9492900,10562019,13971534,13913835,6835416,9915758,13912585,8885077,2890407,10418388,13680535,13962895,5841297,13643851,7488260,13701355,13966275,9996914,13979781,13137213,10336496,11298832,11332416,6922919,9730118,13984000,7841877,13983864,4505446,295802,7721497,1379826,13987843,11881663,7248882,2004223,10958617,11322131,11145302,13992531,13993446,12070876,13995473,9428398,4968749,9542718,288096,13004901,9803558,777675,11706354,13999677,13999788,10358768,14000018,11970836,14001350,5817020,9168000,6650264,12031880,11797955,14004902,11191769,3572886,7200745,3753446,13140770,13807781,12658756,10161504,2237136,14011500,6732893,13771489,12383616,9123382,9770413,10065280,5675325,12022718,10780826,12696163,11415870,4753359,3318440,13912132,5011398,8791491,13886735,14024760,7245820,6775155,1008405,12047477,4590787,5291057,8563661,13836040,13741118,13579541,14036620,9992856,14031051,7805205,13877613,11511397,11510068,13224117,11951680,9761457,3810188,13926001,12101852,14040616,441914,13149216,14043713,9090436,13343565,2287816,5769912,12231644,7990195,1120793,384511,12697890,7080416,6481181,14049653,14049854,11736696,13378247,14052739,10246734,4508767,12731261,11664210,14059036,6079625,14055643,13282963,8574960,10971848,11063234,14061528,5970929,13207653,14063475,11074512,12333233,5403605,7470988,11153714,8884948,14069865,14070529,5330333,13842468,13694393,7493307,14073188,11770577,14021711,12929571,9466925,12067876,12012519,10537609,11897396,13078832,14079930,1282931,12809944,12870119,191246,10230774,12941414,14084231,6332233,9650710,9326908,13375133,1301445,14086206,11902143,6134607,14083209,6059696,14051440,12816899,1786401,4646738,12165628,10199866,12878032,14060467,12004055,6660207,9696715,13422844,10597900,4708302,3300327,505308,1220650,14101716,12210257,7823769,12473258,1077748,13886927,11573842,9870847,5597156,10819435,14108757,14066169,9036354,11330275,6736299,11512559,13966865,13349889,9713793,13420525,14006621,14117802,10965279,14093709,10663327,9608759,12307084,14119869,7427882,14121060,14121068,336511,9684729,3983650,13829291,5711656,12691325,1218621,8332236,2339067,11325591,12188800,10007349,13031455,5300715,14063484,10808194,12368759,12504573,14131949,13684079,5483415,9079934,5705143,14134825,14128879,12753809,8515920,901944,12461907,8830780,2986034,7293218,11188140,14039642,14081767,10054375,14060147,14126448,13771261,1227852,9932575,5594365,8684048,13913824,14145890,13919378,2788531,12344938,13549067,9794212,10249728,966656,3850437,8902744,187949,7293353,9438889,14155758,1702343,10147139,10024974,14159844,14159782,11032382,12161033,13916598,14148391,14004373,14164225,3026715,9881679,14133956,7102001,13809070,13954079,14168462,14166126,63399,14170759,12937905,11568389,14051878,14065450,11400691,9591511,353337,14028102,14127394,5072418,14178598,13854431,9045125,5595462,14179467,9119202,2116486,14010656,493093,14184193,11408683,11320292,13890122,12460757,14074346,13204939,12002184,14186742,1785906,12150021,10941805,14191409,9219726,13064645,13486593,3455699,13096617,2743931,398348,13067358,6186977,256439,10486963,11671779,3906993,6822050,12044456,8684461,15592305,8694768,7627317,6818383,14060425,14215806,7022865,14179238,7138943,13757530,6216841,6454729,13395302,11708957,14220960,12105264,14222090,13610852,4770397,14053486,14153689,6717168,13725828,7612569,12722697,14133987,11598111,13402795,4238127,4053100,13825281,10145519,2520119,14210998,1514605,1042201,11938198,12292000,9092223,7619814,14239823,13574106,11213898,12844865,9436943,4353740,12949467,5709026,10452700,12316619,1541782,9851845,11394505,14080218,14109940,1847560,5395249,12184675,14224115,14243223,14174901,8894715,10358059,14189660,11864217,11327283,12323121,6085328,8845766,14261828,14262408,7006438,5102963,7790770,13324175,6582253,10636566,9849954,9153953,13510894,5461463,10576072,13987574,14217587,9004116,9363081,6602522,989577,10868964,14279207,13551062,4663185,12642588,14178220,13100551,12989318,13584566,6410799,275669,1773021,12408076,5501090,4282819,12662713,388360,9723048,1686300,6481225,12833553,14289302,14291899,14292093,12471912,10457569,12192978,12869764,14293612,12138512,5766952,14274159,6248086,14227543,11681480,14299068,14300046,13692000,9955004,14302259,1250957,6916458,4368442,14227985,12049316,14273885,10218878,7234485,14305820,14230189,6547985,14306679,5403573,14309376,7798109,10738778,8540221,14317375,11284175,6554071,4520592,10472254,14311875,11865866,3972814,10210186,14323335,2471385,2396804,13858508,10116936,11223349,14327564,10941000,11746564,14328778,4602640,127508,11049682,14151627,12889969,14332233,5653482,11358854,1694518,12583968,13379374,13056176,6098065,12405954,14336152,10572540,9820207,7752230,1974416,1630046,13761525,12100942,4473841,8242494,14347339,553786,14348839,14345861,9788536,9476190,14352752,11189825,13985370,9116704,10373970,13921816,13821665,11305480,11384519,5091507,13699516,11592836,14174297,2810015,14370996,9733999,14220985,13710987,9319845,14287178,13715349,1877002,2038363,14377836,10375433,1424746,11191691,4786123,9427325,14381066,12339037,11627521,14382172,4169571,10744139,2205969,9919216,11671909,1705337,12312377,12949744,14098322,8276489,13644052,1622162,13445722,9093935,14396053,12553917,14370531,10778337,13842934,14023514,8526764,9267628,13424118,5222307,13419559,14400319,3701974,2752107,10033941,794243,894903,14403137,14406852,14408909,12711514,12685721,790962,1641233,2660766,6626233,3267110,6504633,4793353,13657719,9058638,14415734,14416097,8148637,11798988,10827578,11878744,12957792,153006,10050942,12304267,11408073,12363968,14425031,7943505,2447370,14076312,13604219,11579013,10240549,13816788,13227751,2093077,11705462,471376,7874548,10837945,402169,11808605,5594299,14222893,12975170,13946307,5573256,13744269,14437282,6405427,7301760,14441562,14442879,14163308,14443062,2661846,8444708,11118412,8929758,3796268,13799542,9422175,14453586,13589746,13104891,6767821,3508140,12704762,5376488,13094805,3226551,13734424,12915588,2337326,8815096,14193797,14458529,12622504,2774589,13204619,14470577,13552470,3266972,10432320,14168669,9759747,13427842,576682,10466595,7211795,10424428,14472157,11257137,14105277,10542256,1781301,12488004,8798241,10962180,12152327,7743258,9793677,11814022,14495564,11022658,3579955,13458134,14500681,14501655,7181909,14503853,14041830,5281775,14471931,4037515,2811497,14506346,3045568,14508284,13918921,10593769,4389807,14512284,12731582,8559580,14514007,12099617,12608368,3937926,12880775,14101452,11107197,14487950,11238748,4505301,1875242,11158354,13379862,11217085,4930767,9286176,10538353,4774824,1724228,13607873,14531938,1558119,9521030,4266150,6025929,8261345,13490682,5098711,6126336,4283668,9676649,14543646,12051113,8947209,6182579,11914377,7028557,10727853,13247221,12412395,10176347,8572173,3108401,12864502,9184988,7868634,13294911,3061999,10572817,14530643,14546707,8087775,11120659,6594302,8645002,13191305,12676992,11400815,11826257,14571906,9221587,12511877,11671716,3824354,12623011,2697177,5364300,14576467,4391249,7982080,14578407,10322020,14566383,13124249,14579198,14573838,13354525,5188769,12893314,7820956,14578096,12377587,13574233,7252531,5978264,5178664,13351890,3050287,7841039,5568903,9380247,5779232,4366271,14493643,1375582,11638718,14530714,1428369,6256528,11227198,14449929,10997760,12859833,2702894,6057371,11013462,14407003,12178351,13192150,10341530,12926646,3224114,14614473,14087666,14615255,14616112,13232323,11144933,14604434,14095794,12067233,11431863,14517374,12816625,7750833,12348771,14623748,274579,6330442,10577437,8586863,11519648,977828,14630604,14631875,13371323,5491216,14634406,12782609,2715997,14474307,5225862,13859953,2762570,4770962,12390044,13854758,7314286,14641544,7879270,14435668,1649171,14644061,10826481,14647903,10605544,14639592,5536773,5559413,14646706,14184848,4647198,4501588,9364436,8520863,13514170,14620047,4566544,13904312,13018113,6018032,14107325,14537170,9582126,11985881,12846028,6110448,11435639,295288,13567592,9537627,9988487,14677866,10500226,10413087,10896385,3110296,13112530,14681782,12928297,8574546,10604642,10238136,11138112,1119629,14653792,14256955,2730608,12046040,14668575,14694436,13145008,10989735,9797075,14696354,12716780,6167884,14698633,8512164,9397949,11756621,5127182,448521,6127382,14701485,11110443,13508647,12841844,14702297,9217149,13556215,1772802,199421,8383688,13887387,7274120,11767525,14010518,14691519,14714824,5542737,9107077,10144079,5363774,12354551,14101494,14638396,12947773,14721754,14721812,12977120,14723521,11663493,4755954,9552689,13113012,10782407,14721988,14154498,10503361,3035075,12367433,14734252,14010314,11016389,13640183,5676941,12227878,5252930,14238140,14588104,5770245,12274943,6609197,14749346,14753202,14539264,10010222,10909983,5887985,14756303,13572277,12053744,12475022,11720066,13924142,14757990,14396652,9843330,589921,9661990,4941564,6436977,14721684,14678976,9007799,12854565,10999190,12424356,14024778,2443498,12415695,14770069,14655020,13137606,12244752,14523993,13984607,14772162,14347924,7804589,9958572,458999,13565936,14206506,13664015,2494561,14769402,1961272,14707299,14738636,13861294,13486786,13824518,12814715,8301306,13787931,5248643)
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