aus Gründen mussten wir die Flug-Richtung in den Buchungen korrigieren... Verantwortlicher: NFL, RKU Zeitpunkt: 2022-10-07 14:26-15:01 Uhr Kunden: MED,FER,FOR und LMX Task: XRES-9636 ======================== xres_fer_bookings> UPDATE `flight` SET `direction`=4 where direction = 3 and arr_date > '2022-09-23' and type = "RT" [2022-09-23 14:26:57] 14 rows affected in 1 s 855 ms xres_fer_bookings> UPDATE `flight` SET `direction`=1 where direction = 3 and arr_date > '2022-09-23' and type = "OW" AND `parsed_times` LIKE '%outward_flight%' AND `parsed_times` NOT LIKE '%"outward_flight";a:0:{}%' AND ( `parsed_times` NOT LIKE '%return_flight%' or `parsed_times` LIKE '%"return_flight";a:0:{}%' ) [2022-09-23 14:30:53] 232 rows affected in 1 s 877 ms xres_fer_bookings> update `flight` set `direction`=2 where direction = 3 and arr_date > '2022-09-23' and type = "OW" AND `parsed_times` LIKE '%return_flight%' AND `parsed_times` NOT LIKE '%"return_flight";a:0:{}%' AND ( `parsed_times` NOT LIKE '%outward_flight%' or `parsed_times` LIKE '%"outward_flight";a:0:{}%' ) [2022-09-23 14:32:06] 231 rows affected in 1 s 880 ms xres_lmx_bookings> UPDATE `flight` SET `direction`=4 where direction = 3 and arr_date > '2022-09-22' and type = "RT" [2022-09-23 14:46:19] 162 rows affected in 3 s 665 ms xres_lmx_bookings> UPDATE `flight` SET `direction`=1 where direction = 3 an1:42d arr_date > '2022-09-23' and type = "OW" AND `parsed_times` LIKE '%outward_flight%' AND `parsed_times` NOT LIKE '%"outward_flight";a:0:{}%' AND ( `parsed_times` NOT LIKE '%return_flight%' or `parsed_times` LIKE '%"return_flight";a:0:{}%' ) [2022-09-23 14:47:30] 102 rows affected in 3 s 635 ms xres_lmx_bookings> update `flight` set `direction`=2 where direction = 3 and arr_date
'2022-09-23' and type = "OW" AND `parsed_times` LIKE '%return_flight%' AND `parsed_times` NOT LIKE '%"return_flight";a:0:{}%' AND (
`parsed_times` NOT LIKE '%outward_flight%' or `parsed_times` LIKE '%"outward_flight";a:0:{}%' ) [2022-09-23 14:48:35] 102 rows affected in 3 s 625 ms xres_for_bookings> UPDATE `flight` SET `direction`=4 where direction = 3 and arr_date > '2022-09-23' and type = "RT" [2022-09-23 14:54:27] 112 rows affected in 767 ms xres_for_bookings> UPDATE `flight` SET `direction`=1 where direction = 3 and arr_date > '2022-09-23' and type = "OW" AND `parsed_times` LIKE '%outward_flight%' AND `parsed_times` NOT LIKE '%"outward_flight";a:0:{}%' AND ( `parsed_times` NOT LIKE '%return_flight%' or `parsed_times` LIKE '%"return_flight";a:0:{}%' ) [2022-09-23 14:55:16] 5 rows affected in 756 ms xres_for_bookings> update `flight` set `direction`=2 where direction = 3 and arr_date > '2022-09-23' and type = "OW" AND `parsed_times` LIKE '%return_flight%' AND `parsed_times` NOT LIKE '%"return_flight";a:0:{}%' AND ( `parsed_times` NOT LIKE '%outward_flight%' or `parsed_times` LIKE '%"outward_flight";a:0:{}%' ) [2022-09-23 14:55:51] 5 rows affected in 733 ms xres_med_bookings> UPDATE `flight` SET `direction`=4 where direction = 3 and arr_date > '2022-09-23' and type = "RT" [2022-09-23 15:01:04] 36 rows affected in 64 ms