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)

Korean Language

Q&A for linguists, teachers and students of the Korean language

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 (1563394,7004199,7183244,5763833,4203811,4111270,7245599,7973767,5310423,1481072,4341568,6740497,7946866,4307216,420397,5597102,2183937,5337213,2728074,7979420,7137296,438249,7593544,2831946,6411120,1353819,7977183,2343266,6685452,650148,7946391,7985644,1661323,7986846,5711995,6380592,6912605,7990441,6322400,1926138,7516973,267025,6087847,4730260,1335189,3631538,911646,7994894,1393821,4613757,7996587,7908979,3412058,1485885,7298298,7931724,4833285,5430359,6653735,3905291,5994251,6423360,7610254,8005143,7925414,7803955,7551422,5124117,5853530,3497657,7902972,2076114,1773011,4736556,683104,2346696,6173998,2516595,2420519,3689700,7604826,4993246,3682317,5049318,4045401,5429788,4513163,2183236,5444273,7930717,7580878,6718995,6192694,7961979,3015734,6823029,1298952,8022463,7804714,1019924,843732,7646732,1864033,6381811,1909456,4035478,7596696,5612084,5680504,3738320,6530406,8032364,2951933,8028576,8033700,5739521,6514011,8035737,7173679,8036224,6549773,6395770,6072631,5771470,8013880,7607066,89904,6680077,2762533,3033594,7983832,6503080,6265995,4332810,7163052,2186488,7219907,8047820,7274554,1804896,2416525,8041161,7015667,7021836,1146710,7798449,1487135,7996942,3617120,7783321,7529734,4871476,8055607,4358429,5816638,6690897,1974352,4673764,1385039,7810926,457488,4828049,7028339,5038993,2011037,2747736,4474855,5735184,8067645,5949020,1745616,8069516,8070496,355567,8067256,5629923,7553204,4515030,1542011,8072846,6270838,3837191,3988440,8074842,2823310,4050588,3765899,8010224,7410473,7272130,8042025,5976073,8054161,5490904,8077670,7725924,7945714,506147,7489010,4869028,3718056,2503048,1341809,2796123,8083522,4656916,1176359,3942939,5274567,3160436,1061664,4058996,2795622,5225360,4621127,8090058,2596515,2932300,3243499,2030865,5305030,7594926,5935713,517073,4319784,6490097,5078763,7876863,6525564,7930362,2529482,6660597,5070862,1525495,7977662,7811812,2877016,4135080,7707231,8108499,4987174,8110570,7742066,6225526,7983152,7350842,2710749,967091,6440990,7908278,8103834,5654756,3470987,7016540,7534168,3983449,4746481,3924466,7836268,6732358,2705328,7792863,6054099,5781746,4931698,4723610,3931007,6522112,224087,8129096,7270598,8129213,7159781,4507946,8071511,6595254,5067364,5156525,8133566,2717058,8073309,8102311,2953460,1488118,8137993,2312842,6280252,4246708,8110394,9355762,1005178,5294485,8142135,8142622,4834108,7805392,6312156,8143226,1498822,824846,7981268,6223314,7952618,4137513,6710911,4680681,7496178,2111515,1655229,7060255,3407994,8152060,8152356,442117,6197514,1799528,8155021,4453271,2886545,6067735,1882740,7396657,7203593,8158633,7075114,8159468,1194694,8162313,114306,8062843,4343502,7459305,7601296,6488361,4977669,5202687,8168006,7732666,6420773,6375904,1136015,1994455,2352108,5131222,6728336,1378703,7971438,2103732,7290225,2690800,4726424,8177719,8155546,899530,8011530,3853934,5288560,5001281,8140506,1876040,6743163,556159,7965395,1136236,1313368,7802372,8184628,7385089,8050514,6275041,1647320,8154549,8187656,2099542,2704673,6404711,4415461,6392769,825920,4682733,2345035,2525053,2831913,8200162,8200228,1105727,7914704,8133220,6762241,8202227,6754007,8202663,8163118,8111969,7676292,4129551,6690736,800638,4343354,8177800,5553433,2565527,7978112,5049397,7890338,8144664,8075183,6340192,3782569,5606352,5745601,8213310,5112486,5348895,8205141,8215155,6738160,988027,4459911,2191652,3894376,7503046,2622292,5525739,1691808,5097354,100724,8222953,6180500,6032016,5169272,8226273,8216027,6181961,4421870,4667931,3163618,5704835,8211505,907981,4624725,1277280,8232596,8000953,7588896,7150220,8103391,8235401,6809295,8187562,5944969,3143603,6609930,3712591,163085,8238587,5889307,8238368,8240020,7390197,6714088,8240147,8229016,6533594,8176440,6932383,4358137,4338528,8068602,7189121,7705871,5718141,3915069,6711033,8139068,6744866,4515621,1748198,2562707,2442565,7162121,6126365,7354553,8254191,1554055,4443051,8257057,3901530,1998918,7078555,4954083,1835642,2935352,8233599,3105824,7700140,6687816,7821462,6727423,1812182,7164279,6575991,7278018,5076247,1467434,8018072,8269485,4526762,6082907,143269,6759313,264250,5469686,4689276,7736068,7910743,6548265,7736832,8279325,5937606,8280152,3380371,8106538,7230799,3220206,2272447,658087,6224662,5832034,1466970,7130273,7304592,5923130,3676191,2793397,8287030,5210601,6903018,7104274,6261896,8145760,4100000,7700717,4308117,3685859,843458,6167474,6351733,3424163,7170612,6347891,5617507,8209389,8097336,6818881,8285107,8248342,5348460,7738142,8303154,7062012,8234267,8228077,2984714,433618,7194644,5634605,6000680,7292900,340142,6293351,2914144,5193581,3889150,6737387,973158,2419946,7450894,2996624,1303260,2109956,7378742,6454259,7151483,80002,4781181,5763127,249209,6293658,2434460,7307556,4110826,3429606,5104758,6195759,6063507,7211695,7035799,6647546,7249674,474383,8333332,1379704,3293443,7031694,7512565,4966384,3078039,7256070,2141159,7575536,5718471,793459,2280961,8341181,4914935,1408676,1382211,8267476,6577972,2989913,7612699,8315879,5305949,4450721,1032650,8328790,8334490,8352485,8130238,2398764,2044487,7874193,8357070,2492068,6738563,8096353,1900960,1038940,8363008,949477,4508333,2779909,6127409,8190243,2156800,6531500,6623300,8369295,5181464,5080359,7256050,2333512,1378055,8228850,478380,7009011,2396264,7570181,8219267,635654,8196692,7809774,5776409,8061589,4035243,8378864,2415293,5920524,3080315,827174,8383941,1554346,8385085,4889030,8368346,1798211,3441597,2813975,2396065,505595,1972544,2418835,3065744,3750702,8258925,689527,6790803,4118428,4300886,6296990,8396751,8353866,4954108,8402459,6901943,7016611,4656307,7183250,6937296,3703803,8333062,7726063,6276845,1805129,4390569,7889061,6499253,6934044,5456070,3808217,3094105,1309823,8390958,8380523,5868439,5720602,2043702,8425708,8426128,5143356,6091327,8417383,8338397,8430197,2110769,2946747,7452237,6843732,8416970,4976442,5902223,6089918,2236219,4465789,7221252,8440812,6165671,1614221,2315230,8444045,8430722,7716668,1076426,3361009,2326764,3154088,6248542,5207993,2594194,2772829,8451444,36228,1285459,6793927,3099707,2961244,8450055,7570599,6444775,2075630,8310547,6887732,2501747,3509609,1577037,2127575,7117008,1252889,2379736,1297632,8467615,6000675,6676523,4451284,4980407,8448591,1608941,6817975,6728678,5711248,6828367,2829492,2626865,2296818,237699,4129633,7360172,4551459,3522930,5472537,421719,6456290,4846763,8447262,7686537,8076825,5565253,4016285,1710373,1151472,2758862,8488656,4995155,5893328,7832956,4041564,6380992,8490462,8248474,4058287,8492262,6359611,8484355,1660256,7794375,5453723,1281767,5370518,3151337,8174520,1649372,6220645,8489292,341060,7711632,8126874,4464957,8426627,8419779,2938377,4889267,2559838,4173867,7697142,6816478,4125588,8506337,5630688,6505573,4805944,1814909,8510374,7418193,6400290,2094257,6397318,4895465,4888158,68717,7216259,8495262,8264118,1276110,7812497,5374816,1098616,1078886,3628484,3256727,2480165,8040757,8428399,5207977,4121361,8525282,570206,8257461,8526227,7819621,4637110,8526501,200821,7668467,7378770,5091701,6048928,8531945,8533890,7143262,8533419,5207662,1709903,8136480,1848832,7105441,8459787,8310836,8447978,6686186,6735384,1738879,4650400,7135764,8365780,2755949,4664178,7324619,7699605,1853167,8545755,8073823,8546290,4268323,8223979,6767036,4594973,8548067,8548094,8281188,4576519,4921218,6130605,8274363,6608413,247003,7661706,1039843,6950156,3338710,8552967,6804843,7468626,8446480,7532565,796738,7892059,4381740,6740036,7547250,7110784,4508668,3091003,6709902,648368,3748325,1390414,8086064,8124590,6504337,8520180,8325892,8182578,1092503,8565462,8491593,3007280,7747492,7806275,1785594,7079731,4748140,3602322,8424596,8567309,2159330,5923666,8570183,3851231,7432026,6806349,8567615,1248638,8224341,8237102,5296581,970706,8082194,7659976,4080597,6108045,935769,8578572,3888191,3760132,5328840,8575999,2321308,4859531,6900857,7288629,8071539,7878699,3907762,5380463,7602403,527702,8586569,3323071,8487211,8967612,4359986,8555512,5135171,4477868,6519111,8593507,2266927,8044849,8594976,6484958,8535472,779570,1434589,6793085,8538205,7051030,6637269,1725816,8286982,8596084,3038149,5812238,8550497,7425787,5510588,2687496,6617202,8602192,7820869,7323595,3144020,121861,2191125,2118290,1703471,1526278,4805491,8488883,6580452,789646,5185616,7484495,1483282,6486645,7409249,1211030,8613699,6010099,8278197,8614912,2797999,4723854,4313715,2446144,2610004,8625720,6456392,1111652,5805262,8436168,6233888,1244843,7765045,8187127,5169376,180960,6101835,39905,5446516,3088597,7175612,4612105,7327010,7311307,179634,5645113,4291561,6267293,2470083,7442793,7506882,4859553,7019906,5257286,6742108,6342995,8634051,8653180,7203518,8653780,8040117,1843106,76322,1241715,8157511,8657083,8657883,188081,1760774,7687062,6263317,8662122,7621592,1156628,5570682,5157268,5285339,6566252,4693562,8369042,788252,8667660,7313476,7914588,8558544,2456977,7636856,6179452,1046738,7317068,5801029,7191632,6001417,5151226,8542202,7913246,983783,6548008,4536612,2394602,7118258,105717,8218463,8686114,2372101,7955405,3283848,7216082,7754169,2850467,6436674,8652116,8423016,5754578,5045375,1582471,8465954,8255807,8079118,8665331,350151,5394283,7359285,5946003,8501077,6660468,8703579,6322661,7264567,2966876,8589899,832693,8587802,8651642,1030287,3000680,6204021,1183863,8702511,881810,1631220,6882957,7227308,3476463,7964993,8718248,7464191,6770249,8722203,6933003,5398421,2709168,516676,8610200,7806652,2896235,3740885,7920004,8478742,8687045,4936344,8732103,6188489,8108421,4700244,4208876,4687602,8595552,8736699,7788388,8328871,3767987,7419164,6021604,8739161,5252251,4311248,8742730,8146226,5083843,7915555,5817136,2660039,3813057,1100698,345659,8572011,804409,4460684,4681355,5983976,1284269,8755752,2641038,7199536,8600836,5550261,4474819,1362858,4156082,7537272,6934685,2343884,7835829,7718583,8554106,1111296,4495282,6696657,4826848,6126281,5827326,7047228,2543906,4596240,8435390,8772689,8772735,5708789,8773757,5693225,8039154,8775979,7141655,8680319,8776669,3877872,8754431,7414782,5014099,5823712,7970441,5819227,7353216,8724109,8556577,1057791,8720013,2251837,8775553,3091540,8784723,1465482,8788197,8222795,7410683,4247945,8187240,3184047,8792170,6158177,8662399,8043030,2956424,3827002,2970371,1025391,8554438,7072235,4416191,6798544,8454917,8800006,2913477,3151659,1812187,6433953,4696605,8802554,8803030,949309,7566419,1349691,6563767,8806718,8790339,5025076,8256202,5254055,3631878,1146513,4833773,8780585,1413614,1715306,8002765,6120602,1460166,2619038,7581591,8469857,2663146,6255281,8815555,5861164,4462995,5628571,4886441,8818617,7575837,8356853,7864134,8163593,8815916,3208617,8732775,5455661,3660761,6882968,8814507,8095651,5753527,7140956,1627775,8561005,8497010,6843783,1854748,8829491,6050266,6543779,8831641,8831559,4963583,2354735,3160443,7613404,5258906,8034470,5581574,2341393,6012673,1020154,2323803,7457888,3735683,5936238,8821089,7205620,8550800,8842902,8339203,5848614,6252134,3689209,6249420,8801308,8813978,5777594,1502730,8850164,8512386,5207386,5722062,847721,8831735,1726343,3699442,491527,8858012,4732666,7154516,8825443,7278089,3312620,8862198,6012299,4721370,8237561,8863356,2061927,4508185,7015860,2808682,6217553,3752208,4741979,8833167,4567046,3928796,4751420,3556814,7504603,7675033,8778385,481602,8874763,5611031,2309378,8050800,6934904,996719,8882824,6765415,8886897,5119475,8455615,3565743,8891418,1971806,2764638,7049669,2250874,6951616,8599262,8881141,8896508,732947,6010961,2773445,5928097,8526758,4811651,7030928,8538847,8821415,5822612,5519615,8289853,8584504,4873087,8906145,7581443,7735145,695132,3406483,5729119,4300364,8253889,4971025,8909043,5364565,4648255,8910901,8912382,6155224,1223876,3366520,3870124,2971299,410824,3799552,4552349,7795913,6948040,3513551,7162534,3632007,7860670,1770480,7318341,8536377,6214336,8108125,8925038,7681153,7733632,7414612,7087604,671809,8928239,1999125,3024349,8727474,7488960,8930158,3850730,5553319,8716361,328921,1115237,8914754,8909522,8819662,8933876,4901572,8937584,7027157,7696188,7418968,1168874,798414,2513846,8942075,8942089,8943531,4317675,5671807,2392537,1505033,5340304,6856211,3927738,1087924,8757376,8951211,5015930,8868235,232,7896427,8946735,442512,1337499,8955524,8395913,4845327,65569,8958391,7177269,8555782,8413329,7521901,2978524,1910174,8963487,8572456,5596623,2738249,8649790,7260486,8966972,8967048,8951738,8967672,4281437,7500929,1963917,3581676,8939045,3040845,7535873,7419210,8425437,5758678,8120791,4376760,3129813,2922002,1226316,2584325,8294533,6524447,5403209,1262519,5635683,1729973,8933105,8993469,4465945,5385104,2354957,8997996,8258820,773481,8336911,8500348,9003250,7773147,5736833,8997321,6181350,8501925,8246497,974407,7114793,6896009,4774682,5199258,8964574,8577398,5937230,7929045,8842080,5931576,5986881,3682697,8563526,1171404,9011205,5576348,6088127,8418632,7548245,1943213,1725588,7310555,7476636,9024279,5350456,2565702,8793069,8452544,4484923,3290275,9027155,9027772,7499306,9028098)
GROUP BY 
    u.Id, u.CreationDate, u.Reputation, u.Views
ORDER BY 
    u.CreationDate;

Enter Parameters

Options:
Switch to meta site
loading Hold tight while we fetch your results