SELECT *
FROM london_stages
WHERE eventid IN (46122, 46128, 46134, 46167, 46172, 46182, 46184, 46229, 46231, 46232, 46233, 46234, 46238, 46239, 46735, 46742, 46753, 46770, 46791, 46801, 46809, 46812, 47327, 47341, 47356, 47362, 47363, 47366, 47368, 47374, 47414, 47924, 47926, 47930, 47941, 47943, 47946, 47949, 47952, 47955, 47956, 47960, 47977, 47988, 47989, 47990, 48453, 48458, 48461, 48466, 48475, 48486, 48493, 48498, 48506, 48507, 48508, 48509, 48510, 48511, 48513, 48514, 48515, 48517, 48518, 48519, 48520, 48522, 48523, 48525, 48526, 48527, 48529, 48531, 48533, 48534, 48871, 48900, 49128, 49135, 49141, 49144, 49160, 49182, 49183, 49665, 49685, 49691, 49693, 49707, 49711, 49719, 49723, 49738, 50012, 50101, 50105, 50107, 50115, 50117, 50120, 50122, 50130, 50296, 50305, 50838, 50841, 50848, 51402, 52588, 52589, 52590, 52591, 52592, 52593, 52595, 52597, 52599)
GROUP BY eventid
ORDER BY eventdate ASC
OPTION