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 (1671885,2535745,3924979,3576214,1079221,1189762,3375858,2939230,904050,3993397,2686112,3666302,1370186,3430421,1924843,3936624,3817651,2053159,3822255,3996519,3454439,2663867,3997130,500468,2807996,3997649,2829764,2313491,3498366,4000390,1579701,1211528,403310,73501,139618,1634313,852118,2532768,1672701,511792,3210719,1170730,2136799,1030220,1995839,2478134,1394464,4007095,3218940,1360970,2002452,632944,3808632,313768,414414,197464,217470,611873,1186786,2270296,1294904,2466650,1720085,381261,3402859,152386,1698506,4014894,4015646,2051647,3156777,3391783,4016516,3440545,4019012,978486,3933627,3997984,1366855,4014173,3942338,3291846,646210,281188,90291,678455,2530000,4025003,2543838,3615757,3564995,3986333,1835779,3942976,3262037,1441346,3921757,1389469,2359012,4031976,3342450,3290131,4002358,1395676,3848466,2200045,1680946,984868,841626,1916501,4036419,2583625,1308256,4038244,4036230,1705325,3276435,3551365,4038021,1978386,3367112,1040741,4041225,2136963,1977132,3850774,4043806,3626989,3580389,3933482,1544725,3408454,4049487,1806533,3588040,3243563,3045531,3578203,3993291,3840069,2519617,3036757,4054409,357349,2725992,1548927,3678912,819720,478267,1102215,1119631,3282123,1374644,4064898,1870072,3896932,1103861,2820246,4047545,4067676,1837165,4068615,2732173,3760113,3979554,1310875,2507197,3553107,3959990,178830,2162840,1672078,2250246,904767,1922144,3607053,541654,2790364,3657953,4077095,2932397,977295,14351,4080627,4056620,567292,4082948,786020,4059501,2016618,4086965,1189488,2962174,4016831,1240159,3504514,2015289,1895488,1755381,1885250,3992795,4091417,3713620,2334407,508181,4096298,2313623,2960286,1030598,4097196,3974476,4097433,3155945,1246115,1686628,4100119,4096629,546657,2159991,3690065,1075753,2174742,4101846,1179181,148905,2314347,4088542,1011724,3281986,67384,4103957,4063018,1615263,2773311,2864740,612925,227209,3308529,4106972,3365930,819732,4107113,3931062,3023426,4001737,2093387,2817323,4107772,1843190,4056443,3701179,4104274,4111580,4112280,3909257,3333603,2158107,4062072,2928422,3310212,1791833,2334847,4115301,3919519,3790046,4067463,4051915,3272452,576448,4096219,3417039,4102347,634619,4121289,1180059,1358843,2730373,1188712,3991928,4122893,2333311,965638,3908397,3462060,3340550,485880,3165462,629804,3721062,2912665,1338201,940647,4126032,4126093,1705598,2478019,4123851,3528482,956730,2707156,887074,1922350,4127641,4131730,2504479,3851486,2346716,4132754,1341006,2961427,420867,4134047,4019570,4085660,1106160,3614682,3369334,1820180,1267466,2856410,3564573,3007216,3470841,3583721,1692350,2552310,3361519,2856289,1081088,4128182,3230975,4026705,133183,4145749,2019000,2312067,2721666,3998051,108977,1617664,1397012,1601737,345657,2909230,4150407,152109,2112296,859104,1069473,3988675,2873372,3049049,3697125,3925129,3756015,4080129,2701815,3700561,3058656,4155753,1517227,709010,4054698,1673644,640325,913421,595189,257942,4147997,3894927,2584084,2459452,4161201,1268258,3338505,2924127,3136710,837515,2124795,1185671,4054491,1640758,3216616,4135280,3344704,4172007,1579948,369619,4172624,2900548,4170938,4173401,4174895,4175739,2168237,2407058,2516800,4177035,4177055,2837813,481420,2591935,3130681,2958542,4179090,1932405,694469,1916110,2663119,4180892,4176453,2642809,4167563,4183495,4183792,4103341,3508201,1702401,3624195,1225786,1182207,1698987,3413239,4172026,4176903,1231599,2384366,4189573,4189710,385264,4136319,4190962,3842916,4191572,3454794,3155421,2466907,991282,3281743,3018598,2272048,4082521,1984608,4125622,3779669,3280836,1480923,4200867,2969631,1533709,3018275,514481,2809156,4203287,3127242,3665670,3898180,1989612,4205534,1490863,2284725,997338,1369110,4206931,3502949,4208357,4208323,3864949,4208420,3316836,2359287,3996238,4115244,3917343,4024328,1733825,2152500,3989939,3299397,4212580,2791759,2536088,896559,130121,1389337,3986232,1080480,1416039,3713695,3863579,4154185,656912,3557379,2620007,2182934,1167194,4164238,4198049,3873406,3210493,1398585,3542839,2090317,2948474,3678189,2721741,4223140,4223923,476388,4224112,4187825,4200230,513511,4226228,4224186,3697178,3356361,4214416,1718119,1249267,3963688,4134117,1794594,546338,290957,3885215,4229167,4232924,4184177,3904488,2694511,2918743,1137669,3746396,4236816,3995726,2583417,2295715,26609,482284,1494102,3558145,4152932,2258438,2083119,349100,4233465,3715648,1351298,4042202,1901786,2649586,1146450,2875994,2856307,4245579,3187621,1006221,4084296,2912899,2518644,897578,1165215,2067665,3555135,845532,2755899,3634601,3278063,4232149,3964537,4241265,3575529,4253708,1380059,2953798,3997224,4254635,1192761,4255223,3854950,4247297,1469505,760856,3655914,2224373,340046,4170935,4258185,2597415,3234977,3076272,2168113,1782922,3836204,1104974,4258445,4184178,2789784,510167,1368884,1323071,4231927,4264511,4263461,3864222,4265554,4206991,4266869,413313,4267175,2690949,3457350,962797,2628196,1437138,2071226,4239371,1910388,4269803,1289198,2946209,627254,2002790,4035943,1110044,645128,3131147,593502,3207652,4197547,4056249,1255817,4272510,3672084,2596879,4048775,1242944,2397318,3070996,4274631,4275072,3991251,1164901,2997356,2521049,4275902,4241120,1074358,2210508,3472630,2422734,2173836,371730,3986322,1211554,1825352,2868510,4280359,4280772,3992113,1916781,2452602,968132,4226095,89391,2886084,3198674,1110888,3616236,2097228,3628620,3793975,3001973,1477313,2868778,1245631,4090190,4232275,2391318,3554666,2775926,2907755,4292997,2852310,1204242,699247,4256306,4238992,346297,4257248,4115195,2368148,1185981,4072311,3051667,4213264,2634875,975870,1786027,2572413,3963389,4301748,2201005,3870509,4033714,1387727,492336,2291552,349043,4154727,4021295,4017481,3402827,4303748,3551894,3391018,893643,1381855,3876989,1349516,837652,168715,4309561,3923643,4310393,1128057,1707520,2171961,4309904,4314822,3303123,4315384,3277131,4317951,2898518,692572,4026690,4318647,3595207,2160231,1268264,4156963,3652974,4319496,4242592,2410994,4320096,4197387,4305378,4279514,4321693,1984680,2256753,207795,1000827,853685,4325005,3765881,4314286,4324674,3348859,109665,4325846,4320709,1356924,3158434,4327395,1558658,3099146,3439329,4167969,3200855,2205736,2827375,4107153,1847873,3233880,3043579,4328862,3545744,3086981,4333976,2997251,1343318,1701574,3457747,3855631,1748977,894872,4337164,4337431,2978172,4146202,795896,2204360,4338144,4333110,1510255,4260535,254215,1139529,4201191,4220442,4339865,4233218,2668547,1326595,4345648,4283171,3597487,1530018,4281451,69433,3057743,2250471,3565522,4349182,2231527,2391384,2017131,1193301,54259,4351591,3091745,412354,1105898,1326692,383674,2361497,2281752,3442852,797942,3314701,3674018,4356146,4182202,4324819,4356775,1224186,4358021,2352158,23972,4358370,3965505,1190396,4350123,4247090,4199160,612001,3509227,494143,4360252,2206540,4363725,2877129,4364876,4184412,3412869,2816536,2934312,3212493,4369833,3423045,1026037,4013034,7819,3530012,3750079,4373523,172232,2811688,1088797,3261471,4278049,1178823,2980055,3964383,4380656,2634753,4381171,4300583,4381250,2888905,1850746,4259165,2010246,4315812,3933565,1474848,4209667,2070745,4060595,3206471,611901,4343007,1618131,1329629,1397564,2929341,3441267,1146679,1578594,3944392,3726864,4392540,3493433,4392727,4392836,1711723,627327,3975771,536593,2116243,2622807,3888646,3753308,3794453,2824682,111110,3866601,4052871,1742566,2795733,4108081,3836845,1269892,4399222,267304,4402183,4322080,1998851,3014930,4403820,734748,3420171,2926066,3615725,3775099,4101319,4180138,4399545,2351234,3797031,2909492,140811,4389805,182048,1015678,622644,3556757,4367848,1406510,1823368,3127615,4412997,1753644,2818398,4415421,3727320,3363726,2154436,3344075,4289941,4373429,4319615,1658526,1392034,3743752,4403515,3144322,733649,3111913,694345,4412982,4418960,1769128,360708,3366916,2072882,4296301,4362763,3291629,3805652,193789,3751615,1032531,2352472,4413930,824612,440772,3640096,1849876,2570155,4112271,4192985,2027090,4404628,4420028,3528334,2857080,2852807,1781168,4416975,3284402,480632,4354218,3735495,3422673,1487804,1382251,4418781,711705,4435460,385335,4427735,1263727,4407213,3812925,4105877,1734787,1771069,607230,4440815,4177843,3739358,3839722,4381246,998117,3575075,1812406,1106398,336648,3467349,4446484,3264593,1182591,797417,2671194,4101896,2910740,1067825,1147825,1070698,2324078,3124084,1935008,4451400,3071660,1696515,4399026,2496366,4438608,2118475,4123112,3039918,4454444,4362092,4281534,2126725,4397231,4279562,1861543,3427852,2999856,4458979,4459096,4459298,3076813,1262568,2797848,2086957,1825888,1016585,230422,645217,3358347,1269942,3543206,3369592,4459665,2740689,2823755,3611427,2190564,1033716,3758171,2531328,498847,3064745,4461661,1109339,4470044,1534975,2778860,4470505,1762346,1997016,4469920,1958060,4340785,4104357,4281515,362703,4328149,699605,4370840,2617905,4476036,3072788,17648,1937270,3513103,534101,3109012,3458606,3406029,3252650,4460015,4482322,4312236,3878148,4482958,1469261,1827295,704972,355288,4484620,1288527,4238906,4477802,826983,907860,3970171,2776503,1076056,846034,134252,1186944,4492105,1480218,3391050,845505,2166418,2814715,4495436,3588482,4488693,1985148,3850595,2343743,4498540,4420704,3648161,3022331,3223328,4500308,4500455,4252989,4105815,2258421,4504461,4371355,2415831,1818661,2874726,2156825,4509213,1626485,4509922,4510049,3990171,2125355,3134069,82208,4513337,4514666,975904,695652,2487927,2224168,4517478,66607,3666471,2168706,4520787,4520210,3647101,4364070,4493564,4523645,3042673,1488690,1610626,1126923,3377466,2949171,3746892,4443530,4457744,4529070,2754615,4525164,2712937,1445279,2760331,4417076,4528408,4292058,4270436,4532427,1557062,1474183,3305679,1096161,4533788,4446272,1725482,4535957,4460855,4171230,3915113,4515341,4328782,4376502,4525025,2203311,4155293,1488380,3576811,3383075,4495814,2146530,4544719,2670028,4465865,4266786,4547045,4547092,1456391,735472,1112048,925897,4328348,3014070,4329896,3702245,3309479,769384,3355350,3296093,1650448,1743962,3235192,4455537,4360431,74562,4552617,4531465,501011,3807935,2255118,3871748,4556352,4556519,4061847,4303905,4133768,4065363,3782904,1346910,507905,4560854,1455116,4561068,4504676,441521,4561777,4562816,3908413,4464416,2633527,2296548,1753963,2117605,3469699,4567466,2803987,1205479,4566998,4568137,4488375,2949308,4051145,2063770,564867,3868607,3528716,76024,871495,3691727,62018,1625484,3146509,1257084,4523744,3753366,489885,1289311,1258041,727366,1064270,3424684,1935759,3739324,1180503,3876141,4579615,2609994,1775385,2759955,3449229,4500322,3506399,4583140,4584549,2965673,4184356,4585907,4559611,1492973,2102440,3048967,1474739,3925972,2659313,4586197,4589846,3325669,4163193,98389,3150552,1340885,3572255,3015449,2828815,2749470,1779806,3763293,4439956,2293006,679612,1033323,4590499,4256367,1350864,2743239,4594697,180416,2002204,4595518,2164904,4197747,3846027,4597721,4237029,4119421,2577659,1041195,2227218,4473386,2420592,4600012,1622035,2619485,2661999,2334520,514069,3104963,3293628,4603588,981367,3571640,386159,2761035,3707465,3674287,4293863,2378419,927030,4594698,592125,632886,4612492,4548688,2833518,4614004,1671578,4011600,3601754,4573521,3355407,2315602,1058136,4616639,1304357,1941113,4516647,842225,425714,1591731,2576156,4618792,3072517,347289,3997611,3287033,4447005,3769877,4621497,1324403,372434,2385324,1036670,4624491,3906918,1346943,4625277,633251,4531511,3159486,4262904,2596347,2188467,1641628,1612814,4627231,4402232,4357281,4581422,2820570,4573328,2695344,4634193,2574171,1979776,4049588,1089623,2046805,4638804,4541929,1816933,2776506,2174878,4255107,2843665,4643821,1872329,2071460,2820780,3183031,3623905,962758,613996,3480598,1160471,1045510,4621823,2440470,2443255,3688173,3672208,4436189,1977591,643828,1444073,4204903,4512966,312114,2719160,2986537,4465747,1956906,854065,3946487,4016367,378052,3494492,3689130,817659,673991,3365746,218592,4656131,1391717,527312,3519122,4652601,52371,3758021,4662274,2386397,513750,4332532,618172,4663547,288091,3717347,4355692,1689816,1032613,3081611,4530336,2201260,563765,181309,3283252,4668374,2646514,465318,2899962,1927242,2683133,3618302,4620646,613247,2318579,4108529,3358732,4672183,914284,694184,4674547,772266,1365418,4263018,4676688,191969,1619207,4019700,4394476,4678762,2577489,4544302,4330757,2325916,4680350,4308846,4022089,4680631,4681253,3053423,3084727,2923947,2138356,854987,3037226,4683816,122536,3981859,2605036,3733985,360390,4612789,4265321,51021,4576968,3462321,4676787,4039123,702883,3664767,1456234,2998454,1268570,2540964,1252748,582614,1260114,2476782,3411238,4697424,1560617,1561358,680794,3666866,4698665,3054901,3148734,4696525,4696604,2019265,3332690,580993,2898278,4479816,4699240,3935044,4586192,4694866,3470630,2919889,4702172,770788,2887760,3692521,2063096,3846627,1710577,1481013,1812565,2333390,4146344,4713197,4714508,73535,567547,1878788,4718050)
GROUP BY 
    u.Id, u.CreationDate, u.Reputation, u.Views
ORDER BY 
    u.CreationDate;

fork query

edited feb 21

created feb 21 anonymous