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 (6212808,8658701,4046947,9456336,9551617,6911731,8592888,9461974,6719341,10048077,9061561,7729238,8451417,8454718,1713208,2304458,8961842,3147529,7338973,5197034,10075270,776473,9949918,5904272,10072686,10096032,6451244,9951273,3613174,10098160,4739791,1000204,9940646,7372432,9465588,2150412,9559925,10102345,1271037,10087296,5457113,4784969,7818130,2075003,1437248,9825326,2205761,2783473,4189649,10110838,3745505,4110708,7257695,3794110,3619334,8239697,7029309,8367537,1057485,7236696,8667016,8051432,523079,9816921,9659685,534877,3997902,10125224,9127656,5348673,5529197,6671115,4124212,6410719,5568382,10071697,10128684,10101605,3672446,815591,6117422,984795,6374099,1075896,5957172,7901692,9596853,194547,7381996,9781192,1957542,9632610,4045774,10139745,10141718,5637437,2628378,3237438,1035217,9923965,9260725,1593170,6763661,5659781,8551474,5556466,8310388,9475093,2091169,5929460,9796276,4752258,9190672,8508541,10028460,10151012,9683686,1378507,9423239,9815365,6024897,9938732,6112917,4933747,3223037,7875799,10144529,6517513,10156476,8469240,3941679,5072412,3262260,8837440,8156371,10113057,9213509,1150282,7848065,10163048,10125994,10086430,9988519,7647113,10079234,7303809,4382623,10169642,10165786,7236804,3131274,1676018,4714742,2275136,5666063,2799521,8394958,391232,10176315,10178277,10172812,5935343,3303867,10038186,10181036,7806269,6671398,9958640,6583936,7300603,3698577,8382161,10188439,7847044,2406424,10189028,424290,3908256,9807667,4044266,10190951,6115051,1316501,6483029,3451826,1764956,8183516,9645864,6196650,8869860,927370,7943583,1180964,6659095,4104766,10204762,10011302,8282468,7205085,9967780,11545,10147834,7420428,5400895,1078327,2199669,7500440,3904534,10108817,8202606,9159196,9480837,5076225,3294195,7304765,10216879,7908770,10219725,5288867,7033055,8928946,8131691,10225420,7359826,10226237,10155583,8791066,9161205,4449489,10200434,6422069,5770092,10232324,6368340,9786325,5091187,8133108,10232979,5121457,10236708,9815979,10043103,6587755,3046413,3410010,8639595,861164,6422981,8345035,4442204,4541624,1559625,10244166,10244451,5261110,10207478,8160143,3302358,10251899,4168607,7757838,7710077,9343112,2028631,7885206,5381986,405030,1935611,9104493,6135020,5982027,7117516,6315533,3560202,9630752,2602610,9739007,10267282,8273131,7656717,2643094,10259714,7741993,3748061,7850364,10079610,10273668,7458932,10275387,6246425,9741790,5927758,10276693,4729764,7667292,8309574,10282582,10197661,2521225,3303145,10286597,10172959,9849022,6517383,3782589,9845862,10196938,2224583,9322758,10291142,3638394,857747,4132396,8284226,397521,7284164,9172834,8435376,10239815,10292441,10296988,328725,4412610,1256041,1461783,7254247,10101316,2355768,4801400,1434626,6583368,4843897,10304619,8125291,723763,313839,9215210,816116,10307912,10214333,9728331,8363510,8064099,10311255,8525002,7269309,3363978,3456351,15479,9492811,10285469,8729183,5502316,6944547,9024129,4879270,4720149,7254171,196210,8233144,5832680,3263488,10327657,9781768,10305397,1534978,1741975,10006336,5525311,10331827,5225957,10281547,8453556,2433619,314641,3107281,6253214,2275383,3753489,9416734,963798,10337137,6790121,9316382,547231,10341461,3554768,8602367,9968110,1343986,4231500,5377005,9751236,10348464,9249043,9149401,9615644,10344103,3673659,6745973,9449431,3310658,8268963,9936329,236099,3358139,7238738,7176119,10354998,8715880,8956819,9304334,579698,10357683,1075846,4266441,3071728,10244235,4431178,10133982,8896325,10364140,10207228,9943153,8660280,892490,5705943,10338044,3121568,10371443,10372084,10372606,3599813,8062316,6628096,7416649,10373741,6345528,10276884,1097517,7322001,1755083,1228682,6198840,10379137,10381109,3482863,10383607,1001326,2598661,7150493,9693447,263773,8814262,5771029,8289839,4671061,10390808,8404928,6805724,10392407,10347353,9074538,5700008,6397155,8604157,10397099,1681409,5754757,9616255,8524421,5094152,8915315,6729518,5791176,751004,10217723,7096651,4506322,5288405,6348184,8886933,8301146,4850343,3924566,5500589,2658964,930640,3308265,2650277,5268911,5881570,8930751,5505079,10417764,4103997,8751871,9891285,10415072,4652030,7090310,4780863,7253901,411846,5093594,10426863,6511750,3227990,8193848,2947469,10151839,4127482,10430750,9611524,9950270,5401841,4724853,10151648,8395828,5175253,2659549,8684286,4395177,5561637,9489014,9886231,1828788,7682761,5893995,3270350,2099704,10442196,1976993,44232,5340602,10445894,9727040,9283258,5672979,10447016,8793845,10189214,5717640,7781443,9615460,2732174,165658,7496806,10452991,5884437,10375243,1259561,10455285,4129697,9810043,10306318,5218354,4927476,10459591,8856169,6834044,7551692,9185909,9335974,10293352,2591144,10465339,9239287,10466813,9801584,2488942,10469452,4008319,10285727,4791150,6665568,9436598,3264448,4099810,8352888,4087467,5965685,2578509,3378643,6739710,2982739,5529421,10478212,9386575,10415695,3958985,10431629,9333612,4133063,9919407,5305817,1710784,1411723,1023009,3624141,10489486,6039992,9635884,10159411,3208297,6644851,10402892,3055096,8761888,10494296,9705151,5362017,10496115,1180671,10492780,10497953,1594823,5876796,10462460,10499242,283837,9475656,3474385,1128047,495625,9848254,8509499,10310108,10506886,10507414,2648216,10428715,10507725,7847061,10510936,6624800,1954235,10353145,10334464,10513648,8350001,7836976,7715497,2376731,10390214,10445620,10430043,7039422,10437985,8351603,4858276,9101805,5154538,8898639,10075730,9668567,2445065,9611958,1677381,10511316,3733436,5107827,10528097,4790678,9197835,10529342,4884589,10530569,2832960,10530718,7031986,1581390,3758232,4691230,880601,9667949,1090768,9867215,10531241,5828316,2718864,9856270,5484374,9057911,6289878,9629771,6673721,8767839,10537026,9845366,10544060,4451640,8943246,8148250,10545748,9235328,6951419,10494651,1298964,1457756,2413857,10553571,6431780,10411012,8765448,2668182,10558528,10558555,10559131,9109187,6636896,1742574,2624866,5727643,5580841,8482467,10464077,7206831,7458561,9231236,10567179,10567330,9816518,3052305,9371654,8724561,10571228,1061836,5447204,10122561,10218284,10536281,3840147,8574178,10574766,7857104,239582,8349958,8757494,39939,9596380,5589427,6330985,6047114,8885662,9153605,9629307,3486629,2831487,4069751,8916210,6463232,10093744,8792060,10587397,10587433,10589178,5120049,8138749,10591692,9501642,10592740,10593071,8716080,4651471,10397281,2372376,10597146,10555265,7746905,5575238,4572582,5252492,10599773,9477161,400550,10603180,10603287,3516720,7371784,10604069,10604825,10600897,1572469,4883694,10386307,10608305,5441299,10458439,10611322,10448004,8172568,8796357,10615068,5626776,9431573,7995321,10616278,4202031,10619335,10571379,4619193,10280472,2548965,9679818,5394438,7300968,10589809,1470354,7757135,10318021,4072181,9833797,5165530,1851997,8614595,10141391,9566965,10467681,10626606,9557881,3940829,9346259,2104088,7901209,10632137,7853291,8448091,6141147,4832499,1964342,9777794,9879646,5808464,10640986,10641070,3794981,10639468,9710966,7680343,1604099,6226238,10642241,4293446,10526441,2484291,10643520,3363228,10440184,2801669,10645468,9630486,10645899,7786960,10109195,5701704,10518822,9012175,10618020,716296,8120300,1947873,6774444,9003475,81419,3210353,5759380,6754706,5120817,8876034,5143667,6235606,9412374,8176699,5513323,10041170,98967,2499597,10659464,9494363,10660209,7801160,1167918,9827376,1088790,10133187,4996436,3289771,5225745,4801271,10666991,4764604,10359304,10294613,10595783,7943285,10671474,10313665,6261823,10676070,4988651,2566283,1602555,10088084,873443,5916890,6637381,10387008,7214559,6062598,10669066,10516096,3960426,5881396,1797728,3250889,2339405,10688867,8920003,5229124,10689901,10690174,5502056,4789269,5631940,9986899,4614404,703061,1007353,2650254,2787364,6539923,10179957,4228435,10701379,5078576,7887119,1141356,10577588,10703302,10704062,3425890,10704432,5560928,7798124,5354174,10582421,10214220,10708232,8833196,9429907,1260939,6109920,4083636,7762061,5945814,4090483,4272051,10676072,8638743,3752986,10502472,10716952,10716998,3804707,10718474,8340889,5377973,6057092,10325786,515028,4397686,10651374,10723590,1944458,3523579,10039549,10722094,6548980,10726037,4652493,8896653,8386878,10463846,10605502,10730139,7317477,10582056,8796114,4325354,1692060,3392595,10504837,5592463,3367446,6050788,6603725,2389887,5858908,6238961,10217002,7163457,10730928,9636505,8391698,4131849,3438331,3373820,9003419,9291529,10741864,1652503,597384,278638,1122909,8482565,10684382,5609458,10745694,3053953,380331,7275290,2498782,8898682,1035438,7400254,1909969,10627118,6741838,5818923,10748996,9183094,2977262,9409602,10754874,7058823,3586610,6174623,8606035,9831523,10757624,2094187,10578627,10743124,7034458,4920566,10759642,7810784,5856554,10760955,3932803,4966881,10503530,10619856,9645799,6307484,7343721,3192423,7313637,3159792,7483494,5407270,7583612,6546827,10771775,4821074,10725256,1401336,8532501,10659910,9473729,1658069,10455312,4591589,10776457,9673908,10776954,960404,9153000,10288790,2232573,4742074,7046239,612609,10782079,1803908,10752221,9797162,8810963,10785453,10253196,10222293,10695248,7822426,10627863,9905068,1353933,1512491,10789880,5511336,2644424,10771982,2970853,3043202,10782054,10653347,8994025,10386955,1940607,10797563,7981674,10302746,2703151,6650328,10679907,10801664,9044808,10712769,6685541,4756227,9373509,4081949,10725567,10808617,7430588,10810319,1256553,3254859,8364914,10304284,10778777,10424309,10763539,10789574,9736193,8068195,4731250,2685938,3437979,225186,2715948,8170368,10529862,2713447,10820770,8565455,10538841,4499745,10702463,8366805,7624126,2303356,10823379,8852281,5143841,10824772,10803723,10816611,3172879,423318,5185376,66708,6418700,9798217,6866762,5713272,4749225,7409519,9817488,3022574,9204525,10507705,7928119,1434083,9687088,9965369,1334473,10491012,10612823,8351647,10761296,7441160,10072671,10221163,10845802,10766014,6697185,4228196,10823167,10062173,5896312,10800014,10852907,10853139,281617,1269077,10495398,1348124,10856885,3044737,9780666,8167900,10770955,9368760,10232513,6861838,5185646,5441932,10864897,4719432,9478697,5203459,9417937,3231949,4183557,1335996,4464901,10872058,1016428,4424216,4492932,10576039,10704050,10874674,7585554,7291594,10534647,855421,10138396,9569759,7262735,7400533,10735035,9090891,741395,7307241,8229628,10883306,2325010,6444605,10853930,7691324,2259701,10888861,4680977,10590428,2687611,735226,5443758,3540365,7903952,5950790,561698,9159433,261783,4224925,2182401,9232450,9003947,10032060,5006572,7805308,2883547,9942649,1234376,5401567,2023728,1273987,5067053,8323260,7179862,7489270,10905701,3030737,10777115,9744109,4133301,10148715,9659683,972648,10908972,7834854,3622286,3755632,3755786,8549230,10734069,10157448,3738545,6720221,10795024,4909449,9491002,10327739,9175353,10534384,10077673,10922235,5062127,9475322,10667499,8162753,5299417,6381108,476625,10928893,10928772,4818190,8884786,6719703,9073842,10931841,10929764,10663578,10933465,10933071,1488533,2685034,8811242,10869858,10578052,6021420,10359930,9327050,10938666,7659822,10732335,6127225,3543696,7417094,2416647,7114479,10002560,3525723,10863367,3545556,7311722,8977639,5911121,10920136,9617279,5624212,9127891,4556479,2132649,6327663,10775485,10693964,5316867,10953978,3340588,10832457,10721390,1902536,10435666,8292840,4659089,10958638,10644550,8738033,10963418,10394047,4102381,10812981,10591610,9901683,1789369,10969490,10698661,4567523,6051241,3768871,6686446,9915164,2242154,9627640,10272809,2801947,7928333,6320613,6256074,9593015,10696411,10035141,10981228,7278635,8320640,8196226,5051731,2802669,4410536,9685098,3013633,10993065,3768495,4167457,10336284,10050437,4971859,709426,5803049,962190,5695126,4058471,9535642,9558399,5031463,6110621,5355343,10354180,3609394,5659402,11006192,7268109,10514075,8776965,11008168,10114862,11009001,7376796,2210256,1782641,10591515,11014328,9898756,6459056,1739875,3064626,7841415,3631770,7260261,5617580,10871235,11018701,815677,4081971,10848072,11008454,9669005,6622571,8166306,3431327,9016872,9860030,2540313,11026123,8000686,8861099,11028546,2660520,11006962,8191028,850227,7118242,11031595,123387,6739191,5655042,8866021,6896508,10242854,1524522,5012352,3709060,11038920,565244,2196124,11041647,3313162,7697281,11043790,9158605,8091705,3132173,10078427,5611506,5846448,5954825,7487433,10288469,8457833,11013635,6784475,11052197,8863172,11052852,9105286,4173800,10324049,8795104,10686914,3965322,11056935,11060580,58962,5733717,4749742,5275184,8156497,11061614,7708172,361455,10505738,5075502,6549676,468639,10995326,9829108,11027091,6134679,10845343,5822767,8067476,10896780,3380131,7117532,11017789,11075659,2040509,10782947,9643730,9160454,9666953,5554158,8876715,10975510,8164030,1136267,11080165,10889689,4446662,7675023,9538424,1926753,8010396,4395453,5832768,5770484,10486504,10948729,4912515,11089180,5715010,1680271,11091512,10475603,11092741,9990901,5173033,7814935,8359623,3000387,8065972,8002125,3500874,10772851,8749329,9855375,8570392,5381923,10971566,10521232,9431057,7441934,6446850,11098922,6841224,11105701,10766868,7841980,4569045,11107623,7218182,6435921,10005787,10665648,5555782,3317535,5079217,5861873,2950346,5336236,4592959,436560,11120817,6668663,910737,11123751,5238537,11117526,7018054,1483697,8831819,2320942,6695801,5921427,8382826,11006577,9742550,10701430,3756506,1549686,575284,11134606,11134893,1222518,5374333,10878961,1998123,9669397,11137375,3612075,9452253,6210693,9505291,7160479,8478944,8594925,11084330)
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