SELECT Users.Id, CONVERT(date, Badges.Date) AS Date, Badg...

0

Please login or register to vote for this query.

(click on this box to dismiss)

Ukrainian Language Meta

Q&A about the site for linguists, teachers and students of the Ukrainian language

SELECT Users.Id, CONVERT(date, Badges.Date) AS Date, Badges.Name
FROM Users, Badges
WHERE Users.Id IN (1145153,1153105,1161201,1167683,1169873,1173614,1174342,1174819,1178761,1181213,1191058,1199861,1205601,1212462,1214205,1218617,1220720,1236342,1248319,1253279,1262256,1266954,1278121,1284597,1292423,1295050,1307401,1310181,1310320,1325599,1329500,1330415,1330570,1331651,1335017,1344168,1353950,1354853,1360399,1380026,1383965,1386445,1387145,1401505,1403901,1410978,1416921,1417732,1424090,1427573,1464089,1470180,1475397,1477153,1493826,1497028,1497898,1508549,1516601,1525193,1525673,1547639,1548620,1550956,1559384,1576012,1576559,1578653,1588811,1591376,1593096,1596929,1602305,1603648,1606426,1609314,1609494,1617525,1618921,1625896,1626874,1631190,1634903,1638754,1641076,1645265,1653301,1655274,1658129,1658343,1664036,1665562,1676627,1678246,1682014,1683319,1685467,1687345,1688346,1692330,1704944,1708710,1710728,1713755,1720394,1729199,1734635,1736877,1738122,1759793,1763937,1764567,1789650,1790610,1793644,1803940,1808761,1809767,1819825,1842107,1845062,1856255,1881239,1882469,1895779,1904930,1905464,1916243,1919819,1936362)
AND Users.Id = Badges.UserId
AND Badges.TagBased = 0
ORDER BY Users.Id, Badges.Date

Enter Parameters

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