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 (3160820,2999152,160015,2888125,3251191,3243186,3252048,1308589,1374060,3161899,3253781,1655482,1218689,2396411,509959,991191,2015914,2737811,1235990,3258262,1325742,3258744,2462215,3258888,3029002,1923625,3259741,3260676,3083448,3260919,2474501,3261569,2301038,3126234,2422834,1832135,3263516,1122229,1411910,2798628,3112524,1364174,2261243,2811860,2978420,3267700,91,3085479,1869280,3176975,3231319,1447867,1949808,1980051,1270317,812849,3273287,3230554,1757779,1563867,1831530,1052480,3275738,3239626,1524634,1233235,2149414,318857,3267232,882173,1183004,1141658,1258409,3279468,1143495,942286,940918,2362482,2875202,2491939,903324,2571490,2447471,1863597,2750819,1219184,650718,1321564,479532,1702691,1467202,2533884,3103569,3224404,3255713,2006250,3289453,3204457,801189,3290954,1398440,2557081,1000282,3264538,1626687,1879152,2869952,1845385,1295618,2202199,3294294,733976,2132170,1443496,54308,3289189,1892774,3297206,582962,3298275,660826,2878151,3244770,3290589,3299254,2732405,1341773,1264703,1690870,1971013,242274,3303632,2758839,2851034,646733,2669614,2829944,1565754,3275167,376873,3000589,2032413,507512,1566525,3308692,3308885,2528697,1705922,2354,2586447,3154464,3066467,2411861,1870068,3312862,1317271,3313173,1499019,989329,2119066,1382297,1150851,2961387,1024622,3315300,1903108,1784001,3316031,1833421,1909118,1548981,3222535,2147142,3056507,1195439,2306536,3319426,234922,1737225,2843243,2313524,1702964,756399,2348901,2509837,3216873,1819942,1464409,3210864,2410644,3321551,1774819,718050,2419570,1832985,1967719,1908417,2658664,273657,2795177,2304575,641755,3087248,2332868,2807967,702664,1266109,2948725,3337477,1030067,2047987,3339203,3339676,3339744,463994,3339122,2770373,831826,2635014,388827,1163234,3246067,3336787,2096747,2205261,2032848,3317664,1870451,3204587,3344702,2803340,754951,3345753,987731,3283685,2316486,1595070,2962956,1944352,3292015,2049141,1815150,3353412,1588943,3074624,1203222,753621,3067395,478671,3354867,3356217,1224298,3356865,392044,3284623,3080873,3191903,3245237,2162730,2909323,52256,840748,2422874,651545,2679027,1699477,2810512,1110328,445820,3336753,2899410,1216963,912450,1859954,2863147,836979,1201257,485731,3058622,2925607,1005554,3353751,1595977,3304535,2729394,1355416,3142471,1180085,1824033,3351250,781552,1529956,2074649,2362381,2006809,2627770,2433565,3161525,1553177,2680092,3367933,2374649,417385,24874,1267690,812321,1275025,1123850,3317142,1701776,1105521,3098997,1179925,2933948,3380170,2567683,677624,598940,2685467,3382476,349351,2508192,3384383,172279,3365917,2548186,383331,1029404,321984,3187464,1654825,893861,282614,3159738,1238895,3389218,1110442,1425732,593940,1438421,2022036,2075423,2685079,1197425,3392477,3392485,1245584,3389315,1655570,1720138,1919035,2966951,3313838,1971308,3396579,3396185,403875,3397522,2138562,3271504,8372,3220964,508236,202919,2715233,3401111,3373935,1540593,1652889,1283818,3402863,1659534,1425240,2608194,3255966,947083,455048,3394391,3332240,1314090,3380312,2455519,698182,3354890,3182091,2172534,2351948,873770,3414168,1773130,783743,3149650,675929,3417322,2272929,892721,3418731,3365058,3374521,2827374,907687,2204230,3231688,2001996,1453579,3407988,1298196,2948850,2683367,2713847,2634612,3423225,2467495,3424534,916657,1261942,1165201,1678659,1759901,1162233,2518231,2255185,3421698,1609356,3286902,1410608,1601790,1701868,2627659,2098059,2668545,794191,2675439,518581,967300,3378649,2250011,1246353,3290807,578454,989533,3439394,2939550,451136,3421980,205445,1709795,1934396,1565279,2727317,1778980,2647077,2981641,779420,660536,784669,2334932,1106136,862206,2317532,3448495,3448672,2705924,1210650,2771816,3450370,3434624,2852800,2985796,2763234,1306343,817142,1802967,775026,1516174,2245528,3202895,1531064,3377372,3160274,1990297,1131053,2011755,1462887,2212206,354722,1189733,1248059,3147771,3415176,3299894,1736709,3360720,2529711,301596,3375011,3461018,529463,3281710,2924386,2406882,3294617,2255571,1934111,3146861,2399935,2406937,1159612,2147096,2265758,3466795,3000822,2961817,3467017,3089135,2912280,2764266,3465177,1066501,3156636,2827885,384126,864490,973543,3474283,3325732,1218048,1189215,1199662,2750094,1078084,2837260,3431997,3477672,3477805,3128670,2800186,1290164,2073039,2425544,2791120,2908528,2246612,2853128,315683,2252824,3375665,2232321,356759,1197113,1760237,1385866,3397830,3409877,2131375,2872678,1296250,1112633,2902518,3083408,2155976,2756371,1360984,3495266,2141397,2714035,1714127,2407531,2948305,1336939,2757036,1940138,3498565,2968505,3499110,3314774,3500102,3501236,1245315,3423196,1709417,2789171,1410654,3358927,630598,3503464,2466704,3398957,2898694,1721073,2851854,1933677,2748059,1255016,2205515,897041,1648459,3507301,1462770,1306046,2931840,4491661,3023841,2825079,1530742,1842796,3284154,1950768,1048138,3509658,3503380,3510901,3447696,2734550,3454889,637242,608388,3462964,3515162,1195056,3324865,1006201,3516792,1126637,2538311,3403833,677418,2692962,3056685,3098408,3522416,3282440,3138505,1793886,3401342,699850,3179475,2463642,1895553,2637416,3482533,667657,952711,3478087,1861291,860635,3194789,1321025,3527108,3015019,2158274,2689597,2132646,1466576,485575,771848,1158459,2724902,11301,1908314,793365,3365101,878267,2452982,3288091,2145846,2683399,3533988,3530774,2452289,3535671,2331592,2245872,3537287,2640953,2724507,1204498,3191463,3541035,746655,1216516,208713,2702708,1084875,3543027,1762039,2659690,452038,3545223,2428622,3245390,3376836,1606128,556014,3476738,2876613,1170920,1129311,3149635,1078678,2302897,552135,3174377,1027217,2642553,3450921,1126127,3556082,916236,3146304,1938385,2697954,3557786,2999762,274405,3561101,3559830,3535426,2826447,1679863,1582712,3562324,929391,3508996,2115016,842056,1213644,998060,3563938,2592835,3345413,2797066,720988,1536933,598591,3448183,3518621,3567164,903845,2998306,896471,3567180,1755108,1246076,2427856,1139484,2587908,1849758,2216108,3574473,3478869,3526887,1395863,3534158,1815152,3558700,3474965,363855,3432106,312853,3550995,4102299,3195281,1440105,1935435,3529046,2692219,654628,2112340,2856065,2918982,2875764,345737,3582822,2367406,3555462,3583360,3541377,3543981,189599,2856041,3473279,1555710,3348145,1569588,2843614,2705941,395258,3229506,3461480,1104696,2044940,3589951,1681480,1876290,3501059,3592193,1553656,3585831,2558662,2955896,1406568,3594716,1014005,3457769,2354443,3369008,693538,3099930,3245771,3029262,988717,2338858,2713857,2761509,3601374,3538165,3602631,2057387,1251377,2055485,1756020,3588704,3288852,3527820,3277606,533242,934257,3607128,231397,2194330,2151205,3581920,3608848,1805756,3603246,3612639,3552237,892629,1876508,3284318,806521,1249581,3518672,3361117,3611472,997248,1261394,663447,3213103,112744,3609249,859478,2147606,518195,2793896,1336885,182111,1657827,1013719,1692695,3545969,874482,517868,3588346,1274172,3175582,3342662,834719,130559,927827,844965,1409903,417902,2729895,1176166,577234,3569367,3026079,2975245,745979,3625486,62076,743761,440062,2379498,3505718,2457774,3474852,3397760,2710064,3640235,1189280,2489502,3629533,843621,3613886,3045200,3648624,1818924,3582393,3650408,3648895,3375868,3650985,2767399,2706173,1478167,586051,70801,1203745,1323517,1494438,27678,556997,2768794,3656973,1523238,1854333,1264171,3013816,155581,3657405,2891598,869790,1145936,629685,3187838,3527043,3662688,682632,1863201,1747719,3655057,3564167,1699961,1759796,3665420,3665713,1994865,617466,3449552,3431854,2948388,3420655,1248779,3317704,1450401,2020801,468672,227299,2766893,3562196,913914,1462479,1424233,2328443,2392038,2177538,1337075,551904,3363919,1635646,3673414,1535443,3173818,2491049,3060739,961688,3311827,2079518,3480234,3648312,2235793,1643204,1055809,2699012,1419280,3139711,2839146,3556361,411645,1773471,1550947,2909225,1909339,2065336,1383511,890753,683918,3672851,2869270,1433115,3683151,1812851,3422501,1549792,1839951,2175052,249068,529160,863177,1913719,414075,3493675,3691961,1622940,830905,1612788,3680477,3623509,3694018,3474967,1555779,451480,1747457,1964113,1740705,2261273,3578196,3643513,643150,2577151,1629907,2595974,3700608,104950,3596380,3701270,2566157,284240,3638633,2780230,1159869,2305885,148998,3613064,3694356,2605733,1763356,2423110,3693996,361833,1576085,500501,2827214,2697944,3710807,1074179,2799439,2795298,3626369,3713481,3664123,313497,3185233,2228632,2340818,1751865,2209909,3397166,3716957,2669716,568052,1390616,1492867,3693167,3706707,1983180,2768397,1644614,3720737,2279363,1424695,27497,466722,2689414,1844324,1261447,1916893,316448,3640217,23423,3630907,3704347,3729632,2944059,169889,968861,2876498,3733188,1371211,497753,3400391,503413,1797307,3505187,2479919,3737446,2021763,1779702,3738548,3739275,1467926,3465201,44853,3364397,2517106,2925994,3741235,3617423,3693159,283863,2737033,1016784,1250301,3096964,3045103,1147330,109525,1592638,74134,3746545,2180360,1389394,2906759,2059662,3754037,1090492,557067,3734604,2464351,821995,3381500,2224777,2187548,3746883,1944234,3758460,481679,562436,3733169,875343,3685847,188963,3313187,814730,3379939,3165925,1725913,514389,3158988,2236778,2350351,1420186,1165189,3765908,3766015,3286982,3405728,3523441,2240735,3767558,3517409,1190665,3732996,3768750,2058324,1519832,3009937,2792639,3668576,1244455,3409814,2684237,3772470,1657228,3750839,1202527,2804383,3137631,2527001,1694348,2700271,647107,1779327,1868084,1105912,2677461,3627736,1377135,115822,759880,3781413,3700636,2767846,2236815,1754020,3767722,1386327,305118,3250500,3551574,3124047,3787488,3787456,486561,3695628,1483676,2328259,3789024,1547717,3791173,3787646,1426388,1211692,3787813,2804992,1804678,1571781,3183865,1320581,808404,3786422,1518183,3326925,3588406,2102559,1349259,1009075,1761005,3792245,2824542,2200760,1163717,3255914,1324850,1853322,2980864,3253017,3799591,173072,1079728,3449335,1938314,232812,861364,2166409,1870232,1093223,2812713,2067809,1631373,3789097,2112745,2818068,2638310,3638183,2423758,1735672,3792111,1469465,3220905,1573209,3748315,1797679,3762536,1080762,1694475,2296325,1428922,3818839,243238,3027022,1270861,3604098,1193596,810031,1814881,2366099,42366,3314122,321829,3822466,3761832,2122084,913858,1376208,1484047,3825440,1841052,2593037,295783,3826966,2131286,2509715,3831052,3430726,2576831,1775763,3673221,2731084,3806720,3831597,3793116,3835779,1445444,1231853,3112727,1710825,2106567,2963467,3839572,876211,3751955,3742608,3838820,3025845,2513110,1920641,377756,2933210,3380439,3258210,3521792,1339137,3846103,447607,354979,3847096,2137778,65967,734154,283538,1445818,2797493,808700,994206,3600483,3174460,2596983,830583,3761224,1854709,1059832,1151171,84940,2087628,3810411,3832512,3320134,3763557,2704885,2988904,1348109,2981488,712997,1391081,3527676,3232824,1085660,3184922,697745,2667173,2477287,3861617,3849881,3865814,1613360,564540,1845404,3867065,1350017,3867895,3742158,3868961,3857957,4969827,2910721,3870524,3815491,140903,3754255,3873903,3857330,3767481,2419808,879553,1741137,2237445,323422,3741831,3376064,2450212,1571826,3881051,3821981,479020,3883242,3481884,3813455,2528884,1320912,2572161,829252,3888076,2976970,1218602,2186753,2401556,1561269,414521,1749583,3672658,282144,630046,1090614,1412209,3084722,2436546,2598279,2511306,2744726,3042109,3895347,2216555,626796,2027813,2902950,3002448,2931930,3900229,4794,1250092,747709,821484,2131678,1279094,3902720,2344937,3179989,1863415,3120446,2175846,3903285,288980,3080029,654953,1977897,3884413,1753412,416274,3251645,3311821,3882124,1219414,3908216,3754974,3904331,3422175,1812066,324553,2299269,2221214,2389775,1467284,3095201,3394889,3703496,1628555,3845968,3919437,476426,672229,3920287,2892314,2211051,3918267,1738580,2147017,2767208,3542285,2979958,472485,3525159,2825436,306719,2222946,331024,480007,3868060,1791534,3479119,3931262,2357918,3559010,2009857,2180366,1007845,1496443,3916384,172920,3636563,1306570,2618275,2010838,3388233,783364,3716830,3928985,3784949,3776323,2877982,3939316,956435,3940696,3923257,2893712,150246,686184,2907250,912359,3477734,3946724,3944484,2256812,2136277,3830925,3949544,3306718,3937900,2832673,3248008,1525995,3952416,358850,433940,3553031,1878073,2674857,2651695,3472070,3919155,3956579,559940,3394919,3869145,3925991,3557231,2587797,2139789,3301488,2079062,3683302,1801837,2813589,2138244,2946352,2824363,3465182,2912528,3966416,3857172,3964504,3855911,3615209,2672913,1217150,1208142,3965308,3149020,546775,860566,1062334,2237411,1800283,3180645,3452637,3906864,2714971,2403000,13604,3974795,1935009,927477,1611539,3979844,3980155,3861896,1868154,3882533,104315,815930,1350162,141398,214960,855050,2169862,1652954,3037484,975724,3973077,3985124,3711255,3955248,1600778,3206062,3938986,3988231,3920517,3169424,2773761,1238164,3503502,512623,3071668,1649804,2632266,535617)
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