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 (897291,8935922,8877836,6283663,7681051,8618595,3829674,6373065,8954691,8940858,5380012,9036097,9036463,1253156,4384490,8916723,5111404,713789,1982870,8754510,8903671,7683365,8240691,6137134,3491360,9042194,9043263,3026283,3990097,8176414,8997373,9007452,7392169,8852979,9045901,3034747,7194059,9020904,9048009,9048122,2510039,2932994,9048693,6540852,9051265,9051693,7292232,8077504,7470699,7270690,8845641,5354059,602210,8794630,5691927,42559,3317264,2204038,3699370,938530,9040784,1238521,3134996,8846010,9063850,9035299,8488207,8916910,5915738,1003113,8326775,5058916,5185466,8753380,6867502,5720209,8614678,1271282,5531829,2873548,9074053,3746247,7490953,6439243,8979133,7281270,6381949,8889651,2081673,9077314,6855606,7154924,8802590,8840464,7153157,1354400,7937216,6818209,6781087,1650697,3643087,4469565,9025541,4655241,6686848,1005022,7927473,8245328,8890692,8223364,6160815,8081304,4977116,6792992,4080514,1269846,3593398,4867929,7813290,5087848,8943868,9091209,1211949,4982786,2508729,9092373,6933148,5184146,9063947,9096319,7729800,3956731,6795572,9098807,1800623,1941002,9099358,6018581,1310825,8881805,3221407,7840701,8580749,1678661,3072490,470119,5253279,7501979,3183950,8571515,5743017,3578468,9090981,5231990,3929525,7131854,6328916,8947909,8296766,8612119,14657950,7812289,7826170,9113297,9104529,9041347,5318303,5734834,9116705,8603883,9099342,8593075,5214654,7337732,8943353,8773110,5155575,4795235,3356266,7875487,6307262,1377711,5407910,9127837,2084503,173150,8985810,8356905,3464250,2605772,6941787,7705226,7872811,7785984,1664330,9134238,7491328,7362422,5805675,8674819,9135520,7277818,4910008,3757265,3712516,731116,6807980,5472335,6822295,9131785,6157456,8986622,2404470,6726126,7687663,2760533,9140973,6813523,834035,2111737,2069660,7412111,1754790,2082461,8640353,5178406,7732200,4195836,5108411,6253579,5750238,5581562,4077004,8994323,5377805,7798352,8591671,9161643,2869208,2652530,2761038,9149625,7761105,4522548,1751640,8981756,3147789,765544,8855650,7769056,5407287,2790801,6899325,8742098,7792292,7733755,6625021,9173677,2676533,8940558,9145973,8607738,3070819,3343339,8923949,8553068,1015648,9181273,7731946,5464592,7396208,4650140,3236541,8167884,9161460,4812947,9185529,2950509,177516,465053,7772328,6354405,9187963,7426873,5203652,8250066,1880012,2910704,2389992,8924266,8019439,8806259,7619605,6279704,4582484,6643357,9199057,4202426,9200446,3139096,8229169,9200873,9201372,8731334,7006955,2665385,3041525,9205799,654,2982246,5662485,7229011,5413214,1680398,3982281,3417742,8464381,3293881,85371,7852453,777733,5940644,1233004,8806947,5987525,7653268,7401208,9213715,3478780,4063240,8614401,9119262,3272238,2155425,5555016,1355634,6582127,6089978,9216483,6754946,891699,8423084,5065047,3936495,1523648,7102925,3119384,6366642,4268324,4623563,9226601,8934877,5150303,2439770,7582019,9229614,2999946,6027379,9231003,1113921,6020701,8762915,6946652,9191034,3316224,8321574,3244464,9236138,6441965,8758316,7849541,9239715,7733100,504807,8921005,8534521,8992384,4298924,7920740,6923127,2106769,4215636,9248404,9214076,7282392,4534873,1695537,9250808,1919254,1876047,7246268,7762015,5206464,7800222,8687597,8908318,3121362,3152546,9261138,6301176,4965543,9263621,9263992,9146016,9262994,8177461,2307200,8919133,8322297,8212053,1493868,7404996,5191552,505152,9262529,476791,3343378,5685250,7932590,8694475,4303098,8845060,9278309,8864379,9273873,9281153,7254514,9106037,5691066,7419630,6792694,8203926,1294921,1054324,3143670,604836,8481064,9286963,7734318,8243479,3366718,8848555,6104077,6817087,9286380,5494969,9211144,5228128,8010633,9298795,2460504,1150683,7912578,5563237,6154905,4244653,9240988,6476709,7571111,5230528,5349476,9305054,8521084,8792248,3122885,9277861,8692741,8045153,7877140,6710843,2254402,5598574,4469946,9185253,8327037,6346698,1485877,3455638,2338150,1918741,8844539,9316824,8078237,7052518,1866775,9318746,8822230,1219322,8927499,9323485,5056266,3767132,6920418,16058158,8568787,9326746,9102877,8759342,7032246,9328602,3329183,1386930,9330083,9330252,6744877,9132710,5945712,9330877,5150335,4442557,8823391,9333688,7862166,8143761,3280699,6508528,9337133,4532781,5800213,4545330,5884953,6599846,9340053,8890805,9342167,8365043,8121375,1631106,9159198,7175074,4677874,8570735,6772091,5646101,9345414,6459948,9176546,5383521,2940357,8334221,7082849,51604,4003082,8605976,9334376,2248987,8383876,8147515,9355870,5500643,6351303,6366203,5517847,1257468,5874418,1532587,6232849,9361465,6500611,165103,5157887,8307815,1137624,7347887,9206625,4575505,2945357,6794075,9372961,9024785,6307462,9180796,7458436,5889425,8679557,2706419,9364846,2080074,7374199,9158934,3322254,1244509,9291734,4989926,9379600,8716580,812139,4306649,5104004,9037005,8314639,7398819,9276996,5079316,911391,9183341,9376174,7059087,8647736,7977841,1469747,7565203,4967460,9388971,6568836,1471314,8789422,4558133,2773308,5458883,438223,9059929,207661,1178572,6834956,7415908,5270171,7274191,980515,8108752,4313071,4822032,9336367,9230296,5273580,5504356,6774689,3670403,4811307,8252081,2080581,1398545,7830152,9397718,3158028,9410721,9411306,3562088,1851717,1830725,5454660,5458090,9161260,9415489,1477869,6598754,3357395,4972352,3719592,9362561,1130231,6254943,9368704,8862155,9418842,6132416,1296450,3554147,6346623,5111394,2666270,8736716,5183807,7064415,9426694,6780382,3681880,1447953,6611148,4247897,1031531,7847611,6822876,4944292,5245903,5946129,8470380,2996961,8083465,7569869,5655174,4420934,9440589,9441704,7587471,4362799,9261599,7195486,8644049,4778263,8076767,9178974,2513382,7586785,6226370,6813832,9447419,7349995,5669167,9448250,8260677,9449269,3184532,4655475,1757436,7949709,9118457,5722291,2508423,6701496,1789684,6665117,9411858,3711219,9345096,9452598,4791838,9408379,4980062,6605897,5015812,5397364,7671049,5751930,8919148,5483920,9460459,8835035,9010942,5495780,7944346,8389829,4716255,3810748,4541593,6266582,9472066,5587552,8813732,8266317,2297135,7291209,9392372,8889530,9475915,1296119,1592312,4171594,9347645,3571997,9479376,9479957,4015143,7602712,437393,8330894,9487267,3169603,4093132,5894620,4007801,3668343,2162550,4936749,3375731,1602606,9494704,1100221,9496465,9349399,7171976,7709350,6130093,3629330,9501344,1682392,5553979,1460934,9503388,7856183,5273439,9386939,9506708,8721534,5138179,5011551,1045399,5556905,6152623,3244010,9487451,4056736,6336881,3707564,9515918,9467648,1429097,9364179,9517878,5605637,7428659,9040938,1961053,8708819,6671647,8613485,9453432,9523910,6036437,2001654,7366448,9526113,9526448,7805708,138601,1583803,5460020,6129842,8576408,5994679,9178490,9530862,2805482,5712141,9472057,4287899,988975,9534393,9534998,2152513,9537693,9168500,1060990,8543849,9356400,8154091,9514219,7490185,4918319,8004651,415763,1091567,4960410,9544622,6072994,2382272,5061485,4812335,8068739,2555668,125997,3425529,7984677,8635733,7986768,4920394,9549396,9196131,8916412,8867495,8331756,5334104,522858,8339273,9350234,8838741,9274726,1079430,6776973,9374124,22046,9558000,9558634,108796,8848363,7017670,4275911,6481320,5705462,9473299,4006938,1408347,9562766,7497038,6084245,4252339,3319590,9333236,420217,3256552,7558566,8885221,4908900,2948915,5741224,8958611,7592742,5221614,6795764,5699915,8584239,9431928,5052406,4767708,6721397,6867799,9399408,9431535,5631446,8327557,9457808,9503183,8479734,9579496,1011766,1310368,9273414,5677706,1226378,9583831,9586276,9248562,6278217,554903,3368037,8983881,4735848,9587400,9570803,9587429,1822974,2842999,5641144,9593580,2627018,7489488,2969402,6821294,8510519,9602027,5420542,9419231,9552584,9602107,9588495,9605421,5709876,9607000,2620818,8005315,4413257,9615482,8399525,9460057,3209505,8959415,9617806,712347,3734914,3411656,3083321,880837,7072734,6695807,4705055,4980452,6150800,9197140,9078447,9623235,9502177,9297093,9625345,8822312,2994559,6692112,9628062,9361679,7316632,6255552,4776799,2148573,9632170,3178888,1205340,9634438,5088712,5483457,9212328,5589960,3152377,2763557,9637708,3788615,6138345,4331126,5244513,9615506,1586200,7825380,6374770,9645327,8377771,9632991,9650056,7150641,1611045,2178599,9652241,8380906,7708887,6387860,9479805,8595091,5987698,8408902,9511218,9655667,3348651,5622743,8248194,596841,9658472,9658565,9268772,880783,1951298,9662018,8364334,4826537,2646505,9664862,4724915,3977013,8798750,8385666,6317692,3069962,7135730,2132672,6676972,251555,138078,9386598,4615170,7220831,8193907,211668,9281269,9674220,8082093,9603984,7878624,8270929,9489150,6778220,9677569,7836945,5318121,7549907,3624086,8138111,3800106,9620849,4263161,8727709,9257205,9167609,9661302,9617513,9515299,9098421,259463,6292421,9687467,3425640,994658,1607871,9672351,7836005,4746300,6291285,9145773,7798690,9694511,9695520,4836726,5181631,9502161,1958391,9698607,9698601,2065041,6671176,9700866,9367013,7646621,9684145,5263026,5580011,9450060,3287204,6923232,6444608,9705545,2588390,9649301,3493194,8825868,3902762,3651221,5729613,7475703,9707115,5853613,2765185,1742927,9629245,5465732,7088096,9660447,5917759,6027453,6568911,9358790,9682087,9390003,7911774,8625512,3625770,5642456,9614924,1721444,5728614,9719292,7704420,6754514,9618423,9718277,9720307,6292495,115652,4556546,5487053,8145200,9512475,1682564,6700176,9488149,9724520,3112131,3426308,5490719,9393450,5589589,2493773,9005749,6208280,7058336,8734075,9622584,4264876,7544074,4192833,4723317,8069314,6819878,9737073,2501585,3609252,8690675,8858555,9287587,6303907,8993253,9145465,1139541,7990220,3462587,6818017,9486303,8796280,9744436,8837591,8635336,7348815,9403283,9746270,7339376,5003890,8273252,7330929,8921396,9747915,9748830,4936696,6551619,7117482,7664765,9749938,9374263,9737142,2144732,4511292,2102840,1177848,8091868,6014098,5314134,9167389,8211070,7805312,6231885,7421304,6248923,7513702,9763164,9762936,6292227,7275319,6906600,7584394,2593878,5921902,6407393,7231796,7484766,6812000,9772561,8805901,9777068,6701921,2142740,2043377,7004095,9751545,9687611,9047805,1465553,8445738,9783993,9438699,9670510,9606335,2151275,7106794,4605035,4350527,5688247,4780940,258483,9797094,9796344,2791802,6198354,4708077,5066026,7511382,9804072,3563910,5707440,9805851,5644388,3892765,9809996,3855069,9811171,596590,3111264,3625865,4859672,5513336,5361479,487771,8455035,9816032,9816734,7958330,7541374,7765114,261083,6399544,7964970,5666573,9808507,8374919,9772189,8166821,7478109,9823280,6674192,988283,3729443,3929948,5843297,9824843,9816683,5233594,2982277,9790945,1181250,7215186,8060680,9213958,9041811,3726902,3468055,9806717,585806,9466929,8873492,7001540,3813210,9443836,9841150,4781385,319020,9831869,9842402,9843303,9371161,9548133,9662832,8048332,3297525,9841142,4636721,2922515,9603886,7343160,7328282,209591,4613431,9854132,106020,5762090,5005049,9794321,7927745,9860019,1408611,6555213,5340056,6155632,9035885,9864580,1684118,9060223,7366420,9758569,9636247,3233388,8527205,9871094,9870292,4417867,3434649,8530384,9875589,9578446,2257805,8612472,6378119,8022141,9038235,9220670,5182593,1607941,9324145,4348638,8112841,4180761,9105638,2724940,9101466,9707135,1622475,9730338,7621964,9276941,9253651,9818766,9724820,4284090,9490858,8510716,8997845,3292295,6470393,9741278,5898523,9703844,9905125,6531041,674330,8624926,9903440,9907747,1621127,8822462,9904632,4776733,9911360,8062151,8272389,9584463,9811353,2296540,9915896,483281,9702839,7648881,9917470,7676534,9381966,7770967,9808098,4976790,9753452,7351393,8886692,2108462,1560126,5037646,8341113,9923682,9012296,9752087,7947338,5124723,4398851,9925904,9928872,9336642,9931585,5413581,2008828,2648551,2987488,9937194,9754868,7920332,9939603,2256459,1235291,8569428,6295272,9942522,9748333,20922798,985897,8418903,8253192,9812919,9146530,8710969,6421664,7722020,9246264,8290926,5198349,9813086,8550156,1609570,5583132,1096499,9955121,9952817,9827006,3616601,7943463,1650630,958916,4761773,9961029,2046529,4779808,1977734,1631306,7177029,7762652,3160253,7090133,9967571,4229159,9894993,2450639,4414869,9972009,6024060,6370393,4237198,9949539,6396592,7655642,1567269,8146556,9830598,7603876,3213216,9384462,6885843,8908987,7982251,9200197,4378853,7906368,9095587,6604505,3914860,9986513,887092,9595498,3168356,9853844,3870437,197310,463939,4620099,2992172,4871483,6837128,9611310,8085403,5298252,9537219,2403973,1527470,6854964,1597059,6725114,6431554,6562989,9464703,8409309,2867061,5587393,8394098,2037826,6394069,8519061,6799705,7812818,5650995,3115917,4463352,9882294,8112072,6882658,1299879,6494614,1106247,1369888,1477745,8453755,6526826,7806207,896567,9474685,5854364,5737650,2057851,9641668,9471817,6560462,519305,8515693,9785426,10025465,10010342,2031870,1155216,5510581,4850111,10042881,6933491,6431282,2311119,6248190,5774055,5420059,7015497,8027241,9838465,8459200,9018810,972014,10050342,4812174,8564690,3623123,10054841,3830495,2672273,8343359,10026403,9569062,9965052,10062770,9526787,5765675,10065166,5862538,2990344,6777901,2329644,6792577,7607408,10066366,2398479,4107481,5235279,4488165,9307869,5322365,8563383,73332,7805433,9346339)
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