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 (12173333,12285746,3001431,12221304,3124206,12246656,903600,12277036,12288106,11437291,3539592,2576252,12317272,7011542,12305670,4636569,8948867,11627882,3251122,3158683,7433733,12310129,67839,1472474,9864119,10011120,12328109,12018720,10187214,12309469,3875378,10631916,9816472,3848742,11622065,12036788,12334283,8875189,9690045,5860619,7655408,10320838,12245981,4692102,10660059,11276886,2580443,9066242,10505537,7438973,3778155,1538798,11755414,10535200,11439083,7446753,12333011,12114970,10560583,1230358,8128238,12347468,12298410,10386804,6438081,2525486,11852130,10309040,11634099,12359415,11852195,3571032,11118570,11443337,12363019,6842249,5307432,12183754,11866551,6771152,4262344,7619991,12369698,12094826,11482414,8217180,12210741,12367136,4879688,11076190,12196394,262403,12375842,5091972,11722729,9364954,5092690,11209256,9782871,12379518,5949383,12380273,2952545,1660655,4962535,4758719,1130975,12384194,1123743,12386602,3521261,12387907,12122745,3533902,5306400,12326345,2257064,11268243,9132113,8266189,10226440,10836504,10720982,4622763,12394750,10441038,12394475,12110114,2174630,11037922,12394009,11649973,12220462,1112154,11038454,7507772,11148516,10653163,7873001,11621998,1934810,4632960,4121413,11960505,9171514,12254103,12404524,11656350,9829812,12343944,11857228,12380974,11708656,680151,5326218,2800318,3108946,8244729,2386432,217867,1569279,8668742,12409185,7339840,12392748,892251,11016859,10666695,10523455,10420740,11989361,1655655,9133297,348672,1847482,12416472,5186165,3610386,7607728,12418380,3999260,9666601,11928053,3052750,12422724,12283022,9717799,12424308,1171987,8771502,5228864,3289949,8365607,11366265,6481306,11939485,7189173,6220486,4271233,5406591,4435175,9540293,1985071,12433410,12436665,12436948,10303589,12411624,12138409,12439905,6276393,5498983,11000296,5853799,7759514,1618041,12017078,6873446,3331456,8385761,12447105,10193687,5438236,5727930,12448592,6583140,4770829,8979714,12237990,12428755,2363712,8155097,4510869,12239920,9959935,506553,8480342,3621637,11935837,12456685,12169155,11402934,10101609,5922255,5116730,12456387,1505899,12458836,10627395,11446534,5256092,6196890,12462217,3370473,12127295,12160374,10506176,12265509,12464547,9985225,12465092,389823,10156846,12467440,8251733,11521129,4802104,9762275,10391953,10366303,12144532,12471104,11893659,3249293,7669698,11276403,5125876,12479264,8283359,2683248,11628687,12451887,6680585,10730273,6423778,3776749,11235141,3103548,12486968,12482767,10891325,12048377,11602063,12192313,1702972,11792293,12491569,11903852,9057412,4494505,2774885,12493812,5573241,12486685,11937320,6224975,12496800,11955142,7196361,11474902,9036593,11558934,12499701,1358889,12356107,9512830,12299863,5959374,128618,8139899,12460611,12507337,2411648,8196559,12509296,5821591,3198631,12258312,8588743,10665444,7108375,11872828,8657837,8905028,10993502,11742677,1577224,8181609,7230293,6611263,9558050,9052389,9593181,5565575,12515384,7967140,9232501,2006734,5619301,8701063,11601099,10785236,3053778,9414470,10699369,12532648,2023321,12533499,7718608,11678213,11940164,679733,11327875,12456570,12502093,4520323,6553042,9602831,7296983,8335451,12145311,12541961,12542383,5956254,12543568,5032941,12162606,1558604,10377244,3623402,2894641,12462515,4326007,12121172,12554850,5646611,9455299,3846106,11299516,10067128,8782268,12426631,12531208,10409942,3395831,12383105,12566791,12398549,12163761,6718586,9811508,11413743,6022481,7927921,12090782,8507394,12493326,9870489,1659758,12232038,12582441,7357322,8388315,5353241,11250614,10557703,9679359,11991898,7571861,11354523,8521515,11011184,7905035,10248920,7039672,12596120,6787754,10376811,5887073,12560106,6135682,6211529,7730917,12609846,4941356,11614806,10188420,1320437,4428778,11312371,3665766,4725172,12132980,11898515,6437335,11206334,10543735,5077188,5124717,12627430,12628209,12248624,399946,10883038,12632307,7672539,8167814,11231342,4891249,1511249,4439794,12641160,11370114,12530125,6929343,12644091,12644263,10882187,3721017,12591656,11326002,1891374,12648308,9027428,2049312,12532499,12653234,10349610,12202485,2396866,9900254,12657572,12657692,12467457,4961888,10048442,12645183,11704001,3136401,6191539,10694643,12662699,12501670,4317729,11758609,12665271,11695230,8859296,2830703,8064556,10074544,849833,12381592,12673824,5475518,5096369,11984931,12520904,7291737,10764849,5333612,11758131,305883,1494488,12036145,12673656,12687967,12688367,12373992,3732445,12694484,12694701,10642003,12693762,4226123,11309292,11734769,10325089,11688559,12096480,7808537,524111,4661692,12704630,12027408,11973019,2336124,12169661,6326558,12593111,6035575,10277596,12715488,3693715,12337331,12251738,10975456,7982323,1485251,11509775,11131164,12721387,9987814,12721594,12721677,11971761,12725036,9988003,12660254,12727848,6523193,9694371,10251458,4727359,7105057,12735346,12458141,1672429,5022552,6562021,7715504,12737752,7711287,5319267,466932,4992594,11347273,11982168,12358252,4987960,12185852,3503111,12524109,9637925,12697138,8114199,10150308,9231406,12747618,11260467,7086570,8966358,6316512,5240905,12732123,1312785,12762156,12467689,11063681,12764000,4526664,9665629,10718146,12275901,4287934,12536139,12771415,10388002,12344362,12549159,1953384,9539058,12776009,2849323,6357471,11755559,12780922,12781059,5291224,10959355,11084151,3520484,2680024,898042,894067,3084450,12781902,12575309,6087112,5219209,12686717,12492107,11256628,12795780,6333701,12667081,9885747,12800441,12743899,10618689,12312210,10172032,3430103,8575607,10534048,12810457,1047814,4060922,11382629,4858777,9953923,10355068,10677291,5900001,2100558,9361646,12822139,12810156,11047692,9985393,7490857,11969776,3443033,10016429,9485765,11656070,8161309,2382483,9650720,4655668,10019073,12152736,12827804,12833179,12834211,11824610,10901109,286641,11229655,7664907,10786153,5757418,3577922,5799067,9849440,11978180,9315696,7631614,7359113,7585017,12846962,9905201,12847565,5013760,11827156,11750336,10640063,5426380,11901676,8910983,1695486,4962240,1601703,12854151,12126595,9764516,3167642,631328,11642908,4136445,1716410,3177661,11717448,8108136,4898951,11848241,6526600,1911722,12065665,8065938,12020205,12098385,12087854,11524387,8534570,3700538,12836588,10213672,12869046,8622500,1008340,4847170,8919022,6016731,2444937,12872199,4245870,2783312,3472173,12619406,11820554,5980993,12877379,11391975,8406780,7647440,6252210,12883744,10711406,12885050,12769041,11601360,1549733,12889436,9139733,6809912,11675063,12639628,11272449,502399,10394201,12783691,12722698,10922987,1661640,8404482,12899107,12888069,8662721,12502268,4950448,10703899,12141285,5480700,12724185,12908262,12881147,12150256,5507389,12302939,12912062,5472354,3927651,629034,4555292,10077371,5597043,7432567,12831186,12406242,2519395,12341999,7903243,9229590,11688237,11858543,5179376,12225204,12661178,1993416,12101341,12922005,12832444,12113065,6427763,12805611,4530605,12744612,11969451,4781936,12152181,1396787,11518879,12935125,12935405,12935422,1404458,477476,12938101,2251138,684646,8867190,254837,12093042,4002034,10024078,10641420,12765893,12944549,12874038,11025985,12385251,12888991,11782278,12391812,6459731,5793987,12119589,4627219,12950642,4746007,8558832,9807965,9278672,3517622,11304142,11291825,6633959,3404966,11673436,12950680,12937859,8789692,4622075,12760080,10878569,10704450,11577284,10393067,6275216,12054590,8430155,12962823,4258041,9147090,12966424,5894542,11777548,258894,1403546,12881517,10311645,8295671,4180984,12453782,7905198,4292687,2172547,9409403,3410940,2830167,11316568,10652740,7169251,12986059,9018924,12987337,12891149,12815840,12499147,11830858,12502880,12827157,6687699,12990377,9137234,10277523,2379327,10342778,12821253,2023370,9362448,2271421,5759359,12998185,7951203,12998880,10528354,12641260,9033810,9099959,5458827,13007974,13008092,11811264,12193632,5426154,8496110,10918304,11846602,12086742,12597626,6509751,8437546,3056525,10503074,1617210,11105288,3424575,13021152,7191927,10039065,6800087,6124330,6700329,11470365,5448398,13002616,8333806,2739654,8211909,11657959,13029495,12447766,12392547,11975743,9863397,13041886,12688824,4337253,1023470,12179345,7001356,6095728,12847896,3982755,13039535,12372520,7492292,7181841,12743648,6787112,13058054,3089485,12264474,10243797,4156180,10156184,7624179,7661750,10532707,6419774,12778250,8738512,5606049,11824295,12309514,13063856,1657010,7356109,10211323,9350862,11322025,9944838,6656299,8511957,10936672,184883,13067619,13067841,10234240,7380863,11190370,13073093,11354812,12133815,1769197,2244411,4601111,12455686,985012,4788635,6755811,13078963,2089371,10351789,4958401,12262264,7153354,5048273,13083170,11452017,13078196,8237230,13084191,13085265,10007998,6029452,6649111,7598582,13090434,12944168,4588456,12778634,13091702,12608776,12684059,13095842,13096076,12970557,12212051,10509253,12440348,3717898,9406722,10692384,9829081,12947171,12092082,9070242,11357530,7781699,13093266,8707422,5691573,11637415,3673329,13106597,11490471,12526514,13106199,2136205,12770540,12304314,13075002,12497953,12976597,13114757,13114729,13115100,9500955,1728830,12703400,8593015,11321317,2495619,11708747,8448764,12590394,9178470,11632370,7949181,13116539,12272450,10186142,7631250,13106010,13091714,3734640,10260243,13136905,8862989,13102422,13009365,12941125,8033003,8291684,12735330,275088,11980301,3662591,13142340,12313387,13140683,7554826,9898037,9392531,6533037,12552198,6560773,11716607,12918011,13112389,13149737,8036670,4889741,5350343,12961736,13155610,3475758,13122448,3952424,11934574,13100745,8760155,10407404,13165456,9634341,13153995,6567467,13171828,12847649,13163412,9952852,13037510,12224610,10653449,1389556,6738917,9366954,6772739,8181646,12596732,13191050,10531223,12724891,6405924,13197535,12000791,10314412,80907,5269447,7582497,12593074,13204088,13208301,13212741,3358251,13211988,12954896,8166827,11423076,12613004,11202474,9641417,13214845,1531280,5149764,9812084,12809566,13024483,5652146,13223348,3764647,12826055,13117594,440237,9505546,8046027,13237612,13237941,7671671,10110042,8667472,9169757,13244341,12574273,13150048,6085710,11291339,12210908,10344472,5268612,14703970,10105120,13242412,10437431,12358265,13254592,12747496,13144904,13172077,142605,5328200,12904808,13262352,9282289,5259779,12207206,11826078,12107295,2212059,13251422,9715289,11154358,13244539,13272762,13273504,12968527,1975277,13009027,8807512,6105802,3343503,13280319,2572526,9626155,13280771,7267525,10364893,13237397,13283749,9154627,10487404,11815400,8179614,9127522,9879525,11035194,7043782,13290050,2650023,12372001,7101138,2568013,6205379,13134795,1710235,11643622,11074646,12908619,11430297,9875865,13210249,11789713,2913203,13309793,13310999,11483632,5016028,5770501,13315681,13316222,12787936,11702644,518649,13320166,13318205,1448195,13321816,3735245,6222531,13298867,13239947,1597963,9220990,11747623,10285214,10591078,7346398,13333833,9153743,457309,13252938,6217748,13334046,6837288,909535,9572989,10150357,7311903,13343847,12811890,8990232,5042715,6371869,13347143,13348358,2029836,13220573,12603256,10220850,13353331,13354246,11721896,5719266,4064505,11257189,10845665,13361558,1025222,11612096,1783165,8151420,11047815,5464309,2209468,7527829,12594911,3203199,9281012,13375508,11312057,1623801,6023493,9184907,12560073,1672565,8967324,13387224,10497999,12468760,1067003,13346108,5235191,12600582,4590824,8015471,10540017,592641,12640622,12473000,8341525,1317809,13400244,7098058,13015830,11072731,12936536,9335443,13402484,12552003,2287617,12872315,6693221,13406081,7242989,13330674,13408445,13247822,1842548,9766795,11560591,13147476,12719402,10089406,6165395,13412683,12093087,10617591,13300603,6176277,10912170,8746937,79485,13416402,10437436,1315357,13417739,13419829,5524648,10525284,4970632,12912861,8778289,10427568,2487602,12724052,12548599,13112956,11666502,10336665,3161139,2016831,2630030,13433027,13433872,12165178,13435006,6792338,10435409,12941578,6311669,13398293,13426859,13098205,12435045,8036402,3037960,10969631,7281855,1053408,10873591,6524600,6535588,7634682,12224028,4961393,3106424,9887701,13450471,1885535,8125224,5123472,13098185,7055636,11529411,1987319,7810912,5913518,13450253,5994073,6636691,11060940,7247695,13460128,10174039,11555863,12051063,4344930,9597089,7382260,10871748,13465718,7322371,13467153,12804351,7157877,12385615,343721,12825265,11466504,2813263,5327233,10435027,10251345,12278291,8714633,13477334,12347098,2983568,12757185,6225398,9497201,13480237,1201614,9404560,13151405,11098119,9568126,12633514,9108912,5208690,11704896,13471272,13488263,10472512,12296916,11302234,13493264,2345890,11974805,10342888,13499435,12839742,10767572,10255033,11454127,11417810,13504746,8534089,5098972,13031686,3927415,11022042,13506590,12658095,13174465,13146249,13490404,10823194,13123162,12438360,7170108,9943329,4796735,13508437,11836751,4295352,13282396,59137,12209165,13077166,10162005,13519959,12700915,1274440,13522839,13523627,11038952,13526375,13398398,10351382,13527728,13009907,13508080,1536240,7094748,1935758,455062,12686179,718459,11999957,12934547,10973889,10425135,880875,6158463,7015657,13526245,10301715,5209133,13216594,13545049,6896392,385907,12459158,9460468,13546104,7564809,12367596,12201957,13553608,6406732,13554795,12541041,13555444,13527803,4305004,2455162,1732769,10669664,3955122,7037339,4167125,595305,9210690,2115947,9053555,7962619,13568746,9173638,3360601,13570116,13571262,13571509,4907950,13292418,13397579,5243272,8303055,13577503,12246799,13579844,11632986,10353696,13579488,10797504,12265610,13584457,4371033,13000823,11240676,13588195,13223261,8007116,13429448,11678472,13447872,10503976,5868628,8755789,9915931,3204212,9140652,11003806,9712336,10936641,10630304,9208140,7287543,10916954,10005931,7153937,13407095,13244417,10871325,6781086,13458888,11883857,13602960,12765443,13364316,8678399,12587505,13605870,12698762,13608513,12988699)
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