SELECT Temp.Id, Temp.Date, ROW_NUMBER() OVER(PARTITION BY...

0

Please login or register to vote for this query.

(click on this box to dismiss)

Role-playing Games

Q&A for gamemasters and players of tabletop, paper-and-pencil role-playing games

SELECT Temp.Id, Temp.Date, ROW_NUMBER() OVER(PARTITION BY Temp.Id, Temp.Date ORDER BY Temp.YMCA ASC) AS EventId, Temp.Name
FROM (
  SELECT Users.Id, CONVERT(date, Badges.Date) AS Date, Badges.Name, Badges.Date AS YMCA
  FROM Users, Badges
  WHERE Users.Id IN (1124774,1124902,1125151,1125388,1125774,1126194,1126650,1127013,1127066,1127155,1127180,1128702,1128756,1129044,1129270,1129297,1129313,1129655,1129801,1129937,1130300,1130354,1130673,1130807,1131242,1131473,1131651,1131855,1131965,1132149,1132999,1133042,1133069,1133380,1133600,1134409,1134576,1135181,1135205,1136875,1136931,1137221,1137312,1137756,1137770,1137833,1138145,1138234,1138336,1138735,1138833,1138933,1139129,1139623,1140221,1140468,1140474,1140657,1142384,1142827,1142989,1143901,1144340,1144502,1144774,1144828,1144882,1145146,1145241,1145511,1145516,1145860,1145886,1145981,1146231,1146280,1146300,1146461,1146624,1146739,1146865,1146898,1147223,1147401,1147543,1147792,1148119,1148321,1148462,1148464,1148590,1148973,1149073,1149145,1149295,1149901,1150071,1150156,1150741,1150908,1151188,1151704,1152075,1152151,1152348,1152543,1153104,1153264,1153673,1154663,1154664,1154699,1154746,1154853,1155006,1155257,1155317,1155430,1156112,1156176,1156335,1156817,1156828,1158652,1158763,1158926,1159243,1159602,1160813,1160937,1160974,1160989,1161305,1161667,1162116,1162245,1162490,1162559,1163341,1163490,1164182,1164241,1164425,1164483,1164499,1164569,1164610,1164909,1165077,1165112,1165165,1165558,1165973,1166268,1166537,1166876,1167316,1167532,1167690,1167817,1168114,1168408,1168594,1169500,1169933,1169940,1170625,1171214,1171466,1171646,1172152,1172711,1172957,1173081,1173264,1173544,1173652,1173662,1173672,1173758,1173913,1174448,1174735,1174763,1175001,1175384,1175840,1176159,1176276,1176432,1176505,1176520,1176776,1177228,1177314,1177586,1178455,1178871,1178944,1179145,1179150,1179291,1179368,1179538,1180459,1180771,1180872,1181653,1182062,1182255,1182896,1183030,1183124,1184206,1184305,1184498,1184604,1184901,1184941,1185311,1185465,1185591,1185679,1185683,1185897,1186323,1186472,1186510,1186731,1187264,1187594,1187640,1188083,1188085,1188087,1188181,1188470,1188974,1189111,1189442,1189612,1189885,1190104,1190416,1190466,1191930,1192008,1192032,1192297,1192398,1193203,1193364,1193458,1193506,1193602,1193907,1194696,1194939,1194999,1195038,1195100,1195218,1195503,1195720,1195893,1196156,1196161,1196798,1197232,1197357,1197377,1198943,1199287,1199360,1199703,1199704,1199722,1200667,1200987,1201035,1201201,1201484,1202766,1202798,1203592,1203625,1203691,1203698,1203849,1204664,1204711,1204907,1204955,1205243,1205450,1205521,1205689,1205952,1206014,1206016,1206238,1206261,1207232,1207489,1207828,1208065,1208512,1208566,1208999,1209522,1209700,1209883,1209918,1210071,1210166,1210904,1211198,1211723,1211864,1212676,1213084,1213206,1213320,1213766,1214398,1214489,1214666,1214674,1214709,1215220,1215366,1215636,1216124,1216339,1217064,1217323,1217894,1218009,1218105,1218113,1218522,1218593,1218749,1218928,1219093,1219358,1219743,1219961,1220816,1220965,1221886,1221918,1222124,1222855,1223690,1224290,1224302,1224319,1224877,1225216,1225340,1225538,1225631,1225905,1225979,1226301,1226335,1227485,1227522,1228172,1228273,1228322,1228626,1228716,1228930,1229242,1229490,1229616,1229864,1229895,1230206,1230296,1230480,1230618,1230656,1230890,1230894,1231409,1231781,1232781,1232826,1232985,1233126,1233273,1233631,1233736,1234057,1234414,1234672,1234732,1235008,1235044,1235098,1235865,1236132,1236825,1237403,1237690,1237732,1237772,1237937,1238133,1238564,1238737,1238763,1239156,1239189,1239557,1240288,1240575,1240682,1242156,1242502,1242784,1242797,1242961,1243499,1243577,1243701,1243932,1244125,1244475,1244629,1244869,1244977,1245030,1245444,1245495,1245829,1246253,1246325,1246859,1247170,1247205,1247224,1247529,1247533,1247734,1247814,1247968,1248023,1248121,1248406,1248746,1249283,1249348,1250343,1250377,1250807,1250959,1251191,1251757,1251973,1252266,1252381,1252573,1252731,1252868,1253078,1253141,1253361,1253421,1253469,1253564,1253723,1254173,1254699,1254743,1254893,1255016,1255139,1255304,1255444,1255568,1255872,1255998,1256179,1256327,1256827,1257359,1258582,1258661,1258955,1259077,1259157,1259186,1259576,1261186,1261228,1261288,1261660,1261731,1261989,1261990,1262044,1262157,1262201,1262233,1262549,1263745,1264081,1264095,1264137,1264221,1265385,1265484,1265607,1265880,1266258,1266323,1266758,1266879,1267050,1267793,1268037,1268152,1268786,1268962,1269850,1270558,1270841,1271361,1271919,1272096,1272117,1272280,1272312,1272330,1272923,1272975,1272987,1273279,1273385,1273573,1273731,1273894,1274116,1274150,1274285,1274320,1274362,1274906,1275089,1275811,1275892,1276040,1276426,1276573,1277017,1277405,1277472,1277513,1277670,1278129,1278479,1278688,1278708,1278716,1278979,1279252,1279392,1279499,1279521,1279780,1279857,1280004,1280282,1280582,1280786,1280943,1281089,1281443,1281519,1281881,1281943,1282221,1282224,1282336,1282447,1282476,1283525,1283567,1283589,1284246,1284400,1284586,1285020,1285032,1285116,1285415,1285644,1285992,1286588,1286808,1286814,1286854,1287083,1287471,1287499,1288253,1288384,1288621,1288751,1288873,1289179,1289326,1289757,1289926,1290097,1290227,1290235,1290571,1290954,1291155,1291417,1291436,1292025,1292055,1292070,1292074,1292591,1292922,1293285,1293436,1293522,1293631,1293878,1294160,1294643,1294705,1294765,1294870,1294927,1295346,1295645,1296776,1296805,1296854,1297120,1297322,1297337,1297530,1297565,1297808,1298102,1298280,1299464,1299524,1299687,1299709,1299735,1299807,1300059,1300145,1300469,1300556,1300989,1301333,1301568,1301611,1301771,1301848,1302426,1302427,1302799,1302906,1302977,1303196,1303850,1304069,1304315,1304447,1304870,1304940,1305213,1305396,1305495,1305623,1305845,1306889,1307025,1307074,1307214,1307987,1308265,1308590,1308719,1309022,1309151,1309738,1309874,1310215,1310469,1310802,1310889,1311025,1311155,1311229,1312541,1312679,1312792,1312839,1312850,1312977,1312989,1313063,1313070,1313119,1313161,1313227,1313231,1314174,1314274,1314711,1315418,1315444,1316185,1316372,1316772,1317044,1317086,1317305,1317628,1317904,1317954,1317959,1317986,1318063,1318344,1318390,1318512,1318599,1319066,1319765,1319771,1319951,1320284,1320338,1320789,1320881,1320964,1321551,1321884,1322012,1322061,1322762,1322881,1323370,1323555,1323641,1323891,1324066,1324136,1324287,1324793,1325117,1325131,1325176,1325574,1325761,1325822,1325916,1326102,1326242,1326537,1326677,1326821,1327168,1327171,1327285,1327316,1327813,1327869,1328719,1328819,1328829,1328837,1328976,1329148,1329306,1329616,1329654,1329812,1330079,1330822,1330849,1330973,1330974,1331528,1331710,1331729,1332461,1332559,1332658,1333670,1333713,1333795,1334288,1334333,1334426,1334721,1335017,1335361,1335435,1335498,1335962,1336205,1336397,1336554,1336607,1336735,1336822,1336979,1337189,1337230,1337637,1338480,1338713,1338787,1339083,1339542,1339615,1339785,1340061,1340594,1340661,1340687,1340761,1340871,1340881,1341230,1341370,1342172,1342579,1342919,1343001,1343279,1343312,1343607,1344772,1346003,1346023,1346498,1346546,1346996,1347241,1347780,1347954,1348322,1349189,1349518,1349536,1349573,1349751,1349890,1349916,1349954,1350237,1350534,1350809,1350845,1351141,1351376,1351883,1351981,1352149,1352322,1352570,1352809,1353925,1353949,1354057,1354114,1354240,1354446,1354936,1355355,1355504,1355762,1355897,1356166,1356807,1357247,1357357,1357363,1358197,1358296,1358714,1358930,1359468,1359527,1359537,1360018,1360093,1360168,1360220,1360323,1360646,1360659,1361115,1361418,1361483,1361624,1361774,1361789,1362225,1362502,1362585,1362608,1362742,1362974,1363134,1363471,1363524,1364181,1364194,1364213,1364419,1364876,1365190,1366236,1366373,1366578,1366799,1367456,1367543,1367579,1367641,1367665,1367782,1367813,1368810,1368849,1368992,1369473,1369646,1369801,1369871,1370234,1370811,1370889,1370900,1371339,1371523,1372307,1372572,1372621,1372815,1372834,1372976,1373361,1373834,1373859,1374184,1374736,1375138,1375159,1375269,1375320,1375402,1375589,1375998,1376505,1376916,1377153,1377564,1378064,1378402,1378689,1378760,1378835,1379273,1379342,1379847,1379982,1380212,1381107,1381412,1381467,1381774,1382021,1382792,1383039,1383086,1383357,1383391,1383661,1383813,1384107,1384659,1384735,1384890,1385429,1385914,1386529,1386550,1386853,1386870,1387085,1387253,1387468,1387507,1387561,1387624,1388241,1388469,1389485,1389747,1390280,1390282,1390951,1391034,1391046,1391280,1391301,1391323,1391582,1391680,1392007,1392323,1392419,1392426,1393023,1393031,1393327,1393476,1393602,1393746,1393846,1393861,1394012,1394132,1395702,1395704,1396128,1396808,1396879,1396892,1397044,1397206,1397329,1397485,1397775,1397786,1397962,1398013,1398194,1398303,1398395,1398461,1399100,1399114,1399216,1399377,1399502,1399513,1399675,1399678,1399756,1400189,1400621,1400807,1400820,1400866,1400949,1401173,1401202,1401472,1401786,1401923,1402162,1402323,1402448,1402514,1402869,1403091,1403610,1403797,1403864,1404204,1404236,1404303,1404602,1405015,1405181,1405344,1405366,1405492,1405711,1405805,1405822,1405957,1406408,1406450,1406463,1406496,1406511,1406706,1407094,1407339,1407373,1407861,1407911,1407965,1408193,1408557,1408568,1408732,1408930,1409003,1409028,1409148,1409788,1410046,1410699,1410797,1411061,1411094,1411591,1411788,1412116,1412214,1412319,1412500,1412653,1412672,1413337,1413641,1413663,1414161,1414908,1415192,1415335,1415345,1415547,1415629,1415992,1416213,1416696,1417242,1417432,1417772,1418183,1418362,1418434,1418493,1418663,1418677,1419093,1419382,1419427,1419523,1419777,1420847,1420922,1420931,1421035,1421374,1421378,1421422,1421765,1422035,1422245,1422335,1422939,1423308,1423745,1424283,1424348,1424359,1424719,1425356,1426365,1426388,1427095,1427661,1427756,1428203,1429624,1429887,1429942,1430114,1430160,1430754,1430870,1430911,1430990,1431000,1431010,1431213,1431325,1431545,1431899,1432039,1432135,1432366,1432694,1432839,1433060,1433083,1433105,1433106,1433108,1433540,1433590,1434087,1434137,1434565,1435010,1435184,1435381,1435518,1435710,1436258,1436434,1436469,1436614,1436734,1436913,1437106,1437322,1437367,1437473,1437787,1437801,1437849,1437910,1437921,1438143,1438707,1439224,1439433,1439633,1440065,1440247,1440791,1441238,1441520,1441611,1442060,1442298,1442804,1442852,1443287,1443645,1443668,1443801,1444121,1444215,1444222,1445048,1445181,1445648,1445730,1446027,1446229,1446465,1446605,1446731,1446771,1446804,1446865,1447361,1447408,1447436,1447683,1447867,1448056,1448642,1448742,1448823,1449438,1449787,1449915,1449951,1450203,1450553,1451166,1451286,1451532,1451839,1451847,1452195,1452324,1452624,1452887,1453094,1453164,1453829,1453962,1454199,1454422,1454947,1455052,1455282,1455728,1455735,1456248,1456334,1456404,1456649,1457576,1457682,1457769,1457839,1458114,1458253,1458743,1459168,1459285,1459483,1459669,1460298,1460527,1460723,1460780,1460856,1461704,1461723,1462051,1462420,1463324,1463452,1463532,1463701,1463705,1463756,1463814,1463881,1464019,1464038,1464128,1464154,1464226,1464265,1464290,1464291,1464526,1464624,1465570,1465722,1465857,1465909,1466096,1466123,1466547,1466862,1466893,1467144,1467296,1467481,1467562,1467678,1467969,1469250,1469580,1470317,1470887,1471003,1471544,1472704,1473050,1473175,1473216,1473302,1473469,1473713,1473998,1474077,1474119,1474548,1474637,1474693,1474784,1474894,1475042,1475236,1475329,1475724,1475863,1476129,1476175,1476376,1476378,1476941,1477172,1477235,1477799,1477904,1478089,1478095,1478260,1478290,1478300,1478373,1478707,1478768,1478879,1478926,1478943,1479022,1479209,1480080,1480358,1480905,1481104,1481121,1481304,1481571,1482582,1482765,1483052,1483104,1483111,1483598,1483955,1484135,1484358,1485149,1485232,1485517,1486017,1486068,1486573,1486652,1487138,1487167,1487660,1487861,1488243,1488246,1488461,1488463,1488683,1488693,1488922,1489200,1489260,1489399,1489735,1490019,1490028,1490036,1490082,1490440,1490651,1490974,1491048,1491113,1491287,1491642,1491812,1491974,1492277,1492516,1492820,1492913,1492999,1493254,1493361,1493547,1493593,1493634,1494474,1494495,1495223,1495638,1495644,1495806,1495865,1496013,1496639,1497070,1497295,1497530,1497733,1498235,1498245,1498287,1498457,1498464,1498701,1498734,1498935,1499005,1499384,1499543,1499573,1499627,1499936,1500006,1500443,1501006,1501043,1501156,1501236,1501411,1502137,1502161,1502185,1502442,1502997,1503276,1503484,1503498,1503619,1503672,1503864,1504032,1504485,1505391,1505417,1505467,1505631,1505781,1506062,1506492,1506653,1506864,1507115,1507156,1507460,1507537,1507546,1507591,1508171,1508414,1508657,1508802,1508935,1509011,1509145,1509655,1510065,1510380,1510683,1510842,1511246,1512028,1512138,1512233,1512310,1512345,1512373,1512724,1512726,1513012,1513027,1513959,1514072,1514209,1514235,1514364,1514465,1514721,1514899,1515233,1515324,1515383,1515708,1515862,1516001,1516548,1516773,1517111,1517157,1517415,1517496,1517568,1518236,1518867,1518880,1519069,1519094,1519817,1520494,1520662,1520683,1520798,1521538,1521755,1522014,1522848,1523769,1525072,1525212,1525276,1526008,1526128,1526136,1526228,1526283,1526478,1526932,1527076,1527111,1527292,1527316,1527324,1527414,1528059,1528165,1528485,1528749,1529451,1529520,1529615,1530149,1530766,1530937,1531345,1531352,1531446,1531619,1531778,1532537,1532637,1532915,1533627,1533634,1533957,1533979,1534032,1534148,1534336,1534498,1534995,1535165,1535286,1535499,1535910,1535928,1536120,1536315,1536599,1537095,1537727,1538099,1538205,1538713,1538903,1538965,1539024,1539103,1539170,1539172,1539206,1539678,1539716,1539728,1539909,1540276,1540489,1540579,1540582,1540928,1541230,1541284,1541351,1541612,1541745,1542038,1542161,1542187,1542217,1542314,1542461,1542490,1543085,1543134,1543154,1543447,1544132,1544890,1545174,1545412,1545478,1545664,1545763,1545883,1546185,1546256,1546779,1547324,1547378,1547481,1547572,1547747,1548000,1548433,1548665,1548666,1548867,1549015,1549382,1549861,1549912,1550043,1550141,1550264,1550327,1550365,1550559,1550603,1551429,1551436,1551781,1551852,1552011,1552023,1553178,1553663,1553727,1553795,1553856,1553902,1554805,1554935,1555240,1555373,1555554,1555628,1555664,1555814,1555908,1555960,1556204,1556258,1556329,1556553,1556724,1556762,1556786,1557163,1557464,1557763,1557784,1558438,1558746,1558886,1558970,1559139,1559650,1561135,1561453,1561547,1561583,1561628,1561728,1562208,1562629,1562769,1563534,1563834,1563926,1564184,1564277,1564418,1564788,1565025,1565328,1565353,1565778,1565837,1566193,1566232,1566831,1567009,1567413,1568052,1568125,1568178,1568234,1568473,1568543,1568792,1569028,1569086,1569165,1569216,1569236,1569541,1570055,1570231,1570279,1570704,1570777,1571250,1571407,1571420,1572571,1572617,1572668,1572963,1573020,1573614,1573731,1573891,1574106,1574341,1574556,1574759,1574792,1574848,1575134,1575412,1575514,1575803,1575876,1575936,1576062,1576112,1576298,1576319,1577032,1577340,1577398,1577472,1578700,1578914,1579271,1579400,1579578,1579812,1579844,1580269,1580686,1580857,1581013,1581031,1581508,1581565,1581841,1581873,1581923,1582169,1583159,1583590,1584152,1584260,1584622,1584631,1584739,1584743,1584779,1584858,1586031,1586199,1586205,1586382,1587087,1587368,1587639,1587853,1588241,1588847,1588852,1589256,1589513,1589763,1589941,1589975,1590042,1590210,1590721,1590752,1590911,1591064,1591105,1591462,1591691,1591821,1591827,1592320,1592481,1592510,1593314,1593381,1593386,1593387,1593435,1593517,1593737,1593750,1594109,1594583,1594791,1595301,1595435,1596224,1596400,1597306,1597440,1597459,1598185,1599130,1599170,1599218,1599486,1599694,1599730,1600062,1600140,1600169,1600340,1600394,1600424,1600505,1600559,1600762,1600770,1600779,1601011,1601156,1601173,1601582,1601643,1602008,1602130,1602185,1602257,1602672,1602858,1603047,1603173,1603664,1603998,1604091,1604160,1604484,1605766,1606199,1606397,1606475,1606609,1606836,1607015,1607115,1607183,1607251,1607447,1607458,1607746,1607794,1607841,1608390,1608452,1608674,1608787,1608827,1609180,1609226,1609262,1609381,1609451,1609590,1610296,1610334,1610472,1610697,1611139,1611170,1611236,1611328,1611628,1611814,1611865,1612559,1613329,1613382,1613385,1613388,1613640,1613784,1613971,1614263,1614323,1614428,1614465,1614552,1614811,1614963,1614964,1615189,1615281,1615877,1616060,1616628,1616679,1616680,1616847,1617115,1617288,1617382,1617405,1617525,1617768,1617818,1617857,1618592,1618951,1619062,1619251,1619281,1619314,1619784,1620422,1620583,1620785,1620841,1621338,1621594,1622057,1622215,1622434,1622515,1622886,1623012,1623532,1623584,1623894,1624862,1625190,1625209,1625312,1625349,1625368,1625676,1625688,1625932,1626170,1626434,1627241,1627472,1627522,1627752,1628060,1628538,1628698,1628756,1628833,1628930,1629084,1629487,1629605,1629849,1630270,1630981,1631046,1631462,1631870,1631903,1632318,1632509,1633316,1633451,1633539,1633633,1633643,1634044,1634209,1634620,1634703,1635239,1635676,1635800,1635845,1636276,1636366,1636529,1636591,1636704,1637567,1637680,1637712,1637809,1637833,1638140,1638367,1638516,1638535,1638671,1638911,1639114,1639765,1639822,1640931,1641039,1641207,1641235,1641251,1641554,1641818,1642304,1642649,1643082,1643196,1643313,1643497,1643707,1643905,1644735,1644736,1644934,1644961,1645090,1645222,1645277,1645401,1645430,1645565,1645719,1645809,1645815,1645907,1646140,1646727,1646761,1646923,1647083,1647140,1647614,1647719,1648155,1648823,1648871,1649280,1649320,1649368,1649400,1649655,1649753,1649819,1650166,1650271,1650312,1650725,1650891,1650966,1650977,1651940,1651971,1652592,1652656,1652831,1652937,1653205,1653238,1653789,1654145,1654543,1655217,1655316,1655485,1655728,1656689,1656860,1657467,1657596,1657690,1657977,1657989,1658030,1658410,1658427,1658722,1658733,1658867,1658878,1658880,1659833,1659854,1660162,1660262,1660290,1660430,1660571,1660752,1661072,1661470,1662078,1662106,1662802,1662935,1662940,1663021,1663445,1663664,1664188,1664397,1665043,1665308,1665819,1665868,1665869,1666293,1666403,1666418,1667107,1667216,1667320,1667427,1667539,1667562,1668103,1668212,1668326,1668804,1668953,1668996,1669374,1669482,1669623,1669804,1670081,1670865,1670955,1671535,1671638,1672833,1672873,1673262,1673492,1673809,1673882,1674996,1675070,1675071,1675112,1675440,1675644,1675846,1676202,1676331,1677168,1677331,1677720,1677949,1678081,1678960,1679094,1679323,1679499,1679524,1679588,1679652,1680119,1680225,1680339,1680860,1681123,1681424,1681493,1681537,1681610,1682186,1682629,1683056,1683063,1683327,1684065,1684300,1684410,1684580,1684808,1685102,1685440,1685484,1685988,1686076,1686103,1686105,1686178,1686338,1686381,1686547,1687027,1687405,1687824,1688332,1688443,1688449,1688727,1688851,1689272,1689288,1689582,1690450,1690572,1690801,1690812,1691024,1691107,1691157,1691236,1691388,1691865,1692055,1692077,1692112,1692213,1692436,1692482,1692558,1692668,1692733,1692877,1692912,1692977,1693004,1693222,1693322,1693649,1694164,1694320,1695031,1695050,1695288,1695500,1695752,1695867,1696215,1697098,1697208,1697231,1697288,1697819,1697997,1698135,1698615,1698995,1699003,1699025,1699306,1699310,1699336,1699638,1699662,1700321,1700432,1701285,1701474,1701614,1701639,1701905,1702232,1702398,1702421,1702582,1702595,1702866,1702986,1703126,1704506,1704511,1704538,1704795,1705561,1705635,1706398,1706778,1706859,1706867,1707015,1707016,1707765,1707804,1707829,1708103,1708220,1708288,1708929,1708953,1709115,1709415,1709668,1709686,1710138,1710420,1710762,1710869,1711433,1711608,1711635,1711937,1712341,1712403,1713295,1713321,1713731,1713824,1714499,1714529,1715104,1715109,1715765,1715790,1716498,1716663,1717069,1717221,1717567,1717618,1717690,1717763,1718119,1718141,1718143,1718717,1718778,1718892,1719702,1719922,1720258,1720382,1720410,1720559,1721049,1721322,1721343,1722151,1722622,1722638,1722694,1722757,1722858,1722871,1723336,1723562,1723614,1724691,1724772,1724861,1725202,1725313,1725356,1725372,1725650,1725704,1726553,1726785,1727113,1727166,1727514,1727815,1727841,1727994,1728328,1728437,1728560,1728783,1728856,1728996,1729178,1729224,1729242,1729384,1729386,1729412,1729699,1729734,1729864,1730212,1730235,1730330,1731126,1731377,1731767,1731953,1731983,1732068,1732076,1732266,1732511,1732633,1732637,1732656,1732725,1733347,1733708,1734020,1734617,1734690,1734988,1735260,1735279,1735346,1735484,1735568,1735923,1736037,1736218,1736289,1736405,1736551,1736592,1736827,1736866,1737460,1737501,1737518,1737852,1737890,1737931,1738644,1738763,1739054,1739418,1739449,1739489,1740386,1740531,1741671,1741823,1741965,1742191,1742573,1742807,1742872,1743513,1744099,1744294,1744585,1744626,1744697,1744718,1745124,1745192,1745228,1745705,1746014,1746120,1746774,1746797,1747280,1747396,1747406,1747564,1747671,1747749,1747860,1748029,1748062,1748460,1748702,1748735,1748855,1748916,1749118,1749153,1749334,1749983,1750545,1750661,1750790,1750962,1751095,1751386,1752560,1753954,1753987,1754000,1754260,1754289,1754332,1754424,1754582,1754681,1754779,1755037,1756444,1756900,1757055,1757062,1757647,1757726,1757925,1758114,1758163,1758200,1758239,1758863,1759451,1760237,1760330,1760937,1760950,1761039,1761164,1761325,1761533,1761615,1761629,1761724,1761922,1762414,1762438,1762676,1762761,1762845,1762925,1762934,1763262,1763274,1763356,1763878,1764105,1764289,1764290,1764348,1764634,1764857,1764861,1765023,1765132,1765532,1765948,1766188,1766252,1766289,1766294,1766335,1766827,1766913,1767333,1767344,1767510,1767515,1767627,1768014,1768109,1768142,1769184,1769201,1769227,1769317,1769608,1769652,1770230,1770303,1770711,1770854,1771304,1771337,1771400,1771412,1771779,1771800,1772868,1773192,1773413,1773667,1773721,1773833,1773957,1774136,1774412,1774493,1774773,1774938,1774975,1775102,1775328,1776089,1776547,1776598,1777399,1777571,1777689,1778030,1778475,1778971,1779074,1779212,1779330,1779356,1779420,1779877,1780314,1780491,1780840,1781008,1781302,1781722,1782309,1782374,1783189,1783775,1784359,1784409,1784508,1784876,1784951,1785104,1785272,1785311,1785348,1786037,1786093,1786101,1786302,1786340,1786663,1786691,1786740,1786769,1786805,1786871,1787235,1787324,1787567,1787773,1787973,1787980,1788142,1788263,1788457,1789131,1789297,1789374,1789738,1790275,1790564,1790894,1791144,1791335,1791712,1791792,1792021,1792272,1792448,1792512,1792546,1792621,1792901,1793143,1793164,1793240,1793268,1793288,1793799,1794364,1794777,1795094,1795134,1795202,1795776,1795828,1795886,1796029,1796173,1796720,1796942,1797014,1797209,1797336,1797526,1797571,1797729,1798182,1798314,1798370,1798403,1798580,1798707,1798782,1798799,1799045,1799872,1800136,1800873,1800987,1801350,1801680,1801807,1802697,1802936,1802946,1803061,1803175,1803332,1803453,1803874,1803984,1804102,1804188,1804280,1804584,1804616,1804721,1805068,1805081,1805329,1805967,1806353,1806421,1806429,1806685,1807110,1807144,1807153,1807354,1807414,1807576,1807937,1808436,1808772,1809631,1809888,1809890,1810054,1810673,1810910,1811043,1811290,1811530,1811865,1811869,1811877,1811956,1812067,1812149,1812241,1812285,1812685,1812895,1813414,1814025,1814347,1814405,1814732,1815083,1815209,1815357,1815396,1815466,1815835,1815993,1816143,1816305,1816582,1816633,1816704,1816706,1817179,1817450,1817579,1817664,1817925,1818420,1818488,1818788,1818806,1819351,1819591,1819786,1819954,1820311,1820428,1820463,1820909,1821029,1821035,1821117,1821382,1822233,1822440,1822490,1823262,1823705,1823839,1824353,1824413,1824464,1824567,1824644,1824725,1824872,1825002,1825503,1825705,1825949,1826398,1826591,1826648,1826750,1826813,1826954,1827155,1827207,1827569,1828215,1828355,1828910,1828992,1829430,1829447,1829634,1829794,1829820,1830648,1830755,1830953,1831690,1832223,1832492,1834028,1834098,1835334,1835884,1835974,1835991,1836075,1836140,1836209,1836252,1836412,1836433,1836437,1836913,1837173,1837179,1837194,1837372,1837672,1837949,1838137,1838226,1838263,1838307,1838551,1838614,1839327,1839482,1839616,1839706,1839716,1839891,1840124,1840399,1840448,1840583,1840859,1840868,1841070,1841106,1841146,1841193,1841196,1841812,1841830,1842360,1842368,1842837,1843047,1843429,1843448,1844167,1844370,1844887,1844892,1845301,1845386,1845405,1846597,1846989,1847264,1847558,1847608,1848095,1848806,1848918,1849221,1849314,1849440,1849714,1850006,1850013,1850907,1851515,1851596,1851710,1851904,1852003,1852131,1852165,1852538,1852769,1853086,1853263,1853556,1853750,1853857,1854004,1854151,1854458,1854525,1854579,1854818,1855296,1855313,1855458,1855673,1856464,1856710,1857050,1857271,1857403,1857523,1858206,1859504,1860107,1860140,1860174,1860259,1860833,1860946,1861682,1862324,1862980,1862998,1863166,1863469,1863587,1863854,1864016,1864050,1864076,1864186,1864203,1864356,1864530,1864597,1865120,1865356,1865368,1865694,1865713,1866341,1866468,1866470,1866897,1866944,1866964,1867027,1867243,1868288,1868388,1868415,1868445,1868695,1868697,1868757,1869027,1869202,1869204,1869513,1869619,1869704,1869933,1870124,1870138,1870368,1870405,1870618,1871409,1872474,1872739,1872897,1873083,1873182,1873547,1873771,1874487,1874556,1875275,1875279,1875411,1875774,1876221,1877205,1877827,1877980,1878118,1878365,1878391,1878514,1878631,1878691,1878761,1878777,1878874,1878979,1879131,1879237,1879312,1879384,1879886,1879896,1880419,1880648,1881763,1881770,1881895,1882162,1882216,1882380,1883183,1883624,1883667,1884028,1884174,1884325,1884784,1884882,1884923,1885363,1885747,1885778,1886089,1886238,1886564,1886567,1886938,1887063,1887245,1888330,1888554,1888625,1889383,1889528,1889924,1890031,1890100,1890583,1890632,1891218,1891583,1892003,1892195,1892340,1892418,1892716,1892800,1892867,1893070,1893182,1893185,1893238,1893509,1894586,1894766,1895053,1895167,1895173,1895505,1895972,1896272,1896378,1896905,1897026,1897037,1897905,1897933,1898250,1898293,1898300,1898375,1898485,1898592,1898776,1899053,1899223,1899232,1899256,1899305,1899493,1899523,1899594,1900201,1900651,1901486,1901589,1902287,1902561,1902782,1903417,1903992,1904039,1904301,1904416,1904976,1905541,1906028,1906380,1906386,1906599,1907347,1907470,1907570,1907918,1908464,1908618,1908806,1909337,1909578,1909716,1909734,1909822,1910266,1910291,1910341,1910356,1910504,1910629,1910723,1911063,1911095,1911314,1911323,1911353,1911881,1912304,1913000,1913223,1913365,1913528,1913759,1913855,1914028,1914090,1914504,1914703,1914712,1914862,1915240,1915486,1915968,1916175,1916283,1916304,1916345,1916480,1917074,1917184,1917978,1917987,1918187,1918279,1918287,1918337,1918902,1919557,1919627,1920172,1920327,1920592,1920657,1921146,1921212,1922069,1922282,1922297,1922430,1922549,1922726,1922880,1922881,1922923,1923218,1923576,1923833,1923879,1924192,1924330,1924817,1924895,1925125,1925208,1926214,1926617,1926847,1927240,1927326,1927512,1927819,1928205,1928474,1928583,1929686,1930152,1930210,1930306,1930815,1930856,1931303,1931486,1931854,1932306,1932527,1932772,1933283,1933799,1933830,1934118,1934555,1934657,1934694,1934713,1935393,1935808,1936227,1936303,1936384,1936407,1936718,1937272,1937678,1937722,1938009,1938185,1938670,1939576,1939812,1940305,1977021,2054199,2253094,2295719,2575952,2582933,2587904,2629508,2736037,2788531,3973329,4337549,4995921,8140083)
  AND Users.Id = Badges.UserId
  AND Badges.TagBased = 0
) AS Temp
ORDER BY Temp.Id, Temp.YMCA

Enter Parameters

Options:
Switch sites:
loading Hold tight while we fetch your results