SELECT *
FROM london_stages
WHERE eventid IN (42116, 42123, 42165, 42277, 42436, 42533, 42535, 42540, 42548, 42560, 42596, 42703, 42861, 42867, 42869, 42872, 42873, 42875, 42883, 42905, 42919, 42925, 42935, 42951, 42981, 42987, 42990, 42993, 43011, 43030, 43033, 43042, 43056, 43154, 43246, 43262, 43276, 43287, 43299, 43440, 43487, 43493, 43495, 43614, 43865, 44084, 44110, 46147, 46549, 46551, 46560, 46574, 46577, 46589, 46603, 46618, 46677, 46704, 46738, 46857, 47237, 49419, 49431, 49433, 49438, 49440, 49444, 49448, 49451, 49453, 49457, 49461, 49464, 49466, 49471, 49474, 49477, 49479, 49484, 49489, 49492, 49494, 49499, 49503, 49506, 49508, 49512, 49516, 49519, 49521, 49524, 49526, 49528, 49530, 49533, 49538, 49555, 49582, 49584, 49586, 49591, 49601, 49611, 49951, 49953, 49956, 49958)
GROUP BY eventid
ORDER BY eventdate ASC
OPTION