SELECT *
FROM london_stages
WHERE eventid IN (31437, 31439, 31441, 31443, 31445, 31448, 31451, 31453, 31455, 31457, 31459, 31462, 31465, 31467, 31470, 31472, 31474, 31477, 31480, 31484, 31491, 31494, 31496, 31500, 31502, 31504, 31506, 31510, 31523, 31526, 31535, 31569, 31605, 31617, 31626, 31642, 31657, 31673, 31689, 31700, 31731, 31740, 31771, 31877, 31881, 31885, 31887, 32235, 32258, 32264, 32366, 32666, 32671, 32676, 32724, 32748, 32813, 32815, 32817, 32822, 32838, 33106, 46407, 46409, 46411, 46413, 46415, 46417, 46419, 46421, 46423, 46425, 46427, 46429, 46431, 46433, 46436, 46438, 46441, 46443, 46446, 46448, 46452, 46455, 46457, 46460, 46462, 46464, 46466, 46469, 46471, 46476, 46478, 46481, 46486, 46492, 46495, 46509, 46511, 46515, 46522, 46529, 46536, 46566, 46593, 46700, 46711, 46729, 46905, 46917, 46941, 46949, 48650, 48672, 48712, 48722, 48737, 48837, 50486, 50488, 50491, 50493, 50495, 50497, 50500, 50502, 50505, 50507, 50509, 50511, 50514, 50523, 50528, 50537, 50542, 50558, 50570, 51877, 51927, 51929)
GROUP BY eventid
ORDER BY eventdate ASC
OPTION