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 (4130362,2766650,5394403,253289,901889,2002079,5345443,2988569,3991412,461535,4007560,1955231,1598568,4306219,5401346,5401176,4694206,1183876,4112864,3799942,2966723,4272549,1492022,1423561,2603268,2820892,2839521,4431683,3971855,2991413,1462054,2027839,4011933,5406887,5234573,5407022,1945081,5244650,4547068,4628988,972202,2439580,1721137,4355529,5404958,2232367,5335452,2591859,4358737,2046394,5413187,2786677,788337,3406052,496136,5416038,792238,5416578,814038,5214510,1279449,4765093,4907965,3140750,4083398,2620202,3698723,4501236,3440266,3880800,5271529,4636813,4420293,1447013,5007969,3927334,5425281,5063316,1661745,4611837,3932177,5260008,5426788,1546934,5426858,1928515,1209216,1715000,3443791,1433675,4039495,5429977,993554,2497887,2657641,5406068,5016136,5432108,5378077,5141989,2796253,5432978,3609535,5434358,5434535,138645,22996,5433183,5438487,4060971,2214410,1686444,4465819,5335874,2655119,2813434,4070524,5442882,2437790,447426,3872108,5353712,4965958,844541,4803270,5448315,5010413,4014509,2166130,1132213,5415875,3084178,472673,686806,1989682,439507,5453856,3267025,4973771,472269,5193827,5455423,3702506,5457368,5292738,136598,2296177,5459080,1329184,165031,2208112,1831108,5182205,890678,3083195,2609506,5379377,5446775,3149139,5387372,624074,5460959,4178972,4776884,547780,2335246,5350297,5467831,1807477,3166883,4264549,5452431,511837,2416097,1413969,3924098,3699213,946656,3974553,4415243,5396541,380396,950249,5303489,3329265,2605604,4700611,5475242,5475855,5232046,2593854,104468,1941853,2166932,3909794,908313,2675431,901239,2143724,1575291,5482368,5115872,3506691,5483193,5483625,5381371,5432726,5414692,5121603,4773380,5087686,1325437,2944460,2899420,5449535,1917258,2317696,5487097,4388803,1413825,3942974,4636048,1939604,2281790,5488901,5490076,4081647,5351703,627473,5491475,3966160,5461928,4952762,1847212,5145530,5494000,1234240,5494329,1231198,2581188,5104391,4835773,489260,2758856,4077900,5495249,763509,882837,5499845,5500790,4723912,3253883,1557941,3692170,1718177,1376627,4726477,3752432,3278296,138227,4945724,4113654,5397513,4762134,5507030,3130747,5507154,5506942,2374651,2829209,4163443,5510335,5511120,5300594,4305292,2738630,1972509,5368778,5487798,823697,5145897,2681631,3294573,5261384,4602045,4745345,2231232,3121975,3192671,1795279,5027769,2736516,1544153,5512226,4873680,977203,2775433,5522638,5524020,4357326,3093936,989692,4785282,5526034,1668421,5519022,4777102,5527377,4693428,2134591,4945656,5299034,2855071,3478551,2518696,4070422,5142761,5532730,2661307,5080607,1748746,5535296,169252,5204481,538379,5492321,3728995,5539066,4254033,2852568,4809055,4431839,5325381,4320131,4095942,5351720,4541907,2526842,3872094,3560981,2209329,4074657,5520728,4930328,5334460,4230315,736872,5210481,5464236,4802584,5552219,5547551,3100727,5537648,5552893,5552801,5553273,5553420,752102,5281930,283296,5126637,2879292,1993412,330396,1484934,3697365,2157055,4325963,4301070,2374028,3980206,5116780,3763071,3187643,3401058,5563057,4683166,5395136,5280598,2275042,1747490,5019879,3088349,2446799,5537760,4511333,1376761,4249780,4134800,3733758,2283642,2232432,539997,3845331,4567228,3511695,1998288,176615,5571869,623722,4325010,701211,1376556,867461,1652599,4887279,1060408,4620733,2560087,5578257,4356884,5462312,4538066,5188622,5579429,587617,5579576,3871681,1712334,3785114,1085805,4030934,743203,259538,3895373,4945100,1601161,3670010,1940679,2395769,5131819,5583997,1711465,5445583,2290639,2809267,1915161,3950168,5586736,2965107,4801797,5587646,5588344,4508063,4692416,4201498,5451071,5289392,2692779,3098364,3154429,5433463,3762311,4776729,3848411,5511759,5591801,5591819,3808059,5592045,5587380,3558475,4852614,5593072,3680879,4971297,4048945,4727011,5541716,710734,4230807,3072201,5524625,3096657,5501675,2970104,5556250,2092844,2276080,4966300,1563037,1970395,5542451,5598864,4583357,1245262,5600708,4284924,5601488,704734,3607039,4950907,4767245,2898637,2544222,5457693,1271603,5595776,1673287,4159447,5559274,5357260,3984496,5608320,4014755,5007618,5511339,4683464,205696,5192982,1937054,5476777,5379206,3255525,4799969,5067712,1942656,825844,5615585,3445532,2225753,4004657,5217929,3544933,5016214,3240152,5059201,2514986,3843492,5622964,349994,5093018,4915580,4247734,2399799,5479963,2629516,5627276,3949611,2160680,5225747,5016197,4250417,3907006,3287921,1576961,3217315,1940240,5062972,5160,5533645,3532545,4460287,5134819,5514026,3577397,3136323,5638160,4580654,2433664,4580854,4363860,5641062,5198972,2145407,2114756,2291825,5594698,3687719,3616026,1115761,3155595,5646187,3451049,395857,1997062,2287611,610084,2415512,5648188,2935832,4985092,4714631,1223712,3141942,5650824,5651101,3599549,1397535,3431946,465750,4332555,1815190,5651619,5562500,5657924,5478227,1692028,4450941,2148718,4700209,3721335,680,605129,2672235,5665408,1833218,5665647,1055637,3141240,5645641,5667271,3765717,1924308,5668111,5649278,3764634,1250977,5417542,1959005,1337392,4112078,1938988,1397712,5670716,2608793,5478552,2196985,3606363,192077,4241498,3657747,5674955,3666398,488539,4061620,298607,1043569,3188300,5676462,3336204,4734360,4798562,1591659,1849188,3814090,5505723,2599301,3032469,4713868,3068684,5683968,329063,401660,4496060,1485100,4779937,2095022,4202861,2349589,2441401,5577495,2752185,4227232,1477456,3667604,5420052,5513501,1456004,5566967,259374,5698050,3346752,5530736,4965360,5325225,3045201,5700745,5700895,5697764,5293810,4321040,1222240,4730258,2419960,4928642,2802911,126995,3889320,5704953,3850265,2842549,4372759,381158,5709813,2025666,1671269,5653385,4891144,5715071,2467476,550384,5592892,5690621,2838606,5450942,5426661,5362886,5667559,1608816,4347691,5718940,5132281,999329,2776361,4452222,4483695,5721693,5715402,416972,4474740,3756863,3998282,3409611,3087680,5728440,5729080,4528786,5540398,4589953,2489327,5570970,2876754,5731951,5635159,3895858,871404,4205098,3053195,5628445,2508770,5732119,1952975,1401789,3723306,5627010,5710848,5672632,1701813,4602561,3944303,5741495,3495404,540312,2018509,3725538,5743569,5744751,5696356,2293877,4790441,3580785,2173353,2080712,5119420,1167086,4936024,4560488,5506141,4498684,5649575,896697,5008381,2737316,4251785,5143860,3653343,1170686,1121150,5347093,5699895,5705883,5368849,5419668,5679245,1044858,4037927,4036668,1421473,5689425,5736799,164089,4188803,3870894,3466508,1921477,5115323,462347,4289592,5768535,5725479,4906746,5085347,5145653,553766,4888655,2143209,2700593,1995613,3478500,3099265,3709678,5222061,3775989,5605294,2492629,4447390,5231956,2984923,5533197,5741536,3237870,1664599,2467747,948401,1945881,4913695,2987400,5732617,4415759,4458792,5792889,337461,5793521,5793913,5794378,5793714,123671,5440589,5769812,3813411,845230,5678778,5387592,4232462,1421194,2315997,3858260,4256498,3370070,2765554,5078465,5357170,1081340,374358,5282214,3144177,545877,5806666,5248889,5809203,3187217,5778697,4341456,4019780,5814122,5808787,3965752,5585178,1494214,5008302,4444135,467366,1677663,3785301,5818933,4529126,649920,2760433,5061765,5411388,2874409,5437107,489041,4434960,5823890,5824533,3494179,508654,5009335,3780370,2274847,1347008,5827167,1167442,4119201,294884,1658328,5578439,4068013,4970898,4345946,393756,313910,141325,5369107,5832474,5390131,4783222,5834056,747371,3972475,2096048,5539085,5181766,5822162,5770144,5839283,2825656,5834548,4589803,5377424,5537307,4283850,5325044,1222542,5817405,5162964,964988,5845499,1342006,3596212,5847863,4534743,4548474,4544662,5798015,5783187,4534183,1689090,3119490,3179537,5451968,4498942,3814143,5798328,5177763,4450717,3043749,3146132,475673,5305530,989275,1579327,5862374,5207198,2998612,5862983,4910386,1923833,1055323,5795493,5768196,2284136,1887101,5704802,3179492,1442596,5283801,5870674,2970535,2825340,4148179,5452994,1636381,5873534,5378022,805779,5227012,1617887,5737959,2267175,2645833,5880517,5334582,4421069,4785344,4617233,4862881,1929437,4049851,1621907,975798,5885575,4553412,3285138,3936440,1994222,5345884,4309225,5889229,1630220,2288848,3319126,2402806,2750396,5890415,5675768,5891939,848968,1779743,4557803,5613914,5894034,3112936,3680874,5025014,4324721,5896379,5868082,1041639,3578521,5183217,5097561,5864738,1643465,5899128,5518272,5635959,5825523,4320915,5692838,4696389,5865569,4084252,2861459,3426125,190467,5908487,4587928,4525817,2118055,5909918,5590376,2571149,5755324,5910978,3492125,3085495,2012715,3434874,5914356,1379309,3351924,4618347,3909898,3421913,5916927,5775567,4261776,4890364,2567859,4561292,5920325,5364226,4658613,5920900,4119004,5923091,5920674,5410410,4757046,2209904,2468113,5903512,5927273,5920506,5928165,2175228,5929278,4065483,2361573,4191798,871910,5890708,4235703,5718478,5419761,1887290,1424399,5931809,5040972,5593968,3604973,3862696,1421553,4420455,5786339,4863925,5936128,3247800,3721259,1974474,550471,280485,564979,5857949,5520747,3846175,1540330,3302563,4309871,4671923,2173372,910813,5468068,204693,3900370,5903309,2207748,2341336,5483486,2913563,1901823,5629117,5942099,4598120,5938066,5631913,5893193,3993731,5731488,4443898,5945674,120541,5520173,5955832,1990758,5452648,5624947,3058029,5873343,3375135,5510623,4995940,5961793,495745,5961741,5794667,1375882,5932347,5791522,3687718,5591643,5134102,1562764,3589054,4754790,1709142,5637605,5492296,5128845,5873831,5685655,5973084,5799850,5968883,4501480,805420,2788450,3577478,3748498,4830695,815847,4283749,5859124,415663,3576946,4191711,2608572,4845149,4474068,1382287,1315444,5371005,5954447,3943956,4854766,1825632,5960260,5450006,4642046,3119737,4804346,5977597,4051719,4156577,5594633,5989878,5989894,5462526,1583225,5256207,1751578,3002565,5993758,4658310,5820788,3058554,5903382,4752761,3696632,1603511,1950945,5794622,5997765,5132487,5964376,3247226,2363393,4139651,1642344,4679727,4716488,5201562,14649706,1094999,1013393,1299780,5203608,3067748,6004516,4013131,2989136,5047467,4363688,834239,2180139,3902603,1469167,672841,2246127,1005102,5072934,6015873,907921,346382,4668550,5353877,5404527,4544687,4522447,5943025,2882670,5973334,5948804,1787841,1909485,5403466,5471063,6023367,2859238,4190109,3760100,3410845,1666547,3525469,2016319,3145729,4802943,2963006,4788605,6028998,458157,5860286,6031904,5111713,6032460,5591105,765965,2504163,5379533,1925037,4691279,5963434,3910483,4853432,3910195,315151,6039312,2045668,1653693,6039937,254694,5477862,5758649,1113108,4976885,1056710,699606,6045903,3825136,3733061,6047238,3329564,3211391,6002782,1068947,6033440,5843190,747024,471093,4197031,4615677,6052500,5426743,5565684,4749675,1204976,3079179,875527,5818372,4913732,5757546,5932451,5871403,3838809,1513629,5993119,960475,4481947,3211736,2924986,3927352,2134466,5016460,2296609,5859170,2731314,6064019,1825593,6065249,4264336,5379979,3526580,1693085,6068023,5143361,369897,4364321,1581229,4665214,4015449,1399173,4177774,3785314,4554700,4625740,2945630,6063478,5618524,1023850,6078518,798076,3718295,474819,6083161,6070641,5552709,1343553,6084778,6085066,4387251,3023333,5752719,3764965,5881795,986711,4408329,4892753,3114639,4469300,2697831,1425689,3354539,6090597,6060412,2708608,6092769,5052149,1926708,2068082,5986878,6070997,6097064,4973720,5934760,225947,4969045,2556478,1915547,1764881,5447026,5428528,4382098,2175165,1185254,108374,1565050,6104994,1667278,2659189,4766819,5413035,5233676,5729511,5528751,2029602,5079734,5464787,5735244,4773996,3940080,6060774,5565497,3811872,2781271,5712163,715158,6021196,4918632,5326103,2866665,2673694,5311984,5698517,2544036,5235069,5432982,4099274,2927848,6120882,5715121,6122402,2391589,3016213,6123785,3891312,4735801,5974291,3292340,4888649,3398752,5315802,1567205,5114477,5997808,6129331,5656742,3414374,4014082,2247429,6090268,5006639,6132052,2560974,6023578,6129822,3136936,2659699,6135157,4969459,5170255,5953206,6126838,2522688,1043773,5575829,3636427,2513573,5986981,3019198,6100888,1307974,3424452,1159500,4700782,869375,5511389,579692,250610,5578403,222329,6146433,5924160,4910495,6122034,5537977,6146864,4790948,6105879,1845238,5811975,6149891,2666162,6150423,6150521,2800591,935018,6152440,2015579,3974123,1431308,3903827,633961,4694807,855475,2920614,6155861,4759923,4509338,335713,219153,5525590,5412598,6091203,6154255,5626605,126357,4909335,5237917,3804483,4108376,5495976,5649016,5929408,1727703,6180359,5686597,6118559,5486321,6169191,3890386,6172237,5721368,6173146,6105278,6142088,4811897,1219368,5326461,1652945,2392473,6174669,6174953,6175353,5120502,6176141,5478400,2334349,5948268,1258509,3735796,5322358,6181692,1870790,2525633,5523968,569302,3754585,3343130,2155187,5667136,6185637,1179689,1837779,5896372,6190279,4451856,4267929,3517480,1037405,6056131,5640201,610668,6194204,4871719,3658475,5606219,4318128,4998931,3898725,370359,1213793,6158440,5962391,2044302,6142109,3535786,6199879,3788176,4139465,192389,1803154,4332304,1440861,6202258,6202899,4482493,5699715,6100314,4253317,5856591,1658810,1487188,4805056,1496972,1988708)
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