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 (468539,543492,1825988,1232024,31152,1615069,1021739,943184,1391883,1828324,622447,1468481,1803851,1769266,501675,1148117,1756407,1779407,1583121,1279200,441695,471011,599020,1815551,819014,1835156,1052284,1446154,360211,826614,961207,1837294,1837304,256925,1047592,2100044,1542581,75033,1699472,1839192,1007582,1306591,320570,1787073,1842294,180260,1608226,1670729,576857,164171,1820957,1680568,661801,1763124,1082851,1317883,388599,1849133,1000849,1831186,855705,973549,1216911,720491,1769095,1850723,1474519,1178697,59087,1828663,1075783,1339620,1246802,950625,1320651,1854460,233467,1856081,1428904,1719496,836697,1435657,1101351,1607294,1819815,882478,1334214,1378952,197432,801530,1211277,143091,1669328,1746785,1578713,1154772,51197,1735406,1863463,836202,1821935,562802,1713489,1079186,1865110,1478765,1847645,534381,1192525,1631116,1015197,682473,1867638,1860272,1192566,933194,1694846,1751550,1067141,1618247,1437766,1607544,1869671,1229535,1831293,1246758,1870896,1341409,1776576,210780,215263,1774964,1413206,1461393,1873885,1765283,1858112,1050990,1640097,1718294,691054,1876233,1705996,1824051,708995,1876601,275643,1810362,171433,1686794,981208,1869846,1184160,1135880,1813869,105037,1738495,1529267,1539858,1883547,702643,119224,1862650,1877041,1769255,128386,441907,1858225,1303993,1368978,1269357,1850300,813159,1354378,1883759,1890824,637034,975129,1819258,347172,600545,1391026,1262289,420589,1002358,746549,838405,1267125,1784430,1368973,1043686,285601,1900350,454998,1254278,1901662,1836649,1818608,1589188,1001816,935108,721597,1388084,965778,1548788,1905553,414813,1814977,1459032,1167915,675637,1810737,1286288,1729453,1906444,545418,1279976,232814,537503,1494801,148962,1096275,718414,273085,482389,237696,1915639,1134192,1494454,1464888,1747467,463825,511484,1368057,88054,1828003,876937,1922291,834002,1050658,930125,1473963,1148523,1907615,1663752,985292,1116831,1107945,1016891,1781929,1487543,1161270,1117880,818514,1893261,1928235,1779204,513340,1846508,335794,615584,785227,1080125,1932150,728797,1817919,293768,1932446,1701840,1865691,1823424,1935122,1926876,1585570,1101755,1637655,1449594,1936841,1076478,805547,256196,1849694,561817,238751,444977,1421418,1941524,1054469,1658512,1072711,946199,1376167,1943368,1677360,414934,1865233,767446,1261858,626288,888617,1356739,1687935,966393,1215291,1949279,1950042,1494037,882913,1753601,1951286,1951742,1952176,461121,1954308,1762782,857308,1051496,1958407,649810,1709658,514793,823859,1865883,1563152,67476,578932,1871124,181772,1953679,501778,871672,975183,1317295,1454825,405017,1277639,11589,1943235,1968588,1419315,1229893,1201889,952787,1748214,947756,1971266,1799242,131326,412446,1924561,1717333,1313968,1695507,1494133,1394183,1772334,1125413,1136940,726771,1400716,1056328,1501707,310575,1713859,521355,571875,1526902,1595510,1765444,1982093,47637,858348,1379746,264498,377920,1616513,890036,1709435,687857,1987501,810671,1465959,1050672,1481457,1696509,1735184,640303,1137689,1209253,1470600,1937450,1991467,697795,46183,840184,1294203,1993118,159094,1993794,214812,1289810,1866880,1995000,1118594,1376883,1012952,1058671,718762,635892,1999073,1888859,777076,1999952,1903590,1221495,1804697,446497,1196308,1313757,2002226,444118,1877534,340404,2558610,389950,1762368,1432808,1998665,927002,1291235,1654400,1145938,959936,2009630,1553886,1133286,985383,2010743,953068,446936,1161721,99989,1706355,1815759,846892,1928632,1624817,1727770,919775,537943,78162,978281,421109,2016524,1117438,455847,1414028,1003714,2020403,927121,162296,1999607,353962,1632141,14214,2023904,2024828,1826407,2011134,1270812,1009248,1524210,1212697,1404122,301302,1239953,2021671,1630475,2025006,1361315,1974722,1162831,1296340,874275,1367056,1824286,2031156,262588,1009705,2004081,1297445,543539,1681500,214048,1143917,2009713,1512126,1843860,689106,1289097,1479498,596370,435863,1653273,2036426,1872390,1948693,373655,329194,2039087,420536,1202206,1040923,640584,1578163,2042407,800011,2010694,552351,802585,1312080,978965,318752,1773068,1312478,706293,1820429,221683,1433639,517272,1185842,267493,1685448,1731133,482254,1944099,1582311,1393254,745011,2054388,593889,1505086,967334,1392136,2056340,661864,1278743,311130,1760770,2057615,1220097,2013982,1008575,1194067,2011732,1442283,2058834,2030118,2060162,2060653,350605,741933,1988046,239879,1500042,2063642,586836,1956609,1727672,1169059,2067943,313021,1048244,578749,1787139,2069643,819640,1291961,16959,1253746,2069993,1631624,1474068,760965,1873947,1742392,931008,637679,1149797,468206,1963990,1577897,1162289,2069665,315492,2077595,737567,2077935,2034702,927924,2077370,904963,1560706,1137785,2079486,2081147,937624,289887,1493813,1011882,1020981,1494928,241142,1254006,2042090,1231606,2081315,1472828,1027169,2013169,1954048,217019,538752,1947702,2064818,1815277,1023645,1832327,1497199,1927157,2042209,1485872,1631347,1218509,445303,1753877,2046540,979966,1976469,1257146,2100745,1786117,468083,1517834,1808935,1350091,1352575,1498786,1413601,731963,1274297,1602687,21475,1314663,2106462,1674995,1320374,1720161,2097789,64967,1472747,906751,1806560,1655750,1538100,1805407,1482428,1411449,72478,1239217,1541188,1807008,1284317,1899226,80164,1179312,1057032,2069983,1157812,1610459,2115434,1386345,717442,480527,1590953,10578,1443801,2118539,1992452,592111,2105584,1593037,1602752,740120,1623719,469408,974,2121539,2121686,1998031,2118389,2122472,1341464,592748,520989,1737817,907415,907685,2081434,2127607,1113697,2100508,291695,1039544,1779914,2129396,804503,1551773,757777,510937,2022785,2131106,409263,1269952,303940,1110808,1618592,2053269,1643518,1362658,1887167,2135515,1935788,1974659,1205944,1518683,85170,1109322,2042300,307614,1033713,961479,2131014,1106128,1353009,1801429,195216,1901561,1627147,1365151,442124,1495869,1872090,1935477,952310,671358,799081,1130549,2043533,1419975,359862,819276,1410118,2151062,1160794,2152670,1037948,204623,364869,1177278,2154906,2154954,2097804,1653150,552916,568393,2152781,1846044,1073828,1929905,1878670,330867,356020,180659,306074,1886411,1348139,1853263,1048087,2165533,2166357,617802,7603,2140629,608639,973964,1308958,1871802,2147954,2170578,1128868,2020052,2171677,2105258,2150849,687483,1841373,2153958,1626062,2174896,1304462,657524,1192426,2177711,2158778,1162563,1563507,2180833,2178590,2161513,1139393,2137255,1337507,1879446,2184925,1956468,1127188,103139,1933169,1948881,1795784,2056223,2188356,794560,2124179,1708058,193439,2191234,1757703,2193456,1743822,793320,1448363,1251826,1568185,80577,492372,518245,1369331,1928565,1461156,348406,1425082,2195791,2080475,1752497,2002121,56502,1384404,831965,1647585,1341395,859490,1467997,44000,1271094,1391850,412237,814194,610305,1675219,1445015,2125241,2029504,2166566,2045945,1380539,544006,1381196,544511,1679110,2190916,1022881,1193534,1791487,1047775,276327,1116836,2001600,1549727,2049320,2180680,1686113,540121,2037655,1801028,2221841,378806,2220870,1973762,1754467,1200555,142368,93691,2226150,1549562,2209744,305669,1024677,1701884,447839,568233,2228913,1909604,1311736,1625206,445845,1761284,2232470,1596880,771275,2156925,1100730,2209014,2223902,1936398,912469,872033,2236076,786489,720852,1354866,2238965,2237519,2033494,2066336,2235933,1024076,2239377,637356,634368,1807316,1035573,556169,2247526,1345050,2155859,18992,1071266,2249875,2150471,1359328,1056922,439171,2250713,1020476,1012551,1122200,971439,792549,2207421,2253628,1953149,2255462,1704345,2202734,1377978,1958850,1794515,2102437,168717,1054897,383609,611875,768597,338825,2262497,1907531,1385661,110358,1468639,1770131,1334771,536169,810860,1002744,1910558,40106,2245616,1062364,2057204,1024786,1790679,372912,439642,1308473,1150925,1581565,135889,885922,2269336,1726647,1839631,650183,2263918,244360,1786084,1184512,1763658,1451362,1364923,1109215,2278986,2279756,2212098,777052,1022333,1405433,342978,865111,1869854,1303142,426377,2285060,835806,128662,392684,2284308,1175737,1522429,601452,1894468,1899556,2290575,884951,2103602,497180,1419123,2068573,1480740,1862909,1309907,1170816,1131623,922016,2145302,1161680,2265306,1333030,1145760,821497,112196,1830486,1597552,2280296,588611,1679602,2203482,1133383,901553,2268561,954207,884995,1399252,367786,727766,868179,2311356,531966,431769,2067143,612418,2009803,2314174,1738252,2255415,1104483,2317873,1779870,1525962,1457219,589216,1756494,2318752,1919015,2239623,2320928,2084178,704817,972393,72746,490332,325075,472880,1124684,1587170,190629,2106387,458429,2326991,2069285,1280997,1858054,2329302,609063,1769934,1316558,2330228,1764107,1976657,2304737,2307726,2333043,1393500,2330158,1286527,783010,2106862,2336250,2336323,1834662,1883044,337353,2335911,1154910,845310,2321710,409221,2247911,1524458,1369706,1491895,1928660,1944784,2206361,2266704,1946334,1519574,2346073,2239760,2291409,782308,2281665,2276412,872150,849490,1815600,2202702,2330614,272072,2233735,2312796,905720,1480910,1816108,2356357,824954,4433,1312346,772816,2358434,1241347,890726,1105209,2130312,1419624,2171071,999400,1799024,1816367,1968538,1845671,1798750,350705,1998454,2357714,1503130,2356086,937324,628080,312785,1898087,331042,708436,2359205,1679323,1187293,2370302,1968354,2331319,1641942,893111,1813428,1501839,1340512,1845977,2375559,355103,1402645,1181347,2236883,1083946,1329544,865868,287969,1735922,1896646,1338674,1844263,2380611,2047359,1494769,163065,643619,2213669,93438,1837856,1254996,1527428,2291724,2170324,1010604,1319413,1821997,514727,2327014,101421,1329396,2105852,2374456,2286791,1360074,1853547,1363001,1681681,1738132,1724235,1856305,685987,2392710,1366368,730208,2356683,7743,1953145,1651342,2396644,1175655,153083,2332649,2294520,1348550,1827375,1364233,1682733,493106,1961654,2327791,2038408,1882203,2402106,2402971,2141709,1523706,395659,2406422,2384250,730056,1542702,1262767,830658,1329486,1309003,2093427,1954677,2237911,270315,809384,698585,586104,1934053,1296925,433337,1059465,2403006,1636876,819567,2319984,1513481,2068584,2255251,1879258,429938,1222578,150851,2150271,2425240,664204,1225603,2426384,2426460,2358643,1220659,2010973,2423146,2231503,1799092,730313,1036299,1513082,2419997,2154537,1893264,986067,2284926,1825795,1578671,2431645,2425726,2369455,2304060,2149367,2399378,353985,2080363,530340,29182,1177085,2367317,1781412,1734730,2440773,1675976,1624463,2395605,2202180,1220374,2444354,19851,1622859,376947,842740,2445708,2445793,910330,2175373,965017,1795228,1230772,58737,1330083,380403,1812379,831346,1850910,1613365,995364,2430210,548395,2451574,976974,2337345,1312635,2399340,2170691,1619556,2040742,2397351,2407159,2454196,2759625,513549,973802,2455889,1909586,111469,1526764,2263827,2064208,2457720,505062,1188760,2454629,755628,713937,1853229,263101,2325640,1202367,2460701,1685917,1636905,1586201,992542,2332744,1190077,2339544,415038,816892,2126174,2462124,2225477,1581684,1055711,2354646,1973099,2465694,2280395,1544154,303810,1867607,2118662,660380,2472485,2467343,810151,1809976,1882953,315689,1072451,2476113,1779502,1495011,692604,8986,2664985,2461761,2480092,1643483,2480446,1762058,801291,2515024,811098,2359258,1775614,469632,2485954,1279334,2443309,2414932,1256811,2367428,2484070,1060794,2487742,2488228,1082767,2489034,2489863,1913693,2264338,1319253,1470009,1938774,1643990,1252601,2437124,2039134,928144,465074,1949566,2323067,2290907,784345,2358772,1352127,561327,1901302,931303,2165970,2729481,2449814,2501411,588792,182629,52207,2498580,2498597,469320,2055344,772678,2495628,2258989,2506525,2491474,1936622,471136,300873,2415393,2474175,1642731,99688,348671,1373124,2510809,2511102,2512249,1221082,497909,2142490,1687543,2490334,1261657,2416871,1709271,2258464,1481699,1170553,2515540,975222,1104823,858981,2516856,1464519,1939703,998318,1633714,2515923,2515300,210727,808640,661624,1511491,2294472,1218139,2523823,304775,1086120,823872,1969460,2435314,838044,1268825,1872583,1815167,2076725,1197428,718579,2125720,1100265,2510173,488487,2132017,1428250,1383808,784384,132002,1394117,1953105,1246772,2243369,1220192,440302,2472731,851885,2535549,1925758,2545326,1690949,2089006,2528914,880511,988216,1103412,2445455,1076546,440677,2159536,2331234,1154380,1447326,1946033,2494384,2057623,1622488,586754,1013525,2552507,523714,2553616,2417578,1157070,1413737,2384815,2412035,1545187,1658855,1660802,511716,1072064,2465762,2558787,2546848,2560672,1496726,2531987,1218080,1167324,1205712,1442452,2188175,1587728,433380,1012620,2218838,1744705,1714501,260127,2566017,402866,2125383,1017476,2407394,2428760,1262163,2568667,586100,2051392)
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