SELECT *
FROM london_stages
WHERE eventid IN (31786, 31788, 31789, 31790, 31794, 31795, 31797, 31799, 31801, 31802, 31805, 31808, 31810, 31811, 31815, 31816, 31819, 31820, 33224, 33225, 33226, 33227, 33228, 33229, 33230, 33231, 33232, 33233, 33234, 33241, 33243, 33244, 33245, 33250, 33252, 33256, 33257, 35979, 37109, 37121, 37125, 37135, 37137, 37139, 37141, 37143, 37144, 37146, 37148, 37149, 37154, 37160, 37162, 37163, 37165, 37167, 37168, 37170, 37172, 37173, 37175, 37177, 37178, 37179, 37180, 37183, 37186, 37190, 37193, 37195, 37199, 37201, 37204, 37207, 37210, 37531, 37685, 37689, 37692, 37702, 37705, 37707, 37708, 37713, 37717, 37723, 37733, 37755, 37756, 37757, 37759, 37764, 37767, 37768, 37769, 37772, 37777, 38212, 38218, 38223, 38229, 38235, 38241, 38246, 38250, 38253, 38254, 38256, 38257, 38259, 38260, 38261, 38263, 38265, 38267, 38269, 38270, 38271, 38276, 38277, 38278, 38279, 38280, 38281, 38284, 38289, 38290, 38291, 38292, 38293, 38294, 38297, 38299, 38300, 38301, 38304, 38306, 38307, 38308, 38842, 38843, 38844, 38845)
GROUP BY eventid
ORDER BY eventdate ASC
OPTION