SELECT *
FROM london_stages
WHERE eventid IN (47701, 47711, 47716, 47726, 47731, 47741, 47746, 47756, 47761, 47771, 47776, 47876, 48027, 48030, 48031, 48034, 48035, 48037, 48042, 48046, 48048, 48050, 48058, 48060, 48067, 48075, 48106, 48110, 48116, 48120, 48130, 48132, 48138, 48159, 48177, 48187, 48191, 48196, 48201, 48203, 48213, 48217, 48230, 48235, 48240, 48244, 48263, 48268, 48272, 48277, 48282, 48286, 48291, 48293, 48298, 48302, 48307, 48310, 48312, 48316, 48326, 48328, 48335, 48343, 48355, 48357, 48367, 48369, 48371, 48374, 48385, 48410, 49022, 49035, 49050, 49071, 49080, 49089, 49091, 49094, 49096, 49099, 49101, 49102, 49103, 49105, 49107, 49109, 49110, 49111, 49112, 49114, 49116, 49117, 49119, 49120, 49122, 49190, 49198, 49200, 49202, 49204, 49205, 49207, 49210, 49213, 49215, 49218, 49220, 49225, 49227, 49230, 49233, 49239, 49243, 49249, 49255, 49257, 49261, 49273, 49275, 49279, 49285, 49291, 49297, 49299, 49301, 49304, 49311, 49318, 49320, 49323, 49325, 49329, 49332, 49334, 49337, 49339, 49342, 49344, 49347, 49349, 49351, 49356, 49361, 49363, 49365, 49367, 49370, 49375, 49377, 49379, 49381, 49384, 49389, 49395, 49407, 49412, 49415, 49417, 49424, 49435, 49444, 49489, 49521, 49547, 49559, 49562, 49569, 49572, 49574, 49579, 49582, 49584, 49586, 49591, 49593, 49601, 49603, 49606, 49608, 49619, 49624, 49629, 49634, 49636, 49643, 49760, 49765, 49769, 49771, 49773, 49774, 49776, 49778, 49782, 49790, 49793, 49795, 49802, 49808, 49810, 49812, 49816, 49822, 49824, 49828, 49830, 49834, 49838, 49846, 49850, 49852, 49858, 49862, 49866, 49870, 49874, 49876, 49878, 49887, 49890, 49894, 49901, 49904, 49911, 49916, 49925, 49928, 49930, 49934, 49937, 49946, 49951, 49953, 49956, 49958, 49960, 49962, 49965, 49967, 49970, 49972, 49974, 49977, 49979, 49982, 49984, 49986, 49988, 49991, 49993, 49997, 50000, 50003, 50005, 50009, 50012, 50015, 50018, 50022, 50025, 50028, 50030, 50034, 50047, 50051, 50060, 50063, 50066, 50069, 50081, 50086, 50093, 50096, 50098, 50101, 50103, 50105, 50107, 50112, 50115, 50117, 50120, 50122, 50130, 50133, 50137, 50152, 50160, 50188, 50190, 50192, 50218, 50223, 50335, 50339, 50344, 50349, 50351, 50354, 50357, 50377, 50386, 50393, 50395, 50399, 50401, 50403, 50409, 50417, 50419, 50427, 50434, 50448, 50457, 50460, 50462, 50465, 50471, 50474, 50476, 50479, 50481, 50483, 50505, 50507, 50516, 50519, 50521, 50523, 50525, 50528, 50530, 50539, 50545, 50550, 50555, 50563, 50570, 50572, 50575, 50577, 50580, 50582, 50585, 50587, 50590, 50592, 50594, 50596, 50599, 50601, 50604, 50608, 50610, 50613, 50615, 50619, 50622, 50625, 50627, 50631, 50634, 50637, 50639, 50643, 50646, 50649, 50651, 50655, 50658, 50661, 50663, 50673, 50675, 50687, 50689, 50692, 50694, 50703, 50706, 50713, 50730, 50735, 50743, 50746, 50748, 50751, 50761, 50763, 50766, 50768, 50771, 50773, 50781, 50783, 50785, 50789, 50794, 50796, 50799)
GROUP BY eventid
ORDER BY eventdate ASC
OPTION