0

Please login or register to vote for this query.

(click on this box to dismiss)

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 (6206039,5948697,2900738,1860030,1342402,905791,5878196,62361,5928371,4202134,737625,2288422,5577564,5115818,6115510,6180587,4817828,1965436,3337129,5883971,4158375,1915274,5549107,5681020,2450382,6213117,5767600,5455902,3492120,1828637,6216266,5991625,6206106,6216991,278275,4302676,5683484,5216445,3610381,4071435,4551832,3294894,4051219,6222540,1140096,4865498,3651664,1423536,2093880,2997109,2128168,744406,1350852,6073746,6229814,6229902,4969588,718264,844267,1046657,2132167,4421872,6178834,6208900,1107377,5030537,5903934,3787777,1999025,6235841,3990607,4302514,5502471,5873900,6031367,5387515,6149402,2217749,6242514,866262,6184710,2075215,3083031,1562599,5451105,1855801,5893560,6085968,5941868,6179448,1849674,4486167,4159566,6197324,5970267,447023,6249337,4040020,5624879,6134744,5743976,1871717,5214618,4092615,5771655,2754623,866631,2535630,5893834,4920027,4350573,2987285,395028,675632,6168841,2682200,1682761,4064010,6143480,3854476,4674270,6263999,2350459,3758556,613960,3258545,5633356,2814057,5839090,3605689,5194977,5159029,1936325,6100438,6156928,6272636,6273020,2050637,5884503,5699447,4663249,6273314,2629402,5045212,2623004,6274519,3590700,6275089,1716869,2945276,5356726,6089494,4040998,3902763,5356946,6268892,5741664,1451346,2909303,5628213,3591470,1059328,3558819,3716478,6265160,4018201,2301065,6285880,955823,4509263,6275167,6289193,6289970,6291038,3777958,1460448,5948280,4670625,5204349,1335161,4552085,3986708,5007273,4457024,1432114,6295651,6296332,5752030,6049028,1149566,2252182,1360276,5976827,421121,1923100,6298662,4753132,3900373,4112136,6241663,1663898,2643007,6301898,6004936,5183439,1048781,6174552,1731179,1453536,6305143,3337688,2601483,6306021,3102952,4677126,6092804,1040402,434551,6250837,1168820,5708022,2174726,1105858,6310834,2824115,6110129,5875389,1460985,3133837,6312207,1107100,3403621,2052750,5540504,6166748,1461309,5896179,4437954,1833723,4745409,543572,1549647,388520,2856416,462047,3553077,2362377,2419274,3629229,3982327,3766751,2736367,3811602,5572712,93191,3169872,917467,5990717,851699,1291637,6150378,5885795,5748797,6144802,895659,6332613,6332563,6179818,81511,3592564,4057790,5618708,6335454,5257239,6335190,5552503,6336375,4221970,4596616,2819871,3670132,401025,6338771,4818853,5041408,5700061,5959512,6340329,4885801,3072896,3215799,1551801,1185474,4210662,383264,5806699,5654919,6347918,5437827,5191826,5590381,6349474,342947,6310851,4941547,3826468,1021675,4600847,5587716,538706,566307,4066038,4980088,17234,6240872,5241718,1251950,4612750,4450986,1669370,6356271,1845974,5525271,6356678,5304702,754161,4577809,5477126,4576977,2275956,287436,3590067,5664775,5905790,4340611,3060707,6345958,2650879,482601,2626000,6363013,3323231,6335101,3922976,3940470,6286298,6265623,5943956,6369074,5528810,6022281,2255799,6101992,3346095,1305699,4466895,6352535,6035548,1075062,3016483,6337613,3639557,6027299,2900872,6380392,5400814,4431509,6330562,5161414,1064572,6218072,6318208,4677551,2302651,6330419,6379884,4917859,4928269,1613383,4815264,6377045,6387618,2056344,2935870,5626119,3788810,6257424,2826871,6381262,6193125,6279389,3951920,1163640,1892348,5502785,6242642,6373548,4808110,5429050,3397298,2329365,5040228,2240724,2979439,6401285,1972074,5511209,3885512,3897928,2848854,1114130,1619626,2511404,3033296,3132103,3380102,2236401,6411681,4979733,6412886,2013755,5640793,2668836,6017300,1640404,6414604,5058154,2391717,3639125,461319,3871338,5039512,3358205,3188750,6406318,5889127,5685796,1888722,2031025,1126374,6421799,4980530,1164127,4183666,2621317,6365693,6152534,1928164,4017375,2829044,5012509,5355995,270143,4808582,4765875,2230445,4236852,10654,6347757,6431661,4702925,6433076,5923757,6433660,6393309,2109254,1574221,4019986,3217457,1798341,495591,4314069,4538337,874829,5620296,1028589,5732368,6340885,2146703,5834219,6402183,6020369,1120229,4161602,5166295,3994250,612035,1189783,2277485,6380294,1732865,5059083,5199746,916173,5900153,6449275,6019603,5720821,6451396,1905944,5632628,4700433,6382885,5179133,1435820,3154405,4526700,4471085,6434325,6455996,4667349,2766161,6034515,1211620,5506615,1659543,6212875,831165,6300197,3086956,5095731,3176270,6461648,6456821,6423291,4410351,5160493,2515354,3669045,4842671,5545130,6466130,4440692,2996635,4502212,6468460,4256069,3612949,1461223,5664915,6357014,6441594,5117173,2455730,4344140,6383930,6207849,4616326,1153689,3066046,5962841,6450390,5865971,2962328,6411982,3928546,3164187,4679715,1080679,2387291,6185991,5658353,6367601,5056575,2556555,3349545,6461789,6427630,5404220,4628115,3002268,6198927,3262883,2424864,5075122,1287593,1243468,6491416,802599,691104,4801801,3498537,5278806,5103711,2778722,3845747,4498110,1288071,905938,4077611,5561898,5044921,2599052,6498993,3511012,6504954,965176,6497811,6113211,3294917,4422996,1662775,5338469,6510197,484732,6511188,6180200,927493,5049799,3108967,4529790,3859772,1696972,3719857,3890625,52420,35690,3837778,6514262,5828950,4728572,4797147,6517682,6515846,115138,4106624,4655934,6410827,5723000,267341,1866078,4856302,2912478,1281658,6513313,6185089,1053577,6513717,4586499,55934,687252,2982437,4517209,2890139,6320022,6526453,1787919,5675885,3601158,4114093,6243597,4045924,2291310,1143724,2354117,5371224,4506442,6295773,6496762,5757964,1370834,5318061,3083483,6510497,1689604,4375452,6544803,5795475,524368,3568092,3726169,6346040,5802202,5701663,4157407,5581182,6539852,6552506,5456160,3316645,6063,3707607,3323733,2398705,5330175,4337437,3491770,5867869,6206263,785494,5837903,6056985,5655414,6531726,711718,5917228,6560487,6447563,2954547,300805,5180613,4858650,5303992,4080726,6568451,6120970,3402934,6549103,6536676,5993601,4135363,4992688,5003309,5875023,6304340,5546479,6574493,4218755,1676032,3856609,4133062,1152980,5925085,787225,6549963,6580727,6581027,5158905,6581362,6583452,6583508,4744624,4649682,2766477,3099055,6585782,2908496,6347799,5793208,5405338,6328562,6303121,6212999,6495072,4990578,6348042,6514244,6177261,5233074,3810466,4395067,1181387,6592920,433718,6022665,6593882,6593562,6594083,4805737,6440793,508175,5319580,144140,5071195,6484130,5501963,6483314,4795896,5155190,3096837,4720801,4661077,3870545,1643558,6497131,2287486,4920189,1620696,1492590,6415638,5755872,2752471,5867542,4110709,3698894,1480796,5299823,6494296,1219722,6433447,1932452,6206072,1485662,3870909,2513816,3046322,3425503,4264267,5402249,2741060,6611044,5639688,5056367,1608940,6448607,4028271,5945965,6615860,6520086,26002,6616149,6616162,6616932,5697437,3510043,6323369,2762365,6352986,6345810,2768552,6619877,6203514,50312,2159739,1379613,5033983,5429874,2294535,6350618,2805305,5603956,6566449,815707,5366130,6412120,3716368,355507,3529205,2913869,6629560,2893839,5969463,6629943,3858162,2543880,5484609,5148363,5257450,4799172,3549636,4738027,4698846,2302662,4890658,5328292,5534514,6344366,5666810,6624886,6639150,6639288,6440093,4040743,1914263,395879,2481656,2883639,3864475,3794830,5736091,2272346,3103584,4907247,6431828,6129475,4752506,2298352,5446219,6381121,2017759,5214240,123132,5302241,6331869,2887161,5770965,5545287,3539725,556899,2352145,6057372,4108792,1013774,5851595,1469219,6659790,3733989,4892666,5838070,4989212,2271513,6660929,3627023,5282656,4331646,6222152,2518471,4051653,5569565,5306573,6665780,5563414,1112283,5718020,6626012,6366772,75328,4631188,6671955,6452688,6672764,6673006,3801980,6673674,2167332,1349768,6073876,6563591,979102,6606312,1424395,1839360,2573061,5352633,2173983,6679014,6406346,3777390,4580217,6571594,2193738,6681001,5531628,3663882,6681747,4129592,1924829,2516009,6682421,2036214,5760615,1339946,3644960,3860847,4065216,6492166,907897,6350029,6687375,6623277,1210814,5675083,6688528,6143363,4372511,1597897,5486078,6039383,1650068,4737729,1541563,3605608,6692138,6103470,6668271,6693175,1984974,5966230,5039933,5672345,5361456,6099096,4900327,4033658,3608824,6701967,5755122,5831538,3845853,6704356,1912475,6488894,2741140,696492,282729,6148349,949374,4880708,1471694,2717128,6602112,1715453,2133814,265570,1456830,6710717,3641185,6710946,2673347,5503451,222529,3537572,3101139,4392501,5326826,5651579,6716226,6250527,2543209,6107805,6718710,5921058,6596544,2604247,3288092,4674452,1366887,499839,4857132,2001026,5245639,4608491,5998193,2175533,5860784,1682131,5112446,1612373,2859991,3126402,4922211,6673688,4205156,3214987,3395716,1778038,5917087,3838729,2606389,3225072,4443323,3568904,6660785,5080563,1562874,2203108,6411816,6395151,6736776,5094841,1419480,4269314,4771355,903444,167129,3943306,1861418,6129636,6736375,6718785,2713165,4496671,3187901,6526901,6663632,6040181,4882196,5896888,4334759,1560774,4749297,4477223,5978953,3898160,5533301,1014217,2259187,6711025,3323380,3743168,6334916,767890,5296606,2876097,1087990,6689059,301833,4466315,4037364,6763600,1697845,1059762,6764679,6765006,6765126,6529874,4979714,3148807,1756478,3132497,6747694,5164079,5527786,1692488,6334309,6752434,6320717,6753182,1782765,5016432,6528683,6776849,3677652,3202340,6618289,5649764,6431839,2334254,3902100,6765896,5681036,2000189,4112054,3001616,2258406,1559401,5313508,6523710,6785798,5955399,583810,6782422,6788900,1609367,5460458,4962207,4830251,4113109,3948664,6723903,1083314,5872512,6605781,5526354,6798623,5553794,6798873,609681,3992990,5890227,6728330,6765548,6405419,6221920,5055644,4336086,3960140,1035750,3955586,5309828,5610655,3429032,1931467,6607734,6003859,1271898,4437044,6809242,6782587,6808011,3677394,4852706,5310630,2018675,2882541,6812321,5797598,6808710,6813801,6779640,5938809,5116581,1850712,3079474,698876,6791790,6426203,6364639,6817940,5238915,6818506,6515129,6819093,117648,4542218,4280745,5908638,498892,6819784,1275924,6069651,5480929,6186347,6810832,1514682,3573797,6819587,4249059,6825633,6825722,4954471,4903610,2225319,6766305,1136610,5737116,568458,978285,6595385,6539416,3329439,6349471,4335937,3192795,1540501,1279180,3377122,2968894,4415245,2570500,6198207,6838716,6838840,1809445,3826059,5679055,2271522,982652,5304035,6841852,5731192,6672266,3103056,4261434,5438371,6603368,6784913,6762077,2461398,983883,6567904,1589440,5983936,1110687,6214911,4721738,5015683,2293218,4305712,6270427,5851520,6762188,574686,5578712,5529567,1274106,1275161,2262635,2593900,6787804,3560330,6741497,4697754,5663559,6382903,6856398,1913646,6859743,2605210,6860738,5051153,1367360,6862030,5894770,6033519,6836840,6842548,183662,6863017,4351764,2259618,5075446,6867916,1387157,5847311,4390557,1809507,1276000,5672025,6484116,6655455,3316461,5601039,6215521,6875977,6824000,4657037,2767100,4757175,4940476,6245072,3701771,6750410,5606545,2205080,4256703,6300005,4962788,3932908,3547465,5362947,2152305,6771384,5623302,4983531,4318379,6892006,2386710,3119116,2888098,2608515,6901151,6901161,1387713,5329181,6125751,5748408,4067986,4913451,6904709,6752498,4642081,4642234,5323344,98080,3180065,6906979,3687068,1433483,6838037,5510530,3419726,4065451,6394099,4060069,6893928,5466574,6912196,4594967,6453996,1901458,2191979,5607870,2143819,4789122,5179594,6563592,111243,4242180,5690845,6920367,3781320,74184,5884460,5113524,1398915,3435810,4551198,3169565,5176433,2410062,4725760,6420911,6928456,6775754,6928928,1241445,6766158,1921982,6848077,2182594,6836874,5580652,5344915,1298378,4192366,6934602,4312489,6935744,3647254,6937071,1079604,2743643,6756754,6536442,2487517,6348198,2355804,6503114,5879215,3960850,3727439,5609686,990996,6543463,606730,3757533,6943697,5394999,6689201,5382318,5407682,683551,2541591,6483529,6564758,6239732,4697963,6949270,5776054,1638423,3672914,3561285,5876856,3390213,4653045,4511424,6999324,3144552,7001818,5736528,4051982,5893331,5460583,6179231,4555534,3063935,5201651,5018591,3129183,5445329,5959753,7010058,1993709,2737948,2034903,6037103,7013914,2015911,5265222,7016058,3968798,5037293,2195567,1180686,195446,1296554,4855780,4063770,4123267,1948982,1732107,5227232,4203807,1595380,5953311,7024004,4211173,6457193,6947703,3240313,5109681,4431008,5220888,4737001,6166977,7027219,6832851,4471178,1560635,6902473,6782799,6869232,900683,6541602,5241479,6263228,6018934,6884571,7034701,3314484,3689186,1791279,6840920,6064384,6835437,6715681,5484316,5368448,6477119,3669290,2344024,6840794,5119700,2357956,780861,2182650,2072676,6682602,4605946,191224,6201391,7033106,2356181,2297501,2507710,7045869,7045957,4475902,6617099,1521679,7024050,4693190,2349358,2033252,1882455,1170903,7052479,312323,6437899,6797779,1620112,5800661,747579,6713337,6693256,2316068,7055579,2099297,6427711,1371389,1418069,817630,3222702,2138327,6069410,6909706,6743894,6449766,6950277,2301349,5739111,1126159,6518890,2123007,3797875,3080893,1280331,6738072,1972493,2876105,6943530,4088652,1435046,798536,6673991,7019978,5445380,6920968,5692945,4187485,3011082,1502898,4618880,7079556,7079573,6824513,6573669,6790757,1211764,6678309,5361215,3955593,3828443,5672740,5818631,490473,2486355,5749750,6205149,5746194,1695258,6310854,673852,7085402,1895473,4499354,3663469,7075754)
GROUP BY 
    u.Id, u.CreationDate, u.Reputation, u.Views
ORDER BY 
    u.CreationDate;

fork query

edited feb 21

created feb 21 anonymous