SELECT *
FROM london_stages
WHERE eventid IN (42341, 42346, 42355, 42365, 42370, 42375, 42384, 42390, 42399, 42404, 42413, 42418, 42423, 42428, 42433, 42438, 42443, 42446, 42453, 42459, 42468, 42473, 42482, 42487, 42492, 42497, 42502, 42511, 42523, 42537, 42542, 42547, 42552, 42572, 42577, 42582, 42587, 42591, 42595, 42600, 42604, 42608, 42613, 42617, 42621, 42626, 42630, 42634, 42639, 42647, 42652, 42656, 42660, 42675, 42680, 42685, 42690, 42695, 42700, 42705, 42710, 42715, 42751, 42763, 42771, 42776, 42779, 42786, 42961, 42966, 42975, 42980, 42989, 42995, 43004, 43013, 43018, 43027, 43032, 43041, 43046, 43055, 43060, 43070, 43075, 43082, 43087, 43096, 43102, 43111, 43116, 43125, 43131, 43135, 43139, 43144, 43159, 43164, 43177, 43181, 43187, 43192, 43196, 43209, 43235, 43240, 43251, 43261, 43286, 43291, 43296, 43311, 43324, 43328, 43334, 43338, 43341, 43345, 43354, 43359, 43362, 43367, 43602, 43616, 43634, 43703, 43713, 43719, 43723, 43727, 43741, 43757, 44259, 44268, 44273, 44282, 44287, 44294, 44300, 44307, 44312, 44320, 44333, 44338, 44342, 44351, 44355, 44390, 44400, 44405, 44410, 44415, 44430, 44435, 44445, 44450, 44465, 44472, 44479, 44485, 44488, 44494, 44497, 44507, 44518, 44522)
GROUP BY eventid
ORDER BY eventdate ASC
OPTION