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 (7089239,225905,7087119,4642090,6503010,6336921,7026461,7090281,4536269,361190,6728958,6892783,7060877,6444586,5882886,2983638,3426926,7096852,6260170,3198960,1444227,5017954,1529127,3124879,4358721,3098768,6164252,7091492,7101292,6918962,3607214,5421094,6791841,2364163,3631118,2012163,3158709,4958167,5059058,2046408,6054104,6713645,5642332,1382970,7112172,6293961,5887653,6556253,4551325,866716,7117586,6450386,4388099,3745677,4512130,6365633,4383494,4774678,3699999,3426424,6383522,6150065,3881153,3687911,7123966,2102106,675592,5809681,5837395,7127433,7089006,5961999,2845306,3859410,3986320,6524336,7032678,1080633,962793,5666965,4135151,2682394,2050772,4108345,7095230,5892825,3993264,3654508,7119534,2405757,1968203,4139179,4777141,5804931,6766077,7137796,5888946,6625002,4350650,7126347,1729567,789213,6952825,6650397,7015346,6798113,1113426,152544,5464291,5442453,6942690,7090961,7091498,3199857,7147570,6445776,14467,6861864,4816518,251311,7118674,4707214,7149580,1376444,3940749,1084774,996375,6539857,7117623,6836791,2633673,2868071,5157484,7011552,6839532,7152555,4697187,7148506,2489715,6092916,6023039,4233981,5129128,902885,6676796,6567801,7128699,1393043,7050691,4002290,4307142,7154348,6461179,7097949,3334020,1808808,3964619,7019069,4515743,675216,5715550,2491685,518923,4810639,2099581,4818007,1852038,5922876,6494594,4669984,4936409,4025404,5587436,5050744,71319,6758862,6908168,7168178,6673695,6200193,6711162,5335560,6086077,5964892,6067842,6136470,3122480,1431515,7002974,3724610,6885046,5852268,6613365,5655766,6658209,3450823,1525241,6695156,4038449,5956891,5414805,6168831,5511084,6169276,6666894,6110822,7185154,5042484,7186143,4382404,6645332,7186627,3588876,4234315,1901265,5025845,4459908,7188335,2141407,7110178,1207701,5559226,7116920,6597644,6376299,4555249,1666071,2915529,5020064,2557041,5081479,1097347,91813,6868910,1927794,5821508,2849016,4962172,2883338,6685357,5378816,1807662,7202747,895429,5990875,3821602,4511297,4138841,6934674,6055277,1550692,3123297,3838142,6337578,2851949,7112029,460825,2490877,6582099,7211349,1281736,503125,7186403,5953061,4341053,6516387,3757407,3472768,1199001,213042,7184194,6637405,7166684,7205698,6069191,6181457,5666899,1464870,4749396,7144327,809974,5787662,2376071,6892471,2335364,7224745,2132157,134824,6279535,6707901,5823275,197591,3294560,162414,5946651,6876535,3499258,6904573,878891,1551234,7042812,7074716,4712324,5625096,3049658,3049469,5050477,6604502,2164770,1750620,3409988,3574214,4843434,7242886,5034414,7243876,1699708,117544,7200195,7242673,7107192,587406,5052772,6274831,3091275,5726823,4937914,6846529,977145,6598827,6706875,4182595,7142899,7214740,5447028,1185576,6418343,7252771,7202421,4735781,6095282,1677264,7230090,1087908,4644178,4402818,7258162,2050155,7251105,514156,1553132,7182939,6850627,4825869,6800182,2990728,7219948,3063482,5559423,3757475,4564505,3573539,5129800,2635418,5746969,940229,4606462,5581944,7266898,3757374,7269494,7269957,7269901,1247575,5435253,2933468,1583209,7273299,2198103,2752442,5647005,7274562,7238873,4208785,3551483,7024125,7154103,7276435,5602136,5485992,7278326,5087175,757853,5740676,5157510,246886,4252837,5157859,3658307,7223246,5993854,5586995,5612210,5596765,1364752,2081462,5263291,1326907,3084842,7195672,2567513,1599512,6227589,2292650,2175857,2880968,7227903,6160431,7301197,4165235,2128414,1266776,7301976,7303177,4567690,5899066,4740456,5904789,2126785,7246792,5305863,7306999,3422229,5672455,6543373,7308982,5711908,4425633,2195088,1298921,7311327,3058905,4034353,1482714,7312744,6078745,4920324,7159699,3827134,1332934,1047788,6906471,6597726,5695018,3429323,5679818,7314587,6027185,7108418,2269611,505931,7321397,7149408,6200592,1344550,5733219,3512854,2543730,3776604,3682535,7325736,4480179,7326387,7152488,1026363,5184616,6913568,7091177,7326923,6245546,4882979,7330685,1053384,2628921,3083022,5134589,306155,6510058,5700854,5740498,2936329,6115222,7078609,3475043,426266,6853939,2762432,2251250,2013403,7338587,4283607,1318249,6417154,7215982,2792270,5234908,363603,7339889,4102371,3007613,7268658,4106681,2054671,5323084,2665606,3822090,7342032,5121002,7229276,6372270,4292649,6540869,7335557,7347997,7255748,2997574,5746244,5705270,3577705,6516752,1167340,6903761,7314848,2730688,7354829,7120293,774236,3887847,5359329,7189851,1697264,7335194,7275107,3726947,5431826,3956909,6877651,6188472,6843526,962941,2562564,5715508,4875916,5730923,7115278,429604,7285616,7127982,7234536,4591364,7200613,4120731,4696127,7375043,7375075,7366209,5491311,3995239,4313992,6741013,7379284,1292914,7110992,7173788,3579574,49329,2578823,7151011,7383420,2054279,6704975,1645444,6326148,4677943,7055379,6581571,3826115,6655725,1828314,7348763,3429430,993191,6805576,6543956,2787053,5891398,7342539,2327963,1624415,4326515,7392601,6824588,5487192,7393665,4776477,3384193,7117360,6474793,7395676,5322185,7396306,1980859,7399361,6401656,4597686,1276759,6664874,4417567,7401789,7353857,7294647,7371347,171520,2165980,7163889,7405034,2955708,5562072,1055786,6474426,6882762,2631204,2028119,4558087,7154604,4712391,2180100,5890258,1994148,4444768,5117137,5093896,6936793,4975934,5089182,5012866,2226401,7012793,2396502,4439253,1820936,7414861,4363958,5635885,7417921,6008656,7021667,589259,6854832,7419939,7151892,3949639,5738857,7368986,6735185,1828136,4214184,4946766,3588044,7422799,3558914,7423724,7077079,4934261,2873994,2202856,7427232,840546,979517,4541597,7429828,3806426,5482177,471384,3704652,6520425,4331486,5082294,7400399,2305545,3386257,4322034,6690233,7438967,7439417,2075859,4572113,228031,1179377,4136240,1515111,7444285,5494365,4992953,2800939,4157666,7447711,7420537,998043,6269044,366528,108915,246235,7162598,4884178,6659144,1841181,6640606,1935753,6308316,4339590,5106932,1450763,3758488,6450624,3616854,7453929,7452956,4287267,7455141,6080081,6576252,1373317,1093448,2452210,7038972,7444953,1398499,2908590,1240075,14894,7394384,3201403,1762905,2406799,7460138,3364220,7460974,1290545,5990939,2230051,6386155,7463772,7465246,1681337,1591136,902012,4516609,2559094,4996405,5809466,3668541,7469225,4623602,7469861,7470094,1331773,7459656,2603739,155684,5011384,7475009,5603667,7316411,7434443,7175327,2331411,4363434,6528585,5405823,1447257,3216060,7479173,5623899,288609,6631751,5862522,4385310,7482114,6803031,6526722,902109,6874714,3273991,4782478,7462165,3752379,4136777,5891338,6542660,5208378,3605508,7087737,4615851,4533917,1045595,6530695,7491077,6852587,6565838,7495192,1564730,7005368,605328,7050245,5420466,7498496,6268764,7392834,7287267,3572842,2502106,1933152,7485966,2975684,7361285,7474596,1403083,7476648,6442566,6688801,7507308,7507791,6878890,5507681,3547621,4730816,7502860,2678168,7483855,4675404,3307007,7033163,7515788,104427,6411656,4389456,5764105,6029053,7519707,2909571,3724404,3369315,7100079,5093505,974040,7476668,200987,7489015,6629704,6255002,7531677,7532211,7532596,5137570,7140657,2637217,6193296,6133725,7535142,54606,6243820,4352312,7374677,2968765,7342249,1302888,2822564,2614814,3301722,6147732,989615,7277846,7103294,4370921,3286661,4022608,6570821,5902006,1071516,2124732,3373622,7518561,6819009,971229,7090389,3450569,7552277,7483265,3074082,4927657,3139545,3586343,4558797,6398022,7311826,6762917,7047768,4801013,7080360,6909014,6275663,5444618,3186742,7554944,7391812,6771221,7105973,854183,3339641,7571870,7536373,7016050,7513750,1755715,7573043,3429748,5598376,6518118,3255071,3857670,990159,7003379,3618354,5006067,3822467,7543076,7484077,7577895,4575605,1309332,2974642,4636182,7070779,5204741,7375520,4704607,3308219,578739,7571052,3317706,4396347,3473184,4258928,7574487,5433342,4530461,7584654,5080787,4569549,7540143,1329019,6411264,507078,7388196,7591106,7485860,4279155,5359449,7033667,7599615,5712903,3412376,7110799,7196084,7602107,5586573,3218692,4866796,5798473,7605229,6351235,3551648,7608023,7099935,4285699,7496530,7417870,4074394,7561700,7092198,3645944,6216039,5402619,1417670,3520634,1041958,4325878,4582726,6092128,6893549,3456764,2980916,7565359,7191650,4647250,5449825,4089949,5931579,1706479,2809177,7622741,6480669,7366928,6719320,5488904,902544,1034118,946031,482095,7628614,3922769,4444884,4503016,1190965,2721160,7444781,5619232,1205762,3070406,7632699,7629331,6412861,2777687,4516845,7637529,7271122,4871899,1938803,7641745,2879540,3729508,5821253,7517192,4369617,4530440,7616989,7508922,1601580,4226702,552942,2083396,7245569,7435357,7631550,18858,2880449,1018562,7647772,2793551,4593160,7502687,2658449,6171247,7651019,7137705,4494940,7583855,313221,7655380,7375173,7205767,7195769,6195965,7533039,6224646,1911755,7667050,7511861,4451566,4607131,5614045,6293672,3352675,5914022,4366482,2740307,5847118,4637997,5672339,6656387,3545094,5573294,7671116,842865,7648695,2458756,3249323,5117258,4375107,7216119,4167296,5702029,938859,1428281,4455630,7685851,179285,5538830,6903217,2885376,2110961,3296266,881712,7691266,1215220,7662267,6500681,4197250,7116109,4962585,4064930,3511656,7170785,5280499,5172820,1625534,6200513,6515166,2483271,4383439,5371102,4334685,5073365,4612493,3656855,2444400,7699136,872902,4012979,2704032,6271199,3604045,6219523,3765683,3173214,7518348,3573626,7677773,7704517,3658843,7223965,6720559,4620433,801951,4069931,5185442,4086194,275221,7710482,5745722,1500229,6939031,7046249,2315212,1066820,7583870,5317357,7714884,2407269,7715987,7132474,5568399,6377539,7132713,7154130,1305718,7404323,2729910,6666253,7718778,3218902,7702192,1358684,1403788,480894,7648922,2550940,1296166,2478392,7724286,7724503,3083783,6932398,4721115,7727270,6928142,6298854,1531290,7727580,7727885,2462652,345342,4844323,5560091,7656887,7731318,6633221,2530791,5194223,7733890,7073063,3216913,7735186,4031918,7737081,6929831,7503585,4040845,4859472,5575776,3229534,7740715,2910546,6828663,2879539,7742259,7743022,2951976,955091,6547231,7745767,5651422,4382972,7747324,5080995,5030124,7667596,7203651,1378651,7737097,5045833,5480599,5838209,2018745,6177938,6704736,5571327,6776842,4790121,7756050,6378237,1126021,2364686,2335930,2413068,6670200,2061480,4440133,6060997,7666049,5443558,7699973,6915592,2363627,7731905,7004796,7704615,3958148,1417245,4904548,7765592,6558299,5821790,6054848,7486680,7383789,7767213,2755279,5070050,3795043,7518918,6350878,3585940,6704158,4372851,7654026,323191,7185786,7775167,4671443,1876248,7776953,7180274,7360035,2471170,7780391,1056159,7233953,1069571,7513078,884412,6692816,5121292,7788812,5127716,7719516,6877721,7337701,7431017,7793661,4879533,5612484,1733538,5607511,7070542,695054,7796919,7293637,7799072,4996744,7558997,7765309,6011718,7277121,7798502,6901259,7101158,2275286,4961987,6416906,4692225,7764752,2848762,5499403,7236077,7171962,1852067,3027437,7239049,3292304,3452571,2309498,4792376,7803208,5754656,3030926,5500423,3805070,7746166,6891099,5935388,4753407,7443017,3418256,5612562,5841205,3845340,5075368,5919431,7821164,1914356,5986573,5922774,7823245,7825287,6684767,2146823,4488995,3521631,4784199,5787185,7830453,7830894,5846366,2588479,5902284,7767211,7798143,7653157,2801559,7834314,7836620,7473473,7432003,4925094,6005857,7552873,6115394,2646976,81408,894233,7453494,7553302,7841202,4013522,3929051,4866187,1937429,211425,5360432,7794691,7604957,7846411,7824200,2749397,7716338,7849302,3499477,4810944,5428627,2263119,2218448,7142742,3903589,7231645,7682767,442351,4699294,3147248,7571171,3861965,1116068,7447618,3293148,3126461,4067967,7022222,4110172,6793470,3180249,5707534,6767395,7204831,4210756,6126073,4120764,6800303,6614992,7691791,7717542,559299,6614288,7636842,5400096,7621459,4894655,970042,1164799,5225332,7339508,7873070,2517730,7873510,7342835,7874476,1060036,7875247,7697209,7877224,7878037,4852070,1365650,72717,7882355,513414,4832300,6212742,6151613,6889435,6660601,1466614,5909376,2546174,7210638,7885599,7885922,2452792,6057346,7714275,7509986,6350858,6641597,7827870,5624688,2469133,6567949,1318581,3989931,7825550,7064420,5241934,7479587,7903318,6616455,7205436,3126750,7804786,3597501,5959905,6045117,7908342,7759777,6335538,7910727,2386745,7250278,7911832,7776604,7913235,3391524,7907834,6108661,7856651,4694364,7914368,7478869,3869255,2769977,6047611,2533734,7879464,7916821,4479484,815408,7138234,5874878,3647167,1356754,1486510,7699661,3318915,1212017,4990485,6060011,172677,2320701,6631827,6719277,7515891,5901994,6832913,3834459,7285383,7787764,3956899,7933104,4893449,4938020,7934182,7716798,6383270,7935179,1170677,6892295,68571,5180976,3112193,4698223,6057199,7008090,1560400,6317524,7512358,2027390,7727517,7691705,1556780,7612919,944301,6730305,6273378,7835249,7894607,7006230,7511858,7058803,4673363,3587282,7182421,7130256,3046862,6816215,6352008,2237849,5996671,7578086,5273746,6713338,3743145,3730397,1895076,4743979,3043148,7903798,1707828,5361827,2929324,6514231,6310582,7360870,5932364,5354574,2508038,7890197,3331349,6412780,4305436,2079029,7964224,3745896,1309401,7966659,7946602,7931814,7655687,7969405,7923915,7123216)
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