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 (575047,901812,98357,379907,830828,147458,816210,903660,711243,213738,845875,639309,751224,259731,235660,906670,278379,846471,336975,664939,909544,737018,451192,915500,306596,291322,734359,635998,916670,636493,586621,309145,918787,140578,722349,323825,1959,486209,207305,725851,700391,308140,688653,1736294,319873,413397,249879,914736,129753,259562,929448,33690,101969,746473,425380,708678,906153,352346,545430,907931,873015,837358,938768,770127,862345,493559,468130,941503,501518,942714,772240,495555,270835,846550,809908,905585,232089,723980,624900,904308,488096,329755,45963,515334,850820,298745,953637,336186,462123,476646,955037,247730,352432,915626,159447,616776,560844,184774,432947,962490,565877,963326,964046,315711,799628,862210,693754,343067,328316,342470,442716,688689,318959,862620,401729,169008,243918,973555,613206,490321,356218,830236,940731,969639,865558,735445,478810,554340,508666,603355,89528,848863,349517,228450,268451,572616,155268,388225,985868,986040,938261,649167,561710,110202,48181,98494,990621,240427,216582,507184,950648,945738,242961,223122,997341,997871,364914,711129,954414,995157,892623,546243,998829,972432,69537,738924,206730,104059,529482,799779,264675,1007105,135237,951152,777586,508524,1009796,892012,468039,182855,559415,445663,520541,662993,123891,730217,355583,374499,961510,910692,948604,277782,785375,268016,654269,938372,860103,201113,296439,360539,684003,477865,1004437,411965,1025610,197376,60067,417578,941192,539638,1028725,507134,970787,1019083,680427,328182,1031612,16241,600472,725709,1037231,1001007,625103,884862,74896,787883,825356,977102,966437,1042102,997824,603200,216074,846368,1044618,319862,765579,754087,57809,290050,940723,800452,151939,259982,538837,913670,716027,884934,1053816,989469,418413,1054450,13480,1055256,1055089,990620,1056006,419075,875850,638529,908849,820588,375460,5932,630908,79109,1024485,157224,616363,259881,813739,499373,139637,924100,1058669,987777,188711,981493,908613,3314,48837,1068490,700089,304357,1069825,761330,102704,1035985,903525,1071351,1071544,1064719,1073407,706456,832822,846934,663957,1075803,758118,637409,784855,367401,511852,108176,6782,221650,109795,157971,443626,829174,723292,1056434,1070769,266453,1089461,213683,126855,546427,1091948,1471610,624305,1020217,1092894,857071,187907,1043792,1094876,567328,950218,1096250,239567,740700,307797,492561,847333,122687,360829,1067259,1103912,1102092,585913,235132,128816,1076048,1102342,905867,1108146,375847,1111380,224059,1063413,771451,402814,657429,697890,1115245,308665,865464,157991,1116481,563359,972936,248296,245168,746917,1038382,858695,439317,233211,963386,1002584,419863,1112407,339720,474563,845529,422684,803923,1132408,875044,982548,1135561,1024298,530285,1065489,1086334,1140134,559070,1118149,585329,362721,97802,76590,819367,1141077,521257,559850,1141009,45725,57731,201359,596186,347339,1037215,266378,174614,931389,1157139,304484,20951,1160153,1162053,325499,308254,497681,893630,546220,786590,492575,1102514,993494,381422,344570,1154037,1175064,398259,1124682,917249,688843,800334,1161316,1066452,596881,318760,716473,247184,324085,553952,1086428,1017130,938429,383522,1179969,990666,548696,341646,852872,485202,442585,848249,1036081,492624,1121922,1194810,1122892,131120,2606598,312499,1024444,742501,324135,1200804,114930,526327,750543,265521,529310,1164929,553941,211114,1036606,552525,1032703,177242,771477,719193,991926,64138,1185211,799007,764316,700143,960713,382186,1202734,313087,1083775,1194183,893555,1216976,75500,629599,759123,1179349,625032,426332,988830,1221734,11114,407197,117658,492191,1029944,310370,1222282,600516,138606,828625,1189361,288457,682901,626201,1224188,1098128,1101001,255053,270483,982487,5789,589395,1042241,407236,1193516,1162590,261952,200983,931160,1234443,1220493,177421,1029936,165520,1236223,1203288,1237419,1238346,1191579,401727,401643,1060621,512652,1241828,834998,1052697,457228,683408,1134514,918479,939497,940834,1008957,339696,983399,253387,1146230,1122645,99379,979663,277671,1172428,1196562,1240501,1252095,1253613,510360,850737,371539,1232833,955607,404020,288389,1258794,1143249,602446,1231863,435418,1106578,174375,129735,481564,486990,210039,691977,98713,1234445,1132806,1268520,405559,1269021,1269493,837765,1238557,834697,130164,1271799,1268503,97390,1274640,1013384,899347,1095495,82062,1278666,1278923,1240283,1055841,733486,317172,1280859,1248242,569097,1078986,260894,938695,866596,936083,812517,1138816,787171,975797,610281,695195,1291449,886314,5377,575527,419284,287592,316727,841289,363437,1299098,175084,1300224,249120,1186351,1185417,1302720,864912,1129606,386751,904436,1029916,1151923,743354,343452,1305528,1232870,1304680,969784,338297,387774,322020,456106,1246909,887835,1046501,1313066,795201,1148251,920043,1140876,1285621,407183,180862,71422,815481,640558,184528,527574,413403,1078529,481111,1035270,705725,481696,1026764,1247869,1079913,333291,1323620,135754,1010005,62664,258009,738737,209459,1327786,460274,1328745,434421,1332897,693554,536129,798684,1854789,1018270,1310604,1337778,75970,1227469,1304247,863975,1237132,508702,1131713,626819,1181864,1504964,1006789,1343787,550309,440172,82480,1293563,1299326,1083663,129622,1307569,86309,140328,128377,1294529,305256,1356121,188323,77538,189293,70894,1011926,1111229,765523,782746,1358456,251614,981200,259095,533426,1284770,163551,391969,1363214,177883,1363268,1363438,924496,1176502,1367329,610217,974273,385966,392315,304319,1298941,940246,618292,1023128,784083,1185998,377133,1085716,1042483,913461,915501,1013641,325419,1300763,1374065,989439,1244383,813523,1332242,1183764,714831,804487,1138915,825028,1369342,123140,1366915,820511,1318751,34088,981391,406930,1390345,573382,167044,1096537,550335,26463,1393897,1372813,104422,1247522,658536,868546,335514,682404,864627,767996,276193,1179191,2799,678999,1232765,1154283,1129194,963446,1390343,421010,1404919,1361970,1406757,946719,1180245,2248593,222164,1350594,1242401,734181,1340881,744484,1349046,1176548,947191,1414710,477065,1285928,1415587,1416144,243355,266103,1417289,462203,34824,1043456,1303562,1293653,396404,268193,1151746,115466,953613,1422486,1377835,1413885,858926,744859,1224534,951640,465378,463380,1318734,1398222,1426486,1426673,638350,1299154,496285,205753,659884,1349315,597938,1009169,1008666,1431712,1437859,894755,763026,710954,471324,1442361,1345618,858033,1322908,299230,184746,978756,1418742,756200,1105341,1090986,1387444,601577,1446948,888478,464587,195701,1410831,1450765,1050877,307283,859080,842424,544395,673919,292533,545591,1200000,1457091,516833,1300737,125787,1366644,829222,99834,1361969,1023928,1073386,283055,770834,1314221,1467398,1124271,1440250,967771,1459774,1426898,1220250,647490,1459449,1217178,1480643,1034515,1282539,1399466,863713,911164,1451233,451592,1440740,1014240,1071136,433355,1488370,1447290,370695,639165,1103180,1367124,1459579,1466627,1487347,367068,783663,1495509,483486,1498636,1124539,1293890,1501388,1502232,1498253,1189352,1503972,971193,1504230,655183,985296,74493,244526,501134,1493673,1241619,1332264,298406,799586,822005,1421864,1515928,665261,1493770,1215889,1432594,1428526,1489502,142905,1313175,773879,1522196,1467378,181870,688161,1152142,652669,1260176,1401153,381043,863980,1527973,1472381,1529314,1102960,1114664,1118485,864572,423805,1266461,1423893,825287,805627,1393662,651473,573586,659149,1486407,2375716,613483,1535724,370073,1385243,100405,4668,1173311,869912,1527829,7850,1372122,1499144,91403,1209905,670396,1244342,1552584,1429054,214849,498624,1211349,913184,1076603,857990,776142,706808,1441093,1253907,1508085,981787,654203,455741,877651,1213036,940744,1015595,86218,1492873,771861,1176008,1561660,938865,1104329,801348,980520,1423793,1249654,507506,1399354,1563816,1598346,618756,165839,1093266,159267,162719,144665,673663,1575063,1481096,1526667,186891,1536201,1374929,1576900,861193,1229855,1290498,1571660,844005,909244,1401410,1386572,1273291,372519,722233,294103,997973,1365469,786487,40714,1583122,1526471,1570314,1583728,1301389,298555,491807,99771,558566,454671,1172559,1134550,894792,1437684,1206003,1567088,1420279,1419393,1135703,1068167,1594351,246998,1595276,1151755,843859,786560,311074,1456578,1480052,1597444,389394,419275,1204749,1499032,815111,1124350,659190,957496,866190,1563613,1462604,1321706,838092,386558,927626,1478936,492048,1483649,1028969,448381,916332,971904,1280947,923104,1534509,1230836,1145520,1596244,377816,1464630,1138245,1576874,1019741,714713,1617559,988684,1049391,1394513,1270042,467380,1558261,406273,1100859,718728,1623245,902423,1505217,942671,1545422,589897,1624752,468737,1596018,220761,681164,742802,113643,894115,1070258,1513286,15795,1407736,1327740,1628452,1314366,926907,799227,748711,1066583,1202558,415078,1038781,63791,1151479,952018,579690,890387,596952,1633795,1390035,1265219,716847,57986,1329798,1636363,98528,160868,961314,462445,1432106,52251,319773,871805,1253824,1207531,1111886,556072,1043981,591282,1462290,1461963,1436982,298073,1643568,973481,1310736,839375,1062015,414875,1904753,16287,892745,1182328,395255,1057750,1220715,1384978,1200984,1153032,1044750,1647959,1565284,1455814,686760,1644030,1232685,1369247,604511,1642913,1347018,1332416,1423254,1580545,1475523,1650958,480028,606625,734524,1298944,1139626,325408,1175065,269478,1465011,984791,346977,794212,438758,136834,624869,159270,781303,631459,291706,1044544,1629615,272647,20578,1386568,1475556,1386103,1574294,450693,1616409,696326,1657131,788116,126352,1525784,1480957,1349089,1631924,1675694,1137325,885200,1344760,970549,1459575,93770,496351,193601,1665184,1680583,640870,1358572,1681738,906999,1264391,5351206,147950,1424568,673487,1641874,910868,1613835,1681664,1625274,1114457,910328,26188,1430251,1318701,1444752,862495,1661206,816213,265650,1658865,576671,498902,387058,504031,1694061,303381,1331739,1181215,1163114,1538620,1696324,1204054,551872,1685417,1063188,1113715,849474,1699705,976001,1283853,965704,1697732,1373624,100240,1092880,1538127,993320,1307231,1704138,210368,1098490,66522,632333,1099432,1529852,1062179,1515191,1510905,1709488,944732,413785,1127391,1207003,1140531,733152,959874,1126614,1415064,981380,1397287,1662998,1690243,1360941,1113216,917209,1716676,1249664,1018787,711697,730569,1155106,1361303,740902,749973,114953,854457,1695673,1090772,1247948,815429,1138570,1539090,716082,1422056,1542646,349710,715405,1188585,614611,1610603,1727507,171236,1276402,1524271,1728019,1498192,1711425,825591,595090,1052788,391339,1700840,1348753,1646829,1404898,1637350,1735851,1711996,462923,278325,1736081,1698810,1542243,672098,1739166,617822,1706864,129089,1001335,172776,170521,1000971,1727490,511542,1262843,87197,1449850,826224,1320129,1744591,1006147,1016777,147192,1724072,1742276,291022,1272209,186099,1529630,1103705,967945,1737830,181638,1267780,302369,1020714,1751925,1694340,1493692,643982,1127777,1355232,1369350,1725296,938694,793789,350265,1750289,1758245,570200,799493,1742594,2112928,704144,1761165,1016950,1489373,1691538,1267663,1332970,1762679,977312,1724227,1542969,44394,1764125,1077385,779323,1161077,349414,1766258,728411,21974,289246,819436,1769393,135135,471303,1772213,242107,384985,1750886,1198166,1580351,1775048,187750,1522804,704481,1776854,1061499,1264768,1778461,1577698,1146596,1779572,1749850,1137356,1149522,1780413,1580305,573082,1001563,1047423,1353905,1748450,965369,126666,1144476,1553521,1118126,1182464,1785771,688563,751634,1788160,1649023,1732208,1026434,1790213,1259825,1126268,1324879,563904,1766888,148193,1793883,485553,1100032,1665808,1627403,1689706,870776,978734,1797238,715458,1797444,1543957,84478,486057,1768288,1823440,811785,318811,530153,1702009,736355,1680256,531203,786920,1708806,612922,1574405,1314439,931738,1126810,1259261,1392189,1113023,597933,1784180,48684,1764781,1604309,1381418,1029825,1281385,1812975,1756612,1248720,824615,252253,1479853,1816257,1798256,789070,1817031,1817623,174390,1660612,615425,1673045,659366,1262489,1292075,838117,950799,890144,1430394,1740928,1708774,508029,402197)
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