SELECT *
FROM london_stages
WHERE eventid IN (42458, 42461, 42467, 42470, 42477, 42489, 42491, 42494, 43405, 43482, 43506, 43512, 43525, 43533, 43555, 43568, 43577, 43659, 43668, 43689, 43707, 43732, 43764, 43770, 43783, 43794, 43811, 43823, 43855, 43882, 43891, 43985, 43988, 43991, 44013, 44029, 44048, 44087, 44127, 44290, 44341, 44399, 44421, 44556, 44559, 44580, 44586, 44645, 44668, 44696, 44857, 44887, 44927, 44949, 44966, 45032, 45278, 45326, 45347, 45722, 45754, 45885, 45993, 46024, 46046, 46074, 46112, 46142, 46336, 46373, 46590, 46612, 46622, 46639, 46695, 46879, 47244, 47709, 47719, 47739, 47744, 47764, 47774, 47792, 47845, 47882, 47894, 48121, 48125, 48320, 48322, 48358, 48366, 48368, 48509, 48510, 48514, 48602, 48623, 48832, 49069, 49768, 49823, 50192, 50195, 50350, 50391, 50762, 50763, 50777, 51370, 51645, 51650, 51657, 51659, 51681, 52057, 52286, 52500, 52510)
GROUP BY eventid
ORDER BY eventdate ASC
OPTION