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 (383,1870,2057,1892,3063,338,4541,716,2796,9021,10204,6223,4660,1143,8883,13646,9191,16485,2077,18866,1965,781,22249,13531,19207,11206,13209,1782,1053,7581,25459,19863,27221,2289,29493,1463,31092,24975,18676,27789,208,9936,3153,34051,31274,20055,28717,2006748,25538,2099426,15537,1169746,3594,16511,13370,13227,32809,39992,2273,39431,13064,18631,21197,42974,1311500,47540,41968,42546,745,24386,50299,50899,51325,51710,1007,51133,46387,47733,1491,40347,53390,46461,31985,18505,27478,57175,61632,53543,61793,35364,21499,49217,57757,29595,23903,47450,5287,33707,55072,1492,47895,34590,40443,70871,62544,59808,12113,68507,37346,17174,39058,74089,62571,77821,452521,13543,42749,29553,5222,2469,81132,54248,81234,27012,39677,4465,1630,2915,4500,11410,78351,28494,21209,40676,67482,1390354,4035,56763,7734,31317,38663,46428,45799,43496,2701,46418,94688,22114,71366,63309,17732,81658,59067,447105,8945,698,99250,63514,92692,37472,2684,67366,74682,15533,64895,103532,37984,71808,72109,78550,30105,17324,111283,105804,9106,49027,92396,112500,96326,94303,28486,64062,30850,109826,94897,11507,79891,118958,119325,121255,90316,15673,91671,2623989,88739,54815,117792,61164,112431,127578,54564,432226,17413,7450,106979,59242,131717,131860,39532,70353,132351,124479,91377,6486,56952,126912,86452,53658,117386,133535,23234,25749,102289,136349,2386,13005,98975,63235,71896,13198,87234,141597,82118,125737,127549,75214,107004,130127,40568,139010,22061,118856,73299,106467,125491,116838,96389,152387,134212,13930,140827,130640,146438,54956,155167,13281,114916,157704,102543,566129,91165,7586,56613,148978,161570,155403,103739,162566,99013,67009,12291,136328,148399,145349,57495,113094,57085,121182,166132,122755,25515,95612,56242,61342,135435,156242,167361,20336,154157,63679,170479,132396,32484,159793,102533,26457,165589,5798,34395,136999,132845,123269,41596,37418,41718,117802,73831,51880,148634,35378,170671,177584,24902,185097,183120,23368,83418,67047,80701,188283,95463,53094,180718,73593,22656,84399,85900,9382,76777,57883,195094,2695,142668,169437,196313,193493,44741,80280,184685,74998,82417,193128,177367,161554,59035,22514,139696,74764,193001,8206,206882,207557,157705,208515,178060,208812,212152,91612,182982,2443,98145,182714,165579,18664,122589,171269,50391,7345,128969,149458,257581,209359,42820,177931,217546,131050,59438,41956,164901,212555,101015,219572,154264,218140,110024,87973,107166,118160,192686,169651,1366,229787,175029,104934,145179,167114,79078,232477,69673,190623,151150,208582,220475,131930,82625,157663,237974,17320,240251,236222,178271,93955,108714,82005,124110,4012,180385,241755,29809,2147,221814,122607,209507,58635,247902,8446,196185,163173,232957,230636,161805,20893,125784,234638,54746,256566,231398,166452,258304,193982,160527,131140,252579,6266,220594,261377,215679,161257,159759,30874,224771,96854,233522,28802,43118,231178,67579,266771,244675,264843,82733,60824,268018,265195,444976,268336,205543,213203,31897,1178669,268123,35245,127893,275271,247334,14250,74260,253795,149303,134387,208339,151937,102242,238384,199140,118854,41983,265260,281723,282021,238919,187668,51330,216961,51090,270287,48402,286881,115988,59492,287943,193256,193404,287140,207776,241824,289232,170931,283739,114226,121747,29502,166844,59753,279631,274752,293135,192958,68283,234593,57185,87072,295433,287947,32432,191332,296207,18771,135852,2128,27596,179404,128463,8959,217476,179014,128028,2618921,26931,194445,14637,121075,14955,301848,74393,248981,293508,25029,256793,11926,225537,307930,300713,274517,38140,309637,310242,231999,237363,308316,119540,283515,301121,179629,313600,313838,77546,314686,181940,287297,199368,317628,247041,146898,66549,319695,314975,312124,294918,249618,155861,12034,229269,211223,222515,280630,24879,134658,199567,193702,113436,441833,328988,186616,80410,330035,196921,259275,425780,304838,2982,335320,110368,267631,337224,234482,275092,112451,274904,277256,293407,274402,280698,342225,25418,211983,166556,797,341633,318432,2177867,14357,13852,348425,161746,326284,271376,37298,289011,308942,250498,14606,275807,233076,302032,355984,160950,231536,254896,258355,318053,138757,279580,354297,225312,337422,158584,359846,359944,125123,360424,56541,345148,153149,233098,273178,365529,330401,365975,358762,295339,145567,238030,241022,87015,368186,268088,371635,350890,38055,372699,120243,375211,13216,56472,209803,237073,203104,378561,32775,2753,377118,410636,378988,145117,350044,126916,381222,276101,180420,237140,386123,296176,175562,330813,390014,221819,172029,380038,256062,169037,123111,254882,330561,370520,378978,374647,397706,265205,272445,386701,392546,181165,373841,324496,242388,26349,315537,400839,285178,287424,50394,402823,402922,403010,188264,339246,236888,299216,401947,210778,124982,423283,57868,406927,407600,401832,399815,407315,251589,408676,408711,362928,188315,410570,169150,274078,14860,225240,409990,324922,383940,85178,756597,349620,271697,373249,48348,204955,267831,244296,49032,95103,408079,112696,291224,73007,410647,257808,429913,427150,433941,394410,14902,395239,437087,31252,382588,223876,197197,408369,439970,289276,139656,249699,439383,432802,6345,443409,272501,368259,344725,445783,425756,10608,43513,446483,411802,425749,130107,163186,418031,243225,389168,51178,228372,80840,156061,243480,5077,277716,425646,118211,268426,334455,446137,236215,93613,4196,239241,107642,276989,328048,186808,413843,143396,193653,426,353374,231844,266333,461841,364786,451963,266564,154227,464733,464608,213615,441337,384108,301154,1515117,467766,364897,239411,469319,160393,413127,265767,124266,473063,362158,268803,305530,235633,474610,474626,2368,458989,475334,354992,453767,307006,341311,477967,444794,52529,41360,191362,279317,106261,59279,119253,363829,366447,458437,110603,280544,3834,144268,434696,371623,174129,278740,26192,486739,69993,492512,101999,314310,398212,249158,15982,113718,382305,214892,218640,483609,2320035,499582,32944,497142,179669,248417,380451,275653,501527,426051,67179,266255,503307,206855,98575,46634,95944,446514,320460,297373,482696,238350,429435,225262,74415,183717,495865,503434,509704,509814,459636,191761,341950,65696,511879,492307,12779,469855,473423,225767,516567,474251,508410,973288,233293,518414,518438,323339,319721,519610,132981,327293,53884,519790,136475,523986,483965,366410,161410,26039,90322,466694,459176,527759,56631,460329,239036,151200,529386,314784,257583,501113,476412,254797,453821,233427,67063,239362,319611,522234,368472,301329,3151981,399317,498407,331439,253705,540705,539885,459543,414345,279973,427106,133973,524667,546831,56621,547616,28586,350061,527706,465546,551698,283933,299196,487567,224988,388182,147381,555032,555627,104659,557625,250346,558501,470535,530958,335717,561969,466646,363297,549859,254428,30038,565932,454097,101419,546645,568315,523598,369618,483026,313421,197018,529690,237483,555384,59730,571120,476048,571587,449310,225239,462011,82159,117638,575602,311352,266176,247462,543493,482489,206885,343314,574226,9536,482864,514382,582897,192892,106658,463304,584712,587082,91593,358438,271961,589057,489852,323620,76705,143378,532498,399649,145714,124475,384598,300664,593114,594925,505808,389569,440336,407278,596942,28871,415973,452006,598612,484593,400646,599472,599594,22076,601647,600965,325403,318219,418055,604468,531840,297050,570598,606552,20003,509060,515050,609997,108340,257980,611211,341255,241139,458960,58755,564449,387064,476298,202036,471244,519037,207646,209536,457392,1444475,479794,556049,590198,4924,365985,622470,624268,111934,490591,171950,279644,372284,428702,132599,347857,581580,231463,629296,629665,317739,448195,216636,634790,285712,516805,376290,289333,445000,428632,46064,589514,65600,615847,545132,636224,568518,130929,625200,618178,643546,152004,96537,634486,186789,419299,430112,339698,565840,217071,352344,646239,647287,396216,608455,215997,77318,26,650728,486720,219811,126353,474258,384994,653169,584155,385559,641781,200894,533356,521259,333786,448413,382736,653770,661601,352319,5651,467172,664643,249487,665466,99901,548744,217288,666852,388267,637648,459987,668900,500959,295148,650590,135952,673973,674342,619990,370238,402089,577167,679127,22459,681917,410560,208670,233839,207335,677014,684845,505292,270322,478064,503783,640517,686776,522432,624165,287454,61505,574911,639493,629259,58186,691810,26310,692127,59198,341895,693115,384670,569085,698061,696932,186611,221061,2491266,700568,421316,701285,257356,702502,5055,594544,445267,4144,293356,434313,303422,1911486,559909,647481,121993,708887,59300,502014,709836,56332,88396,125921,711160,575187,699624,541917,690201,1360400,571270,431528,273119,41211,572586,115102,637449,718143,719231,322866,469026,606910,244005,72185,18309,710158,724317,599552,725016,373438,454834,726723,667175,475881,727219,656189,1891675,1301640,666956,363573,637515,498291,668138,610204,575111,734848,734994,734027,693908,381699,702912,737283,544716,109989,245505,616187,2683,207504,136141,351060,714830,448078,579234,719178,415404,743617,10601,602524,333283,744850,726631,570767,632943,179057,242076,99919,97033,355044,423709,696354,309807,584271,650891,698641,749688,750298,127856,207752,82856,10333,519537,73228,514773,518341,385950,672950,275561,699632,759065,400861,717483,761069,444991,563299,411524,10226,638471,758366,140100,24459,766133,766399,766350,163662,218250,616813,767698,166251,238052,334207,711926,733213,768767,455137,684442,774148,777979,770224,543743,457500,780377,411768,780965,259889,781829,375874,26140,762963,322401,313968,708506,708399,786953,3191,656552,90674,763116,305469,65928,127465,728086,771453,102937,151841,609712,109545,781938,295128,292555,791053,112232,758018,236106,798022,798815,789542,789260,800054,68612,418175,588243,554108,804530,217649,805898,806263,806269,806286,647177,677242,104200,807600,733492,476681,452307,654789,784606,759714,548360,621944,39709,482077,796608,546634,720386,428972,209199,815687,804898,485844,800828,752627,567964,725945,779199,420744,821918,78374,310657,823204,86259,272865,823807,824099,747094,695154,823738,326276,828279,828927,104452,829893,495332,221023,831966,324189,829954,124178,828649,70339,355172,784079,695874,62068,649230,148956,796039,814331,667648,289137,839290,562581,789326,266819,348183,761216,841679,842176,182568,779532,843442,659854,215600,134702,563221,649962,488265,848517,496700,314347,473804,272706,395148,418783,58129,550966,447193,391721,854884,77674,256138,828179,406543,794960,858843,798818,861271,203548,695153,275959,839246,864951,183600,184581,568939,424556,865772,129289,371804,710556,868208,426379,702326,658741,10040,119772,140037,98317,191463,561309,273792,875816,875870,219519,481065,596878,530160,354018,511265,336336,350685,355063,875912,887763,888168,407054,215904,757202,763790,536607,324827,2136202,893518,882196,495558,657723,497856,885687,697529,584315,218481,773761,897224,897974,893039,575659,232735,894432,863479,857012,664577,580594)
GROUP BY 
    u.Id, u.CreationDate, u.Reputation, u.Views
ORDER BY 
    u.CreationDate;

fork query

edited feb 21

created feb 21 anonymous