MariaDB 10.5

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

CREATE TABLE `events` (
  `ID` int(10) UNSIGNED NOT NULL,
  `evt_id` varchar(10) NOT NULL,
  `service` int(1) DEFAULT NULL,
  `start` datetime NOT NULL,
  `end` datetime NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

INSERT INTO `events` (`ID`, `evt_id`, `service`, `start`, `end`) VALUES
(464, '5423', 2, '2021-06-21 18:00:00', '2021-06-21 19:00:00'),
(465, '5424', 3, '2021-06-22 18:00:00', '2021-06-22 19:00:00'),
(474, '5436', 0, '2021-06-19 09:00:00', '2021-06-19 10:00:00'),
(475, '5437', 0, '2021-06-23 18:00:00', '2021-06-23 21:00:00'),
(476, '5438', 0, '2021-06-24 16:00:00', '2021-06-24 17:00:00'),
(477, '5439', 2, '2021-06-21 16:00:00', '2021-06-21 17:00:00'),
(478, '5441', 2, '2021-06-21 17:00:00', '2021-06-21 18:00:00'),
(479, '5442', 1, '2021-06-30 17:00:00', '2021-06-30 18:00:00'),
(480, '5443', 1, '2021-06-28 17:00:00', '2021-06-28 18:00:00'),
(484, '5447', 1, '2021-06-23 17:00:00', '2021-06-23 18:00:00'),
(486, '5449', 2, '2021-06-22 17:00:00', '2021-06-22 18:00:00'),
(491, '5450', 2, '2021-06-23 16:00:00', '2021-06-23 17:00:00'),
(494, '5455', 1, '2021-06-25 15:00:00', '2021-06-25 16:00:00'),
(495, '5456', 2, '2021-06-25 16:00:00', '2021-06-25 17:00:00'),
(496, '5457', 1, '2021-06-25 17:00:00', '2021-06-25 18:00:00'),
(497, '5458', 3, '2021-06-25 18:00:00', '2021-06-25 19:00:00'),
(498, '5459', 2, '2021-06-25 14:00:00', '2021-06-25 15:00:00');

Records: 17  Duplicates: 0  Warnings: 0

freetime
2023-09-30 14:00:00
2023-09-30 15:00:00
2023-09-30 16:00:00
2023-09-30 17:00:00
2023-09-30 18:00:00
2023-10-01 14:00:00
2023-10-01 15:00:00
2023-10-01 16:00:00
2023-10-01 17:00:00
2023-10-01 18:00:00
2023-10-02 14:00:00
2023-10-02 15:00:00
2023-10-02 16:00:00
2023-10-02 17:00:00
2023-10-02 18:00:00
2023-10-03 14:00:00
2023-10-03 15:00:00
2023-10-03 16:00:00
2023-10-03 17:00:00
2023-10-03 18:00:00
2023-10-04 14:00:00
2023-10-04 15:00:00
2023-10-04 16:00:00
2023-10-04 17:00:00
2023-10-04 18:00:00
2023-10-05 14:00:00
2023-10-05 15:00:00
2023-10-05 16:00:00
2023-10-05 17:00:00
2023-10-05 18:00:00
2023-10-06 14:00:00
2023-10-06 15:00:00
2023-10-06 16:00:00
2023-10-06 17:00:00
2023-10-06 18:00:00
2023-10-07 14:00:00
2023-10-07 15:00:00
2023-10-07 16:00:00
2023-10-07 17:00:00
2023-10-07 18:00:00
2023-10-08 14:00:00
2023-10-08 15:00:00
2023-10-08 16:00:00
2023-10-08 17:00:00
2023-10-08 18:00:00
2023-10-09 14:00:00
2023-10-09 15:00:00
2023-10-09 16:00:00
2023-10-09 17:00:00
2023-10-09 18:00:00
2023-10-10 14:00:00
2023-10-10 15:00:00
2023-10-10 16:00:00
2023-10-10 17:00:00
2023-10-10 18:00:00
2023-10-11 14:00:00
2023-10-11 15:00:00
2023-10-11 16:00:00
2023-10-11 17:00:00
2023-10-11 18:00:00
2023-10-12 14:00:00
2023-10-12 15:00:00
2023-10-12 16:00:00
2023-10-12 17:00:00
2023-10-12 18:00:00
2023-10-13 14:00:00
2023-10-13 15:00:00
2023-10-13 16:00:00
2023-10-13 17:00:00
2023-10-13 18:00:00
2023-10-14 14:00:00
2023-10-14 15:00:00
2023-10-14 16:00:00
2023-10-14 17:00:00
2023-10-14 18:00:00
2023-10-15 14:00:00
2023-10-15 15:00:00
2023-10-15 16:00:00
2023-10-15 17:00:00
2023-10-15 18:00:00
2023-10-16 14:00:00
2023-10-16 15:00:00
2023-10-16 16:00:00
2023-10-16 17:00:00
2023-10-16 18:00:00
2023-10-17 14:00:00
2023-10-17 15:00:00
2023-10-17 16:00:00
2023-10-17 17:00:00
2023-10-17 18:00:00
2023-10-18 14:00:00
2023-10-18 15:00:00
2023-10-18 16:00:00
2023-10-18 17:00:00
2023-10-18 18:00:00
2023-10-19 14:00:00
2023-10-19 15:00:00
2023-10-19 16:00:00
2023-10-19 17:00:00
2023-10-19 18:00:00
2023-10-20 14:00:00
2023-10-20 15:00:00
2023-10-20 16:00:00
2023-10-20 17:00:00
2023-10-20 18:00:00
2023-10-21 14:00:00
2023-10-21 15:00:00
2023-10-21 16:00:00
2023-10-21 17:00:00
2023-10-21 18:00:00
2023-10-22 14:00:00
2023-10-22 15:00:00
2023-10-22 16:00:00
2023-10-22 17:00:00
2023-10-22 18:00:00
2023-10-23 14:00:00
2023-10-23 15:00:00
2023-10-23 16:00:00
2023-10-23 17:00:00
2023-10-23 18:00:00
2023-10-24 14:00:00
2023-10-24 15:00:00
2023-10-24 16:00:00
2023-10-24 17:00:00
2023-10-24 18:00:00
2023-10-25 14:00:00
2023-10-25 15:00:00
2023-10-25 16:00:00
2023-10-25 17:00:00
2023-10-25 18:00:00
2023-10-26 14:00:00
2023-10-26 15:00:00
2023-10-26 16:00:00
2023-10-26 17:00:00
2023-10-26 18:00:00
2023-10-27 14:00:00
2023-10-27 15:00:00
2023-10-27 16:00:00
2023-10-27 17:00:00
2023-10-27 18:00:00
2023-10-28 14:00:00
2023-10-28 15:00:00
2023-10-28 16:00:00
2023-10-28 17:00:00
2023-10-28 18:00:00
2023-10-29 14:00:00
2023-10-29 15:00:00
2023-10-29 16:00:00
2023-10-29 17:00:00
2023-10-29 18:00:00
2023-10-30 14:00:00
2023-10-30 15:00:00
2023-10-30 16:00:00
2023-10-30 17:00:00
2023-10-30 18:00:00