aus Gründen mussten wir die Flug-Richtung in den Buchungen korrigieren... Verantwortlicher: JFL, RKU Zeitpunkt: 2022-09-22 16:28 - 16:46 Uhr Kunden: LMX, FER Task: XRES-9636 xres_lmx_bookings> UPDATE `flight` SET `direction`=4 where direction = 3 and arr_date > '2022-09-23' and type = "RT" [2022-09-22 16:28:12] 685 rows affected in 3 s 633 ms xres_lmx_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-22 16:33:35] 360 rows affected in 4 s 113 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-22 16:37:29] 360 rows affected in 10 s 678 ms xres_fer_bookings> UPDATE `flight` SET `direction`=4 where direction = 3 and arr_date > '2022-09-22' and type = "RT" [2022-09-22 16:41:42] 429 rows affected in 1 s 891 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-22 16:44:19] 440 rows affected in 1 s 842 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-22 16:46:21] 538 rows affected in 1 s 874 ms