| Command Name | Command Text | Milliseconds | Date Time | |
|---|---|---|---|---|
| BookingEventHistory | select top 50 be.date_time as date_time ,'Booking' as history_event_group_name ,betr.booking_event_type_name as history_event_type_name ,be.comment as history_event_description from booking_event as be inner join booking_event_type_ref as betr on betr.booking_event_type_rcd = be.booking_event_type_rcd where be.booking_id = '92dc6e1f-8db8-468b-9e53-a88248a18415' union select top 50 bp.date_time as date_time ,'Passenger' as history_event_group_name ,dsr.default_state_name as history_event_type_name ,pa.passenger_name as history_event_description from booking_passenger as bp inner join passenger as pa on pa.passenger_id = bp.passenger_id inner join default_state_ref as dsr on dsr.default_state_rcd = bp.default_state_rcd where bp.booking_id = '92dc6e1f-8db8-468b-9e53-a88248a18415' union select top 50 bfs.date_time as date_time ,'Flight' as history_event_group_name ,dsr.default_state_name as history_event_type_name ,ai.airline_identifier_code + ' ' + fi.flight_identifier_code + ' ' + dai.airport_identifier_code + ' ' + da.airport_name + ' ' + aai.airport_identifier_code + ' ' + aa.airport_name as history_event_description from booking_flight_segment as bfs inner join flight_segment as fs on fs.flight_segment_id = bfs.flight_segment_id inner join flight as fl on fl.flight_id = fs.flight_id inner join default_state_ref as dsr on dsr.default_state_rcd = bfs.default_state_rcd inner join airline_identifier as ai on ai.airline_id = fl.airline_id and ai.airline_identifier_type_rcd = dbo.ref('airline_identifier_type_ref.AC3') inner join airport as da on da.airport_id = fl.departure_airport_id inner join airport as aa on aa.airport_id = fl.arrival_airport_id inner join airport_identifier as dai on dai.airport_id = fl.departure_airport_id and dai.airport_identifier_type_rcd = dbo.ref('airport_identifier_type_ref.AC3') inner join airport_identifier as aai on aai.airport_id = fl.arrival_airport_id and aai.airport_identifier_type_rcd = dbo.ref('airport_identifier_type_ref.AC3') left join flight_identifier as fi on fi.flight_id = fl.flight_id and fi.flight_identifier_type_rcd = dbo.ref('flight_identifier_type_ref.FN3') where bfs.booking_id = '92dc6e1f-8db8-468b-9e53-a88248a18415' --realwhere order by date_time | 724 | 5/9/2024 9:22:23 PM | Edit | Delete |
| BookingFinancialPayments | -- cash select top 50 fbt.transaction_number ,fbt.date_time ,fp.financial_payment_type_rcd ,fptr.financial_payment_type_name ,fpc.amount as paid_currency_amount ,fpcc.financial_currency_type_rcd as paid_currency_type ,fpcc.equals_amount as exchange_rate ,fbt.amount as booking_currency_amount ,fc.financial_currency_type_rcd as booking_currency_type ,'' as payment_description ,fcc.financial_costcentre_code ,fcc.financial_costcentre_name ,du.default_user_code ,du.default_user_name ,fbt.financial_payment_id from financial_booking_transaction as fbt inner join financial_currency as fc on fc.financial_currency_id = fbt.financial_currency_id inner join financial_payment as fp on fp.financial_payment_id = fbt.financial_payment_id inner join financial_payment_type_ref as fptr on fptr.financial_payment_type_rcd = fp.financial_payment_type_rcd inner join financial_payment_cash as fpc on fpc.financial_payment_cash_id = fp.financial_payment_cash_id inner join financial_currency as fpcc on fpcc.financial_currency_id = fpc.financial_currency_id inner join financial_costcentre as fcc on fcc.financial_costcentre_id = fbt.financial_costcentre_id inner join default_user as du on du.default_user_id = fbt.user_id where fbt.booking_id = '00000000-0000-0000-0000-000000000000' union -- voucher select top 50 fbt.transaction_number ,fbt.date_time ,fp.financial_payment_type_rcd ,fptr.financial_payment_type_name ,fpv.amount as paid_currency_amount ,fvc.financial_currency_type_rcd as paid_currency_type ,fc.equals_amount as exchange_rate ,fbt.amount as booking_currency_amount ,fc.financial_currency_type_rcd as booking_currency_type ,'Voucher:' + cast(fv.voucher_number as varchar(20)) + coalesce( ', ' + fv.voucher_description, '') as payment_description ,fcc.financial_costcentre_code ,fcc.financial_costcentre_name ,du.default_user_code ,du.default_user_name ,fbt.financial_payment_id from financial_booking_transaction as fbt inner join financial_currency as fc on fc.financial_currency_id = fbt.financial_currency_id inner join financial_payment as fp on fp.financial_payment_id = fbt.financial_payment_id inner join financial_payment_type_ref as fptr on fptr.financial_payment_type_rcd = fp.financial_payment_type_rcd inner join financial_payment_voucher as fpv on fpv.financial_payment_voucher_id = fp.financial_payment_voucher_id inner join financial_voucher as fv on fv.financial_voucher_id = fpv.financial_voucher_id inner join financial_currency as fvc on fvc.financial_currency_id = fpv.financial_currency_id inner join financial_costcentre as fcc on fcc.financial_costcentre_id = fbt.financial_costcentre_id inner join default_user as du on du.default_user_id = fbt.user_id where fbt.booking_id = '00000000-0000-0000-0000-000000000000' union -- card select top 50 fbt.transaction_number ,fbt.date_time ,fp.financial_payment_type_rcd ,fptr.financial_payment_type_name ,fpc.amount as paid_currency_amount ,fpcc.financial_currency_type_rcd as paid_currency_type ,fpcc.equals_amount as exchange_rate ,fbt.amount as booking_currency_amount ,fc.financial_currency_type_rcd as booking_currency_type ,'Card: ' + fpc.financial_card_type_rcd as payment_description ,fcc.financial_costcentre_code ,fcc.financial_costcentre_name ,du.default_user_code ,du.default_user_name ,fbt.financial_payment_id from financial_booking_transaction as fbt inner join financial_currency as fc on fc.financial_currency_id = fbt.financial_currency_id inner join financial_payment as fp on fp.financial_payment_id = fbt.financial_payment_id inner join financial_payment_type_ref as fptr on fptr.financial_payment_type_rcd = fp.financial_payment_type_rcd inner join financial_payment_card as fpc on fpc.financial_payment_card_id = fp.financial_payment_card_id inner join financial_currency as fpcc on fpcc.financial_currency_id = fpc.financial_currency_id inner join financial_costcentre as fcc on fcc.financial_costcentre_id = fbt.financial_costcentre_id inner join default_user as du on du.default_user_id = fbt.user_id where fbt.booking_id = '00000000-0000-0000-0000-000000000000' union -- bank select top 50 fbt.transaction_number ,fbt.date_time ,fp.financial_payment_type_rcd ,fptr.financial_payment_type_name ,fpb.amount as paid_currency_amount ,fpbc.financial_currency_type_rcd as paid_currency_type ,fpbc.equals_amount as exchange_rate ,fbt.amount as booking_currency_amount ,fc.financial_currency_type_rcd as booking_currency_type ,'Bank: ' + fpb.financial_bank_account_number_type_rcd as payment_description ,fcc.financial_costcentre_code ,fcc.financial_costcentre_name ,du.default_user_code ,du.default_user_name ,fbt.financial_payment_id from financial_booking_transaction as fbt inner join financial_currency as fc on fc.financial_currency_id = fbt.financial_currency_id inner join financial_payment as fp on fp.financial_payment_id = fbt.financial_payment_id inner join financial_payment_type_ref as fptr on fptr.financial_payment_type_rcd = fp.financial_payment_type_rcd inner join financial_payment_bank as fpb on fpb.financial_payment_bank_id = fp.financial_payment_bank_id inner join financial_currency as fpbc on fpbc.financial_currency_id = fpb.financial_currency_id inner join financial_costcentre as fcc on fcc.financial_costcentre_id = fbt.financial_costcentre_id inner join default_user as du on du.default_user_id = fbt.user_id where fbt.booking_id = '00000000-0000-0000-0000-000000000000' order by fbt.transaction_number | 685 | 5/18/2024 9:35:45 AM | Edit | Delete |
| BookingFinancialPayments | -- cash select top 50 fbt.transaction_number ,fbt.date_time ,fp.financial_payment_type_rcd ,fptr.financial_payment_type_name ,fpc.amount as paid_currency_amount ,fpcc.financial_currency_type_rcd as paid_currency_type ,fpcc.equals_amount as exchange_rate ,fbt.amount as booking_currency_amount ,fc.financial_currency_type_rcd as booking_currency_type ,'' as payment_description ,fcc.financial_costcentre_code ,fcc.financial_costcentre_name ,du.default_user_code ,du.default_user_name ,fbt.financial_payment_id from financial_booking_transaction as fbt inner join financial_currency as fc on fc.financial_currency_id = fbt.financial_currency_id inner join financial_payment as fp on fp.financial_payment_id = fbt.financial_payment_id inner join financial_payment_type_ref as fptr on fptr.financial_payment_type_rcd = fp.financial_payment_type_rcd inner join financial_payment_cash as fpc on fpc.financial_payment_cash_id = fp.financial_payment_cash_id inner join financial_currency as fpcc on fpcc.financial_currency_id = fpc.financial_currency_id inner join financial_costcentre as fcc on fcc.financial_costcentre_id = fbt.financial_costcentre_id inner join default_user as du on du.default_user_id = fbt.user_id where fbt.booking_id = '00000000-0000-0000-0000-000000000000' union -- voucher select top 50 fbt.transaction_number ,fbt.date_time ,fp.financial_payment_type_rcd ,fptr.financial_payment_type_name ,fpv.amount as paid_currency_amount ,fvc.financial_currency_type_rcd as paid_currency_type ,fc.equals_amount as exchange_rate ,fbt.amount as booking_currency_amount ,fc.financial_currency_type_rcd as booking_currency_type ,'Voucher:' + cast(fv.voucher_number as varchar(20)) + coalesce( ', ' + fv.voucher_description, '') as payment_description ,fcc.financial_costcentre_code ,fcc.financial_costcentre_name ,du.default_user_code ,du.default_user_name ,fbt.financial_payment_id from financial_booking_transaction as fbt inner join financial_currency as fc on fc.financial_currency_id = fbt.financial_currency_id inner join financial_payment as fp on fp.financial_payment_id = fbt.financial_payment_id inner join financial_payment_type_ref as fptr on fptr.financial_payment_type_rcd = fp.financial_payment_type_rcd inner join financial_payment_voucher as fpv on fpv.financial_payment_voucher_id = fp.financial_payment_voucher_id inner join financial_voucher as fv on fv.financial_voucher_id = fpv.financial_voucher_id inner join financial_currency as fvc on fvc.financial_currency_id = fpv.financial_currency_id inner join financial_costcentre as fcc on fcc.financial_costcentre_id = fbt.financial_costcentre_id inner join default_user as du on du.default_user_id = fbt.user_id where fbt.booking_id = '00000000-0000-0000-0000-000000000000' union -- card select top 50 fbt.transaction_number ,fbt.date_time ,fp.financial_payment_type_rcd ,fptr.financial_payment_type_name ,fpc.amount as paid_currency_amount ,fpcc.financial_currency_type_rcd as paid_currency_type ,fpcc.equals_amount as exchange_rate ,fbt.amount as booking_currency_amount ,fc.financial_currency_type_rcd as booking_currency_type ,'Card: ' + fpc.financial_card_type_rcd as payment_description ,fcc.financial_costcentre_code ,fcc.financial_costcentre_name ,du.default_user_code ,du.default_user_name ,fbt.financial_payment_id from financial_booking_transaction as fbt inner join financial_currency as fc on fc.financial_currency_id = fbt.financial_currency_id inner join financial_payment as fp on fp.financial_payment_id = fbt.financial_payment_id inner join financial_payment_type_ref as fptr on fptr.financial_payment_type_rcd = fp.financial_payment_type_rcd inner join financial_payment_card as fpc on fpc.financial_payment_card_id = fp.financial_payment_card_id inner join financial_currency as fpcc on fpcc.financial_currency_id = fpc.financial_currency_id inner join financial_costcentre as fcc on fcc.financial_costcentre_id = fbt.financial_costcentre_id inner join default_user as du on du.default_user_id = fbt.user_id where fbt.booking_id = '00000000-0000-0000-0000-000000000000' union -- bank select top 50 fbt.transaction_number ,fbt.date_time ,fp.financial_payment_type_rcd ,fptr.financial_payment_type_name ,fpb.amount as paid_currency_amount ,fpbc.financial_currency_type_rcd as paid_currency_type ,fpbc.equals_amount as exchange_rate ,fbt.amount as booking_currency_amount ,fc.financial_currency_type_rcd as booking_currency_type ,'Bank: ' + fpb.financial_bank_account_number_type_rcd as payment_description ,fcc.financial_costcentre_code ,fcc.financial_costcentre_name ,du.default_user_code ,du.default_user_name ,fbt.financial_payment_id from financial_booking_transaction as fbt inner join financial_currency as fc on fc.financial_currency_id = fbt.financial_currency_id inner join financial_payment as fp on fp.financial_payment_id = fbt.financial_payment_id inner join financial_payment_type_ref as fptr on fptr.financial_payment_type_rcd = fp.financial_payment_type_rcd inner join financial_payment_bank as fpb on fpb.financial_payment_bank_id = fp.financial_payment_bank_id inner join financial_currency as fpbc on fpbc.financial_currency_id = fpb.financial_currency_id inner join financial_costcentre as fcc on fcc.financial_costcentre_id = fbt.financial_costcentre_id inner join default_user as du on du.default_user_id = fbt.user_id where fbt.booking_id = '00000000-0000-0000-0000-000000000000' order by fbt.transaction_number | 795 | 5/13/2024 12:24:23 PM | Edit | Delete |
| BookingFlightsSimple | select top 50 bfs.booking_flight_segment_id ,fs.flight_id ,fs.departure_airport_id ,fs.arrival_airport_id ,ff.amount ,ff.financial_currency_id ,ff.financial_fare_id from booking_flight_segment as bfs inner join flight_segment as fs on fs.flight_segment_id = bfs.flight_segment_id inner join financial_fare as ff on ff.departure_airport_id = fs.departure_airport_id and ff.arrival_airport_id = fs.arrival_airport_id where bfs.booking_id = 'a79d281a-02a4-41ce-9861-988628c11940' and bfs.became_booking_flight_segment_id is null and bfs.default_state_rcd <> dbo.ref('default_state_ref.I') | 534 | 5/12/2024 10:55:50 AM | Edit | Delete |
| BookingFlightsSimple | select top 50 bfs.booking_flight_segment_id ,fs.flight_id ,fs.departure_airport_id ,fs.arrival_airport_id ,ff.amount ,ff.financial_currency_id ,ff.financial_fare_id from booking_flight_segment as bfs inner join flight_segment as fs on fs.flight_segment_id = bfs.flight_segment_id inner join financial_fare as ff on ff.departure_airport_id = fs.departure_airport_id and ff.arrival_airport_id = fs.arrival_airport_id where bfs.booking_id = '63d02fab-7686-4930-a5d5-02c36e6d9d62' and bfs.became_booking_flight_segment_id is null and bfs.default_state_rcd <> dbo.ref('default_state_ref.I') | 1027 | 5/10/2024 9:55:50 PM | Edit | Delete |
| BookingFlightsSimple | select top 50 bfs.booking_flight_segment_id ,fs.flight_id ,fs.departure_airport_id ,fs.arrival_airport_id ,ff.amount ,ff.financial_currency_id ,ff.financial_fare_id from booking_flight_segment as bfs inner join flight_segment as fs on fs.flight_segment_id = bfs.flight_segment_id inner join financial_fare as ff on ff.departure_airport_id = fs.departure_airport_id and ff.arrival_airport_id = fs.arrival_airport_id where bfs.booking_id = 'c70edd36-4590-49ac-962a-e6161f837fa1' and bfs.became_booking_flight_segment_id is null and bfs.default_state_rcd <> dbo.ref('default_state_ref.I') | 1041 | 5/13/2024 1:55:55 AM | Edit | Delete |
| BookingFlightsSimple | select top 50 bfs.booking_flight_segment_id ,fs.flight_id ,fs.departure_airport_id ,fs.arrival_airport_id ,ff.amount ,ff.financial_currency_id ,ff.financial_fare_id from booking_flight_segment as bfs inner join flight_segment as fs on fs.flight_segment_id = bfs.flight_segment_id inner join financial_fare as ff on ff.departure_airport_id = fs.departure_airport_id and ff.arrival_airport_id = fs.arrival_airport_id where bfs.booking_id = '2c1f5690-6360-4d81-91ad-e20ac9c70853' and bfs.became_booking_flight_segment_id is null and bfs.default_state_rcd <> dbo.ref('default_state_ref.I') | 530 | 5/13/2024 10:55:44 AM | Edit | Delete |
| BookingFlightsSimple | select top 50 bfs.booking_flight_segment_id ,fs.flight_id ,fs.departure_airport_id ,fs.arrival_airport_id ,ff.amount ,ff.financial_currency_id ,ff.financial_fare_id from booking_flight_segment as bfs inner join flight_segment as fs on fs.flight_segment_id = bfs.flight_segment_id inner join financial_fare as ff on ff.departure_airport_id = fs.departure_airport_id and ff.arrival_airport_id = fs.arrival_airport_id where bfs.booking_id = '2d00d163-9d23-4ae9-b1b2-303c189530a4' and bfs.became_booking_flight_segment_id is null and bfs.default_state_rcd <> dbo.ref('default_state_ref.I') | 1038 | 5/11/2024 6:55:50 PM | Edit | Delete |
| BookingFlightsSimple | select top 50 bfs.booking_flight_segment_id ,fs.flight_id ,fs.departure_airport_id ,fs.arrival_airport_id ,ff.amount ,ff.financial_currency_id ,ff.financial_fare_id from booking_flight_segment as bfs inner join flight_segment as fs on fs.flight_segment_id = bfs.flight_segment_id inner join financial_fare as ff on ff.departure_airport_id = fs.departure_airport_id and ff.arrival_airport_id = fs.arrival_airport_id where bfs.booking_id = 'ad73c5d9-4d9b-4958-975f-0d77b855c85b' and bfs.became_booking_flight_segment_id is null and bfs.default_state_rcd <> dbo.ref('default_state_ref.I') | 1028 | 5/9/2024 1:56:22 PM | Edit | Delete |
| BookingFlightsSimple | select top 50 bfs.booking_flight_segment_id ,fs.flight_id ,fs.departure_airport_id ,fs.arrival_airport_id ,ff.amount ,ff.financial_currency_id ,ff.financial_fare_id from booking_flight_segment as bfs inner join flight_segment as fs on fs.flight_segment_id = bfs.flight_segment_id inner join financial_fare as ff on ff.departure_airport_id = fs.departure_airport_id and ff.arrival_airport_id = fs.arrival_airport_id where bfs.booking_id = '90e844c0-e5b8-4179-9569-f818ea8cddee' and bfs.became_booking_flight_segment_id is null and bfs.default_state_rcd <> dbo.ref('default_state_ref.I') | 1035 | 5/12/2024 6:56:02 AM | Edit | Delete |
| BookingFlightsSimple | select top 50 bfs.booking_flight_segment_id ,fs.flight_id ,fs.departure_airport_id ,fs.arrival_airport_id ,ff.amount ,ff.financial_currency_id ,ff.financial_fare_id from booking_flight_segment as bfs inner join flight_segment as fs on fs.flight_segment_id = bfs.flight_segment_id inner join financial_fare as ff on ff.departure_airport_id = fs.departure_airport_id and ff.arrival_airport_id = fs.arrival_airport_id where bfs.booking_id = '7a49075a-e97e-49f0-bd8b-5ebdadfb9238' and bfs.became_booking_flight_segment_id is null and bfs.default_state_rcd <> dbo.ref('default_state_ref.I') | 518 | 5/13/2024 7:55:54 AM | Edit | Delete |
| BookingFlightsSimple | select top 50 bfs.booking_flight_segment_id ,fs.flight_id ,fs.departure_airport_id ,fs.arrival_airport_id ,ff.amount ,ff.financial_currency_id ,ff.financial_fare_id from booking_flight_segment as bfs inner join flight_segment as fs on fs.flight_segment_id = bfs.flight_segment_id inner join financial_fare as ff on ff.departure_airport_id = fs.departure_airport_id and ff.arrival_airport_id = fs.arrival_airport_id where bfs.booking_id = 'c199674a-cad7-459b-9cb7-e6474b2760c1' and bfs.became_booking_flight_segment_id is null and bfs.default_state_rcd <> dbo.ref('default_state_ref.I') | 534 | 5/9/2024 12:55:56 PM | Edit | Delete |
| BookingFlightsSimple | select top 50 bfs.booking_flight_segment_id ,fs.flight_id ,fs.departure_airport_id ,fs.arrival_airport_id ,ff.amount ,ff.financial_currency_id ,ff.financial_fare_id from booking_flight_segment as bfs inner join flight_segment as fs on fs.flight_segment_id = bfs.flight_segment_id inner join financial_fare as ff on ff.departure_airport_id = fs.departure_airport_id and ff.arrival_airport_id = fs.arrival_airport_id where bfs.booking_id = '2e655616-14ff-4533-94fc-9a4caf1da56d' and bfs.became_booking_flight_segment_id is null and bfs.default_state_rcd <> dbo.ref('default_state_ref.I') | 1029 | 5/13/2024 6:55:48 AM | Edit | Delete |
| BookingFlightsSimple | select top 50 bfs.booking_flight_segment_id ,fs.flight_id ,fs.departure_airport_id ,fs.arrival_airport_id ,ff.amount ,ff.financial_currency_id ,ff.financial_fare_id from booking_flight_segment as bfs inner join flight_segment as fs on fs.flight_segment_id = bfs.flight_segment_id inner join financial_fare as ff on ff.departure_airport_id = fs.departure_airport_id and ff.arrival_airport_id = fs.arrival_airport_id where bfs.booking_id = 'eafcf262-426b-4b20-a990-b32547a0b01b' and bfs.became_booking_flight_segment_id is null and bfs.default_state_rcd <> dbo.ref('default_state_ref.I') | 1026 | 5/11/2024 8:56:18 PM | Edit | Delete |
| BookingFlightsSimple | select top 50 bfs.booking_flight_segment_id ,fs.flight_id ,fs.departure_airport_id ,fs.arrival_airport_id ,ff.amount ,ff.financial_currency_id ,ff.financial_fare_id from booking_flight_segment as bfs inner join flight_segment as fs on fs.flight_segment_id = bfs.flight_segment_id inner join financial_fare as ff on ff.departure_airport_id = fs.departure_airport_id and ff.arrival_airport_id = fs.arrival_airport_id where bfs.booking_id = 'f802e52c-71d5-41a9-95fd-817225fd6f74' and bfs.became_booking_flight_segment_id is null and bfs.default_state_rcd <> dbo.ref('default_state_ref.I') | 519 | 5/10/2024 12:56:25 PM | Edit | Delete |
| BookingFlightsSimple | select top 50 bfs.booking_flight_segment_id ,fs.flight_id ,fs.departure_airport_id ,fs.arrival_airport_id ,ff.amount ,ff.financial_currency_id ,ff.financial_fare_id from booking_flight_segment as bfs inner join flight_segment as fs on fs.flight_segment_id = bfs.flight_segment_id inner join financial_fare as ff on ff.departure_airport_id = fs.departure_airport_id and ff.arrival_airport_id = fs.arrival_airport_id where bfs.booking_id = '41e3e758-3587-40b6-8c96-8d7700457405' and bfs.became_booking_flight_segment_id is null and bfs.default_state_rcd <> dbo.ref('default_state_ref.I') | 1023 | 5/11/2024 2:55:51 PM | Edit | Delete |
| BookingFlightsSimple | select top 50 bfs.booking_flight_segment_id ,fs.flight_id ,fs.departure_airport_id ,fs.arrival_airport_id ,ff.amount ,ff.financial_currency_id ,ff.financial_fare_id from booking_flight_segment as bfs inner join flight_segment as fs on fs.flight_segment_id = bfs.flight_segment_id inner join financial_fare as ff on ff.departure_airport_id = fs.departure_airport_id and ff.arrival_airport_id = fs.arrival_airport_id where bfs.booking_id = '26b8babc-3f58-4590-a335-cba48e678c0f' and bfs.became_booking_flight_segment_id is null and bfs.default_state_rcd <> dbo.ref('default_state_ref.I') | 1028 | 5/10/2024 10:56:02 AM | Edit | Delete |
| BookingFlightsSimple | select top 50 bfs.booking_flight_segment_id ,fs.flight_id ,fs.departure_airport_id ,fs.arrival_airport_id ,ff.amount ,ff.financial_currency_id ,ff.financial_fare_id from booking_flight_segment as bfs inner join flight_segment as fs on fs.flight_segment_id = bfs.flight_segment_id inner join financial_fare as ff on ff.departure_airport_id = fs.departure_airport_id and ff.arrival_airport_id = fs.arrival_airport_id where bfs.booking_id = '760db205-ba77-4e52-9f5d-29958102af05' and bfs.became_booking_flight_segment_id is null and bfs.default_state_rcd <> dbo.ref('default_state_ref.I') | 1029 | 5/10/2024 2:55:48 AM | Edit | Delete |
| BookingFlightsSimple | select top 50 bfs.booking_flight_segment_id ,fs.flight_id ,fs.departure_airport_id ,fs.arrival_airport_id ,ff.amount ,ff.financial_currency_id ,ff.financial_fare_id from booking_flight_segment as bfs inner join flight_segment as fs on fs.flight_segment_id = bfs.flight_segment_id inner join financial_fare as ff on ff.departure_airport_id = fs.departure_airport_id and ff.arrival_airport_id = fs.arrival_airport_id where bfs.booking_id = '5b3c36f7-d851-427d-bbd1-ddbaeef40edf' and bfs.became_booking_flight_segment_id is null and bfs.default_state_rcd <> dbo.ref('default_state_ref.I') | 1032 | 5/13/2024 10:55:54 AM | Edit | Delete |
| BookingFlightsSimple | select top 50 bfs.booking_flight_segment_id ,fs.flight_id ,fs.departure_airport_id ,fs.arrival_airport_id ,ff.amount ,ff.financial_currency_id ,ff.financial_fare_id from booking_flight_segment as bfs inner join flight_segment as fs on fs.flight_segment_id = bfs.flight_segment_id inner join financial_fare as ff on ff.departure_airport_id = fs.departure_airport_id and ff.arrival_airport_id = fs.arrival_airport_id where bfs.booking_id = 'c5b5e865-7a06-4663-9ed0-896fe49e3173' and bfs.became_booking_flight_segment_id is null and bfs.default_state_rcd <> dbo.ref('default_state_ref.I') | 535 | 5/10/2024 2:55:50 PM | Edit | Delete |
| BookingFlightsSimple | select top 50 bfs.booking_flight_segment_id ,fs.flight_id ,fs.departure_airport_id ,fs.arrival_airport_id ,ff.amount ,ff.financial_currency_id ,ff.financial_fare_id from booking_flight_segment as bfs inner join flight_segment as fs on fs.flight_segment_id = bfs.flight_segment_id inner join financial_fare as ff on ff.departure_airport_id = fs.departure_airport_id and ff.arrival_airport_id = fs.arrival_airport_id where bfs.booking_id = '4737e4d2-1ddc-415a-ab51-cc5e1fd857c9' and bfs.became_booking_flight_segment_id is null and bfs.default_state_rcd <> dbo.ref('default_state_ref.I') | 1033 | 5/12/2024 4:56:21 PM | Edit | Delete |
| BookingFlightsSimple | select top 50 bfs.booking_flight_segment_id ,fs.flight_id ,fs.departure_airport_id ,fs.arrival_airport_id ,ff.amount ,ff.financial_currency_id ,ff.financial_fare_id from booking_flight_segment as bfs inner join flight_segment as fs on fs.flight_segment_id = bfs.flight_segment_id inner join financial_fare as ff on ff.departure_airport_id = fs.departure_airport_id and ff.arrival_airport_id = fs.arrival_airport_id where bfs.booking_id = '11fd19af-81a7-4855-80c3-81dacfc6ead1' and bfs.became_booking_flight_segment_id is null and bfs.default_state_rcd <> dbo.ref('default_state_ref.I') | 1026 | 5/10/2024 8:55:48 AM | Edit | Delete |
| BookingFlightsSimple | select top 50 bfs.booking_flight_segment_id ,fs.flight_id ,fs.departure_airport_id ,fs.arrival_airport_id ,ff.amount ,ff.financial_currency_id ,ff.financial_fare_id from booking_flight_segment as bfs inner join flight_segment as fs on fs.flight_segment_id = bfs.flight_segment_id inner join financial_fare as ff on ff.departure_airport_id = fs.departure_airport_id and ff.arrival_airport_id = fs.arrival_airport_id where bfs.booking_id = 'f81a5592-67b2-4a83-91f2-5e5a8b29a945' and bfs.became_booking_flight_segment_id is null and bfs.default_state_rcd <> dbo.ref('default_state_ref.I') | 516 | 5/10/2024 12:56:29 PM | Edit | Delete |
| BookingFlightsSimple | select top 50 bfs.booking_flight_segment_id ,fs.flight_id ,fs.departure_airport_id ,fs.arrival_airport_id ,ff.amount ,ff.financial_currency_id ,ff.financial_fare_id from booking_flight_segment as bfs inner join flight_segment as fs on fs.flight_segment_id = bfs.flight_segment_id inner join financial_fare as ff on ff.departure_airport_id = fs.departure_airport_id and ff.arrival_airport_id = fs.arrival_airport_id where bfs.booking_id = '6b213a68-3541-4108-8070-93db5949aea3' and bfs.became_booking_flight_segment_id is null and bfs.default_state_rcd <> dbo.ref('default_state_ref.I') | 1106 | 5/10/2024 3:55:45 PM | Edit | Delete |
| BookingFlightsSimple | select top 50 bfs.booking_flight_segment_id ,fs.flight_id ,fs.departure_airport_id ,fs.arrival_airport_id ,ff.amount ,ff.financial_currency_id ,ff.financial_fare_id from booking_flight_segment as bfs inner join flight_segment as fs on fs.flight_segment_id = bfs.flight_segment_id inner join financial_fare as ff on ff.departure_airport_id = fs.departure_airport_id and ff.arrival_airport_id = fs.arrival_airport_id where bfs.booking_id = 'ea8ec592-d87d-4ffc-908f-e869670525f4' and bfs.became_booking_flight_segment_id is null and bfs.default_state_rcd <> dbo.ref('default_state_ref.I') | 533 | 5/13/2024 1:55:49 AM | Edit | Delete |
| BookingFlightsSimple | select top 50 bfs.booking_flight_segment_id ,fs.flight_id ,fs.departure_airport_id ,fs.arrival_airport_id ,ff.amount ,ff.financial_currency_id ,ff.financial_fare_id from booking_flight_segment as bfs inner join flight_segment as fs on fs.flight_segment_id = bfs.flight_segment_id inner join financial_fare as ff on ff.departure_airport_id = fs.departure_airport_id and ff.arrival_airport_id = fs.arrival_airport_id where bfs.booking_id = '2ae1a2aa-887f-419e-8269-f6a39105ccc6' and bfs.became_booking_flight_segment_id is null and bfs.default_state_rcd <> dbo.ref('default_state_ref.I') | 521 | 5/11/2024 1:56:29 AM | Edit | Delete |
| BookingFlightsSimple | select top 50 bfs.booking_flight_segment_id ,fs.flight_id ,fs.departure_airport_id ,fs.arrival_airport_id ,ff.amount ,ff.financial_currency_id ,ff.financial_fare_id from booking_flight_segment as bfs inner join flight_segment as fs on fs.flight_segment_id = bfs.flight_segment_id inner join financial_fare as ff on ff.departure_airport_id = fs.departure_airport_id and ff.arrival_airport_id = fs.arrival_airport_id where bfs.booking_id = '6bbea3d5-7b3d-483a-82f8-89f49558036f' and bfs.became_booking_flight_segment_id is null and bfs.default_state_rcd <> dbo.ref('default_state_ref.I') | 545 | 5/12/2024 7:55:58 AM | Edit | Delete |
| BookingFlightsSimple | select top 50 bfs.booking_flight_segment_id ,fs.flight_id ,fs.departure_airport_id ,fs.arrival_airport_id ,ff.amount ,ff.financial_currency_id ,ff.financial_fare_id from booking_flight_segment as bfs inner join flight_segment as fs on fs.flight_segment_id = bfs.flight_segment_id inner join financial_fare as ff on ff.departure_airport_id = fs.departure_airport_id and ff.arrival_airport_id = fs.arrival_airport_id where bfs.booking_id = '3aa567da-b13d-4a9c-9247-e96e609159b5' and bfs.became_booking_flight_segment_id is null and bfs.default_state_rcd <> dbo.ref('default_state_ref.I') | 1042 | 5/10/2024 4:55:56 AM | Edit | Delete |
| BookingFlightsSimple | select top 50 bfs.booking_flight_segment_id ,fs.flight_id ,fs.departure_airport_id ,fs.arrival_airport_id ,ff.amount ,ff.financial_currency_id ,ff.financial_fare_id from booking_flight_segment as bfs inner join flight_segment as fs on fs.flight_segment_id = bfs.flight_segment_id inner join financial_fare as ff on ff.departure_airport_id = fs.departure_airport_id and ff.arrival_airport_id = fs.arrival_airport_id where bfs.booking_id = '64868267-d8a8-4233-97b1-2eebf986d623' and bfs.became_booking_flight_segment_id is null and bfs.default_state_rcd <> dbo.ref('default_state_ref.I') | 530 | 5/10/2024 8:55:52 AM | Edit | Delete |
| BookingFlightsSimple | select top 50 bfs.booking_flight_segment_id ,fs.flight_id ,fs.departure_airport_id ,fs.arrival_airport_id ,ff.amount ,ff.financial_currency_id ,ff.financial_fare_id from booking_flight_segment as bfs inner join flight_segment as fs on fs.flight_segment_id = bfs.flight_segment_id inner join financial_fare as ff on ff.departure_airport_id = fs.departure_airport_id and ff.arrival_airport_id = fs.arrival_airport_id where bfs.booking_id = 'cfd05117-a6e8-4025-8073-f5018e0ee372' and bfs.became_booking_flight_segment_id is null and bfs.default_state_rcd <> dbo.ref('default_state_ref.I') | 1039 | 5/12/2024 12:55:52 AM | Edit | Delete |
| BookingFlightsSimple | select top 50 bfs.booking_flight_segment_id ,fs.flight_id ,fs.departure_airport_id ,fs.arrival_airport_id ,ff.amount ,ff.financial_currency_id ,ff.financial_fare_id from booking_flight_segment as bfs inner join flight_segment as fs on fs.flight_segment_id = bfs.flight_segment_id inner join financial_fare as ff on ff.departure_airport_id = fs.departure_airport_id and ff.arrival_airport_id = fs.arrival_airport_id where bfs.booking_id = '4d4a5c7c-7326-4421-873f-59b85fd73091' and bfs.became_booking_flight_segment_id is null and bfs.default_state_rcd <> dbo.ref('default_state_ref.I') | 532 | 5/10/2024 6:56:12 AM | Edit | Delete |
| BookingFlightsSimple | select top 50 bfs.booking_flight_segment_id ,fs.flight_id ,fs.departure_airport_id ,fs.arrival_airport_id ,ff.amount ,ff.financial_currency_id ,ff.financial_fare_id from booking_flight_segment as bfs inner join flight_segment as fs on fs.flight_segment_id = bfs.flight_segment_id inner join financial_fare as ff on ff.departure_airport_id = fs.departure_airport_id and ff.arrival_airport_id = fs.arrival_airport_id where bfs.booking_id = 'f11fc104-aba9-458a-a318-0c32bb17e4fc' and bfs.became_booking_flight_segment_id is null and bfs.default_state_rcd <> dbo.ref('default_state_ref.I') | 532 | 5/12/2024 10:55:58 PM | Edit | Delete |
| BookingFlightsSimple | select top 50 bfs.booking_flight_segment_id ,fs.flight_id ,fs.departure_airport_id ,fs.arrival_airport_id ,ff.amount ,ff.financial_currency_id ,ff.financial_fare_id from booking_flight_segment as bfs inner join flight_segment as fs on fs.flight_segment_id = bfs.flight_segment_id inner join financial_fare as ff on ff.departure_airport_id = fs.departure_airport_id and ff.arrival_airport_id = fs.arrival_airport_id where bfs.booking_id = '8bbffa2a-51d7-4aa8-8f67-2d47687811e3' and bfs.became_booking_flight_segment_id is null and bfs.default_state_rcd <> dbo.ref('default_state_ref.I') | 534 | 5/13/2024 10:55:48 AM | Edit | Delete |
| BookingFlightsSimple | select top 50 bfs.booking_flight_segment_id ,fs.flight_id ,fs.departure_airport_id ,fs.arrival_airport_id ,ff.amount ,ff.financial_currency_id ,ff.financial_fare_id from booking_flight_segment as bfs inner join flight_segment as fs on fs.flight_segment_id = bfs.flight_segment_id inner join financial_fare as ff on ff.departure_airport_id = fs.departure_airport_id and ff.arrival_airport_id = fs.arrival_airport_id where bfs.booking_id = '6cc3f137-6c1a-43c2-8093-f4172b29b693' and bfs.became_booking_flight_segment_id is null and bfs.default_state_rcd <> dbo.ref('default_state_ref.I') | 1041 | 5/13/2024 9:56:30 AM | Edit | Delete |
| BookingFlightsSimple | select top 50 bfs.booking_flight_segment_id ,fs.flight_id ,fs.departure_airport_id ,fs.arrival_airport_id ,ff.amount ,ff.financial_currency_id ,ff.financial_fare_id from booking_flight_segment as bfs inner join flight_segment as fs on fs.flight_segment_id = bfs.flight_segment_id inner join financial_fare as ff on ff.departure_airport_id = fs.departure_airport_id and ff.arrival_airport_id = fs.arrival_airport_id where bfs.booking_id = 'ad6916b6-2ce5-4714-92fc-6ce45ecb1f2e' and bfs.became_booking_flight_segment_id is null and bfs.default_state_rcd <> dbo.ref('default_state_ref.I') | 1036 | 5/13/2024 3:56:20 AM | Edit | Delete |
| BookingFlightsSimple | select top 50 bfs.booking_flight_segment_id ,fs.flight_id ,fs.departure_airport_id ,fs.arrival_airport_id ,ff.amount ,ff.financial_currency_id ,ff.financial_fare_id from booking_flight_segment as bfs inner join flight_segment as fs on fs.flight_segment_id = bfs.flight_segment_id inner join financial_fare as ff on ff.departure_airport_id = fs.departure_airport_id and ff.arrival_airport_id = fs.arrival_airport_id where bfs.booking_id = '3358cbd5-a424-4da5-b830-e58616da72fd' and bfs.became_booking_flight_segment_id is null and bfs.default_state_rcd <> dbo.ref('default_state_ref.I') | 1038 | 5/10/2024 4:56:22 PM | Edit | Delete |
| BookingFlightsSimple | select top 50 bfs.booking_flight_segment_id ,fs.flight_id ,fs.departure_airport_id ,fs.arrival_airport_id ,ff.amount ,ff.financial_currency_id ,ff.financial_fare_id from booking_flight_segment as bfs inner join flight_segment as fs on fs.flight_segment_id = bfs.flight_segment_id inner join financial_fare as ff on ff.departure_airport_id = fs.departure_airport_id and ff.arrival_airport_id = fs.arrival_airport_id where bfs.booking_id = '0fec05b7-e2a5-4c37-9282-0b6a5e638e9c' and bfs.became_booking_flight_segment_id is null and bfs.default_state_rcd <> dbo.ref('default_state_ref.I') | 1028 | 5/13/2024 4:55:57 PM | Edit | Delete |
| BookingFlightsSimple | select top 50 bfs.booking_flight_segment_id ,fs.flight_id ,fs.departure_airport_id ,fs.arrival_airport_id ,ff.amount ,ff.financial_currency_id ,ff.financial_fare_id from booking_flight_segment as bfs inner join flight_segment as fs on fs.flight_segment_id = bfs.flight_segment_id inner join financial_fare as ff on ff.departure_airport_id = fs.departure_airport_id and ff.arrival_airport_id = fs.arrival_airport_id where bfs.booking_id = '77963f5c-255d-4f91-b60c-76327edce68d' and bfs.became_booking_flight_segment_id is null and bfs.default_state_rcd <> dbo.ref('default_state_ref.I') | 1045 | 5/12/2024 3:55:55 PM | Edit | Delete |
| BookingFlightsSimple | select top 50 bfs.booking_flight_segment_id ,fs.flight_id ,fs.departure_airport_id ,fs.arrival_airport_id ,ff.amount ,ff.financial_currency_id ,ff.financial_fare_id from booking_flight_segment as bfs inner join flight_segment as fs on fs.flight_segment_id = bfs.flight_segment_id inner join financial_fare as ff on ff.departure_airport_id = fs.departure_airport_id and ff.arrival_airport_id = fs.arrival_airport_id where bfs.booking_id = '1990df11-9ccb-4912-b7c7-8f8bd916f126' and bfs.became_booking_flight_segment_id is null and bfs.default_state_rcd <> dbo.ref('default_state_ref.I') | 1048 | 5/10/2024 5:56:13 AM | Edit | Delete |
| BookingFlightsSimple | select top 50 bfs.booking_flight_segment_id ,fs.flight_id ,fs.departure_airport_id ,fs.arrival_airport_id ,ff.amount ,ff.financial_currency_id ,ff.financial_fare_id from booking_flight_segment as bfs inner join flight_segment as fs on fs.flight_segment_id = bfs.flight_segment_id inner join financial_fare as ff on ff.departure_airport_id = fs.departure_airport_id and ff.arrival_airport_id = fs.arrival_airport_id where bfs.booking_id = 'afb3385c-7892-4649-bc49-9c101fdd4e10' and bfs.became_booking_flight_segment_id is null and bfs.default_state_rcd <> dbo.ref('default_state_ref.I') | 1027 | 5/11/2024 4:56:26 AM | Edit | Delete |
| BookingFlightsSimple | select top 50 bfs.booking_flight_segment_id ,fs.flight_id ,fs.departure_airport_id ,fs.arrival_airport_id ,ff.amount ,ff.financial_currency_id ,ff.financial_fare_id from booking_flight_segment as bfs inner join flight_segment as fs on fs.flight_segment_id = bfs.flight_segment_id inner join financial_fare as ff on ff.departure_airport_id = fs.departure_airport_id and ff.arrival_airport_id = fs.arrival_airport_id where bfs.booking_id = 'd272af6c-c9b4-4898-bcf3-479b9f73f88f' and bfs.became_booking_flight_segment_id is null and bfs.default_state_rcd <> dbo.ref('default_state_ref.I') | 1035 | 5/11/2024 10:55:53 PM | Edit | Delete |
| BookingFlightsSimple | select top 50 bfs.booking_flight_segment_id ,fs.flight_id ,fs.departure_airport_id ,fs.arrival_airport_id ,ff.amount ,ff.financial_currency_id ,ff.financial_fare_id from booking_flight_segment as bfs inner join flight_segment as fs on fs.flight_segment_id = bfs.flight_segment_id inner join financial_fare as ff on ff.departure_airport_id = fs.departure_airport_id and ff.arrival_airport_id = fs.arrival_airport_id where bfs.booking_id = '6e8277d9-40b5-4ba9-9aa0-77d0be8554f8' and bfs.became_booking_flight_segment_id is null and bfs.default_state_rcd <> dbo.ref('default_state_ref.I') | 1036 | 5/12/2024 1:56:15 PM | Edit | Delete |
| BookingFlightsSimple | select top 50 bfs.booking_flight_segment_id ,fs.flight_id ,fs.departure_airport_id ,fs.arrival_airport_id ,ff.amount ,ff.financial_currency_id ,ff.financial_fare_id from booking_flight_segment as bfs inner join flight_segment as fs on fs.flight_segment_id = bfs.flight_segment_id inner join financial_fare as ff on ff.departure_airport_id = fs.departure_airport_id and ff.arrival_airport_id = fs.arrival_airport_id where bfs.booking_id = 'a6fb5dca-d924-4e3c-8542-9e2c2b9b0ac5' and bfs.became_booking_flight_segment_id is null and bfs.default_state_rcd <> dbo.ref('default_state_ref.I') | 1041 | 5/10/2024 12:56:00 AM | Edit | Delete |
| BookingFlightsSimple | select top 50 bfs.booking_flight_segment_id ,fs.flight_id ,fs.departure_airport_id ,fs.arrival_airport_id ,ff.amount ,ff.financial_currency_id ,ff.financial_fare_id from booking_flight_segment as bfs inner join flight_segment as fs on fs.flight_segment_id = bfs.flight_segment_id inner join financial_fare as ff on ff.departure_airport_id = fs.departure_airport_id and ff.arrival_airport_id = fs.arrival_airport_id where bfs.booking_id = '96189a02-ac3a-476b-a3ac-896328284e81' and bfs.became_booking_flight_segment_id is null and bfs.default_state_rcd <> dbo.ref('default_state_ref.I') | 530 | 5/10/2024 5:56:19 AM | Edit | Delete |
| BookingFlightsSimple | select top 50 bfs.booking_flight_segment_id ,fs.flight_id ,fs.departure_airport_id ,fs.arrival_airport_id ,ff.amount ,ff.financial_currency_id ,ff.financial_fare_id from booking_flight_segment as bfs inner join flight_segment as fs on fs.flight_segment_id = bfs.flight_segment_id inner join financial_fare as ff on ff.departure_airport_id = fs.departure_airport_id and ff.arrival_airport_id = fs.arrival_airport_id where bfs.booking_id = 'bc57b150-523e-475a-8150-6eaaaad6cfe9' and bfs.became_booking_flight_segment_id is null and bfs.default_state_rcd <> dbo.ref('default_state_ref.I') | 1023 | 5/10/2024 1:55:59 PM | Edit | Delete |
| BookingFlightsSimple | select top 50 bfs.booking_flight_segment_id ,fs.flight_id ,fs.departure_airport_id ,fs.arrival_airport_id ,ff.amount ,ff.financial_currency_id ,ff.financial_fare_id from booking_flight_segment as bfs inner join flight_segment as fs on fs.flight_segment_id = bfs.flight_segment_id inner join financial_fare as ff on ff.departure_airport_id = fs.departure_airport_id and ff.arrival_airport_id = fs.arrival_airport_id where bfs.booking_id = '0c9ab084-6cf2-4c91-b2c1-dd15c4a93d24' and bfs.became_booking_flight_segment_id is null and bfs.default_state_rcd <> dbo.ref('default_state_ref.I') | 1041 | 5/12/2024 9:55:52 PM | Edit | Delete |
| BookingFlightsSimple | select top 50 bfs.booking_flight_segment_id ,fs.flight_id ,fs.departure_airport_id ,fs.arrival_airport_id ,ff.amount ,ff.financial_currency_id ,ff.financial_fare_id from booking_flight_segment as bfs inner join flight_segment as fs on fs.flight_segment_id = bfs.flight_segment_id inner join financial_fare as ff on ff.departure_airport_id = fs.departure_airport_id and ff.arrival_airport_id = fs.arrival_airport_id where bfs.booking_id = 'e10f77b1-4318-479d-88a1-769b3cfca6c0' and bfs.became_booking_flight_segment_id is null and bfs.default_state_rcd <> dbo.ref('default_state_ref.I') | 1040 | 5/13/2024 5:55:59 AM | Edit | Delete |
| BookingFlightsSimple | select top 50 bfs.booking_flight_segment_id ,fs.flight_id ,fs.departure_airport_id ,fs.arrival_airport_id ,ff.amount ,ff.financial_currency_id ,ff.financial_fare_id from booking_flight_segment as bfs inner join flight_segment as fs on fs.flight_segment_id = bfs.flight_segment_id inner join financial_fare as ff on ff.departure_airport_id = fs.departure_airport_id and ff.arrival_airport_id = fs.arrival_airport_id where bfs.booking_id = 'ebde3d70-0f51-413a-82dd-60e02cdd8cef' and bfs.became_booking_flight_segment_id is null and bfs.default_state_rcd <> dbo.ref('default_state_ref.I') | 1037 | 5/9/2024 8:55:58 PM | Edit | Delete |
| BookingFlightsSimple | select top 50 bfs.booking_flight_segment_id ,fs.flight_id ,fs.departure_airport_id ,fs.arrival_airport_id ,ff.amount ,ff.financial_currency_id ,ff.financial_fare_id from booking_flight_segment as bfs inner join flight_segment as fs on fs.flight_segment_id = bfs.flight_segment_id inner join financial_fare as ff on ff.departure_airport_id = fs.departure_airport_id and ff.arrival_airport_id = fs.arrival_airport_id where bfs.booking_id = 'ed68f3e3-1596-4c86-9448-f7010df7aae0' and bfs.became_booking_flight_segment_id is null and bfs.default_state_rcd <> dbo.ref('default_state_ref.I') | 532 | 5/13/2024 3:55:56 PM | Edit | Delete |
| BookingFlightsSimple | select top 50 bfs.booking_flight_segment_id ,fs.flight_id ,fs.departure_airport_id ,fs.arrival_airport_id ,ff.amount ,ff.financial_currency_id ,ff.financial_fare_id from booking_flight_segment as bfs inner join flight_segment as fs on fs.flight_segment_id = bfs.flight_segment_id inner join financial_fare as ff on ff.departure_airport_id = fs.departure_airport_id and ff.arrival_airport_id = fs.arrival_airport_id where bfs.booking_id = 'a065cd3d-5a51-4072-8306-2b0899bda72e' and bfs.became_booking_flight_segment_id is null and bfs.default_state_rcd <> dbo.ref('default_state_ref.I') | 1039 | 5/10/2024 11:56:19 AM | Edit | Delete |
| BookingFlightsSimple | select top 50 bfs.booking_flight_segment_id ,fs.flight_id ,fs.departure_airport_id ,fs.arrival_airport_id ,ff.amount ,ff.financial_currency_id ,ff.financial_fare_id from booking_flight_segment as bfs inner join flight_segment as fs on fs.flight_segment_id = bfs.flight_segment_id inner join financial_fare as ff on ff.departure_airport_id = fs.departure_airport_id and ff.arrival_airport_id = fs.arrival_airport_id where bfs.booking_id = 'da321559-5d05-4404-8830-d0554104fc4c' and bfs.became_booking_flight_segment_id is null and bfs.default_state_rcd <> dbo.ref('default_state_ref.I') | 1046 | 5/13/2024 12:55:47 PM | Edit | Delete |
| BookingFlightsSimple | select top 50 bfs.booking_flight_segment_id ,fs.flight_id ,fs.departure_airport_id ,fs.arrival_airport_id ,ff.amount ,ff.financial_currency_id ,ff.financial_fare_id from booking_flight_segment as bfs inner join flight_segment as fs on fs.flight_segment_id = bfs.flight_segment_id inner join financial_fare as ff on ff.departure_airport_id = fs.departure_airport_id and ff.arrival_airport_id = fs.arrival_airport_id where bfs.booking_id = 'a0489c6a-7573-427f-8c25-98f24907620c' and bfs.became_booking_flight_segment_id is null and bfs.default_state_rcd <> dbo.ref('default_state_ref.I') | 1035 | 5/13/2024 11:55:48 AM | Edit | Delete |
| BookingFlightsSimple | select top 50 bfs.booking_flight_segment_id ,fs.flight_id ,fs.departure_airport_id ,fs.arrival_airport_id ,ff.amount ,ff.financial_currency_id ,ff.financial_fare_id from booking_flight_segment as bfs inner join flight_segment as fs on fs.flight_segment_id = bfs.flight_segment_id inner join financial_fare as ff on ff.departure_airport_id = fs.departure_airport_id and ff.arrival_airport_id = fs.arrival_airport_id where bfs.booking_id = 'cd47bc14-e7a5-4273-a710-1827810bafe5' and bfs.became_booking_flight_segment_id is null and bfs.default_state_rcd <> dbo.ref('default_state_ref.I') | 1043 | 5/11/2024 6:56:26 AM | Edit | Delete |
| BookingFlightsSimple | select top 50 bfs.booking_flight_segment_id ,fs.flight_id ,fs.departure_airport_id ,fs.arrival_airport_id ,ff.amount ,ff.financial_currency_id ,ff.financial_fare_id from booking_flight_segment as bfs inner join flight_segment as fs on fs.flight_segment_id = bfs.flight_segment_id inner join financial_fare as ff on ff.departure_airport_id = fs.departure_airport_id and ff.arrival_airport_id = fs.arrival_airport_id where bfs.booking_id = '093d85df-702f-4739-a094-d3750c88ef5b' and bfs.became_booking_flight_segment_id is null and bfs.default_state_rcd <> dbo.ref('default_state_ref.I') | 1024 | 5/13/2024 6:55:55 AM | Edit | Delete |
| BookingFlightsSimple | select top 50 bfs.booking_flight_segment_id ,fs.flight_id ,fs.departure_airport_id ,fs.arrival_airport_id ,ff.amount ,ff.financial_currency_id ,ff.financial_fare_id from booking_flight_segment as bfs inner join flight_segment as fs on fs.flight_segment_id = bfs.flight_segment_id inner join financial_fare as ff on ff.departure_airport_id = fs.departure_airport_id and ff.arrival_airport_id = fs.arrival_airport_id where bfs.booking_id = '1f28d75e-0de0-4320-898b-7b71501a4f08' and bfs.became_booking_flight_segment_id is null and bfs.default_state_rcd <> dbo.ref('default_state_ref.I') | 1025 | 5/10/2024 5:55:56 PM | Edit | Delete |
| BookingFlightsSimple | select top 50 bfs.booking_flight_segment_id ,fs.flight_id ,fs.departure_airport_id ,fs.arrival_airport_id ,ff.amount ,ff.financial_currency_id ,ff.financial_fare_id from booking_flight_segment as bfs inner join flight_segment as fs on fs.flight_segment_id = bfs.flight_segment_id inner join financial_fare as ff on ff.departure_airport_id = fs.departure_airport_id and ff.arrival_airport_id = fs.arrival_airport_id where bfs.booking_id = '2a2bab3a-1786-4254-b09e-a161e8f0a890' and bfs.became_booking_flight_segment_id is null and bfs.default_state_rcd <> dbo.ref('default_state_ref.I') | 1037 | 5/11/2024 12:56:33 AM | Edit | Delete |
| BookingFlightsSimple | select top 50 bfs.booking_flight_segment_id ,fs.flight_id ,fs.departure_airport_id ,fs.arrival_airport_id ,ff.amount ,ff.financial_currency_id ,ff.financial_fare_id from booking_flight_segment as bfs inner join flight_segment as fs on fs.flight_segment_id = bfs.flight_segment_id inner join financial_fare as ff on ff.departure_airport_id = fs.departure_airport_id and ff.arrival_airport_id = fs.arrival_airport_id where bfs.booking_id = 'fe5c3f6e-a42e-427b-a5f8-0f37f572e7c5' and bfs.became_booking_flight_segment_id is null and bfs.default_state_rcd <> dbo.ref('default_state_ref.I') | 1042 | 5/9/2024 12:20:16 PM | Edit | Delete |
| BookingFlightsSimple | select top 50 bfs.booking_flight_segment_id ,fs.flight_id ,fs.departure_airport_id ,fs.arrival_airport_id ,ff.amount ,ff.financial_currency_id ,ff.financial_fare_id from booking_flight_segment as bfs inner join flight_segment as fs on fs.flight_segment_id = bfs.flight_segment_id inner join financial_fare as ff on ff.departure_airport_id = fs.departure_airport_id and ff.arrival_airport_id = fs.arrival_airport_id where bfs.booking_id = '0e09cd92-218e-48bc-b7ef-6bb716ea1e24' and bfs.became_booking_flight_segment_id is null and bfs.default_state_rcd <> dbo.ref('default_state_ref.I') | 1041 | 5/12/2024 8:56:19 AM | Edit | Delete |
| BookingFlightsSimple | select top 50 bfs.booking_flight_segment_id ,fs.flight_id ,fs.departure_airport_id ,fs.arrival_airport_id ,ff.amount ,ff.financial_currency_id ,ff.financial_fare_id from booking_flight_segment as bfs inner join flight_segment as fs on fs.flight_segment_id = bfs.flight_segment_id inner join financial_fare as ff on ff.departure_airport_id = fs.departure_airport_id and ff.arrival_airport_id = fs.arrival_airport_id where bfs.booking_id = '72847746-1b25-4fd9-9d5f-29f4db6a30ac' and bfs.became_booking_flight_segment_id is null and bfs.default_state_rcd <> dbo.ref('default_state_ref.I') | 520 | 5/9/2024 12:55:51 PM | Edit | Delete |
| BookingFlightsSimple | select top 50 bfs.booking_flight_segment_id ,fs.flight_id ,fs.departure_airport_id ,fs.arrival_airport_id ,ff.amount ,ff.financial_currency_id ,ff.financial_fare_id from booking_flight_segment as bfs inner join flight_segment as fs on fs.flight_segment_id = bfs.flight_segment_id inner join financial_fare as ff on ff.departure_airport_id = fs.departure_airport_id and ff.arrival_airport_id = fs.arrival_airport_id where bfs.booking_id = '459c4a16-a8cf-4919-95b5-0c7eeccadbae' and bfs.became_booking_flight_segment_id is null and bfs.default_state_rcd <> dbo.ref('default_state_ref.I') | 1033 | 5/10/2024 11:56:10 AM | Edit | Delete |
| BookingFlightsSimple | select top 50 bfs.booking_flight_segment_id ,fs.flight_id ,fs.departure_airport_id ,fs.arrival_airport_id ,ff.amount ,ff.financial_currency_id ,ff.financial_fare_id from booking_flight_segment as bfs inner join flight_segment as fs on fs.flight_segment_id = bfs.flight_segment_id inner join financial_fare as ff on ff.departure_airport_id = fs.departure_airport_id and ff.arrival_airport_id = fs.arrival_airport_id where bfs.booking_id = '463b90f3-de24-4b4b-9ff4-e97a43ddf09f' and bfs.became_booking_flight_segment_id is null and bfs.default_state_rcd <> dbo.ref('default_state_ref.I') | 1035 | 5/9/2024 4:55:49 PM | Edit | Delete |
| BookingFlightsSimple | select top 50 bfs.booking_flight_segment_id ,fs.flight_id ,fs.departure_airport_id ,fs.arrival_airport_id ,ff.amount ,ff.financial_currency_id ,ff.financial_fare_id from booking_flight_segment as bfs inner join flight_segment as fs on fs.flight_segment_id = bfs.flight_segment_id inner join financial_fare as ff on ff.departure_airport_id = fs.departure_airport_id and ff.arrival_airport_id = fs.arrival_airport_id where bfs.booking_id = '04a04e58-5c83-4acd-a9b1-45504a8c0858' and bfs.became_booking_flight_segment_id is null and bfs.default_state_rcd <> dbo.ref('default_state_ref.I') | 1035 | 5/9/2024 10:56:11 PM | Edit | Delete |
| BookingFlightsSimple | select top 50 bfs.booking_flight_segment_id ,fs.flight_id ,fs.departure_airport_id ,fs.arrival_airport_id ,ff.amount ,ff.financial_currency_id ,ff.financial_fare_id from booking_flight_segment as bfs inner join flight_segment as fs on fs.flight_segment_id = bfs.flight_segment_id inner join financial_fare as ff on ff.departure_airport_id = fs.departure_airport_id and ff.arrival_airport_id = fs.arrival_airport_id where bfs.booking_id = 'aebce112-38c0-4319-92ae-94ee95804429' and bfs.became_booking_flight_segment_id is null and bfs.default_state_rcd <> dbo.ref('default_state_ref.I') | 1043 | 5/11/2024 7:56:00 PM | Edit | Delete |
| BookingFlightsSimple | select top 50 bfs.booking_flight_segment_id ,fs.flight_id ,fs.departure_airport_id ,fs.arrival_airport_id ,ff.amount ,ff.financial_currency_id ,ff.financial_fare_id from booking_flight_segment as bfs inner join flight_segment as fs on fs.flight_segment_id = bfs.flight_segment_id inner join financial_fare as ff on ff.departure_airport_id = fs.departure_airport_id and ff.arrival_airport_id = fs.arrival_airport_id where bfs.booking_id = '8208cf61-01cb-4c97-a348-cd6e019a3354' and bfs.became_booking_flight_segment_id is null and bfs.default_state_rcd <> dbo.ref('default_state_ref.I') | 1022 | 5/11/2024 12:56:27 AM | Edit | Delete |
| BookingFlightsSimple | select top 50 bfs.booking_flight_segment_id ,fs.flight_id ,fs.departure_airport_id ,fs.arrival_airport_id ,ff.amount ,ff.financial_currency_id ,ff.financial_fare_id from booking_flight_segment as bfs inner join flight_segment as fs on fs.flight_segment_id = bfs.flight_segment_id inner join financial_fare as ff on ff.departure_airport_id = fs.departure_airport_id and ff.arrival_airport_id = fs.arrival_airport_id where bfs.booking_id = 'f3c6704b-0e98-4ca3-b383-fcdebe9dc623' and bfs.became_booking_flight_segment_id is null and bfs.default_state_rcd <> dbo.ref('default_state_ref.I') | 1024 | 5/10/2024 10:56:19 PM | Edit | Delete |
| BookingFlightsSimple | select top 50 bfs.booking_flight_segment_id ,fs.flight_id ,fs.departure_airport_id ,fs.arrival_airport_id ,ff.amount ,ff.financial_currency_id ,ff.financial_fare_id from booking_flight_segment as bfs inner join flight_segment as fs on fs.flight_segment_id = bfs.flight_segment_id inner join financial_fare as ff on ff.departure_airport_id = fs.departure_airport_id and ff.arrival_airport_id = fs.arrival_airport_id where bfs.booking_id = '67b01326-9853-4da0-8eab-08b7c3adde99' and bfs.became_booking_flight_segment_id is null and bfs.default_state_rcd <> dbo.ref('default_state_ref.I') | 1049 | 5/13/2024 1:55:44 AM | Edit | Delete |
| BookingFlightsSimple | select top 50 bfs.booking_flight_segment_id ,fs.flight_id ,fs.departure_airport_id ,fs.arrival_airport_id ,ff.amount ,ff.financial_currency_id ,ff.financial_fare_id from booking_flight_segment as bfs inner join flight_segment as fs on fs.flight_segment_id = bfs.flight_segment_id inner join financial_fare as ff on ff.departure_airport_id = fs.departure_airport_id and ff.arrival_airport_id = fs.arrival_airport_id where bfs.booking_id = 'e61d9f55-bb3a-47ea-a1cf-baa4307f93a3' and bfs.became_booking_flight_segment_id is null and bfs.default_state_rcd <> dbo.ref('default_state_ref.I') | 1042 | 5/12/2024 5:56:25 PM | Edit | Delete |
| BookingFlightsSimple | select top 50 bfs.booking_flight_segment_id ,fs.flight_id ,fs.departure_airport_id ,fs.arrival_airport_id ,ff.amount ,ff.financial_currency_id ,ff.financial_fare_id from booking_flight_segment as bfs inner join flight_segment as fs on fs.flight_segment_id = bfs.flight_segment_id inner join financial_fare as ff on ff.departure_airport_id = fs.departure_airport_id and ff.arrival_airport_id = fs.arrival_airport_id where bfs.booking_id = '37ffd076-9ab9-467e-9137-c4e129936418' and bfs.became_booking_flight_segment_id is null and bfs.default_state_rcd <> dbo.ref('default_state_ref.I') | 1049 | 5/9/2024 2:56:03 PM | Edit | Delete |
| BookingFlightsSimple | select top 50 bfs.booking_flight_segment_id ,fs.flight_id ,fs.departure_airport_id ,fs.arrival_airport_id ,ff.amount ,ff.financial_currency_id ,ff.financial_fare_id from booking_flight_segment as bfs inner join flight_segment as fs on fs.flight_segment_id = bfs.flight_segment_id inner join financial_fare as ff on ff.departure_airport_id = fs.departure_airport_id and ff.arrival_airport_id = fs.arrival_airport_id where bfs.booking_id = '8158987b-60bf-4322-9656-e501fdc01538' and bfs.became_booking_flight_segment_id is null and bfs.default_state_rcd <> dbo.ref('default_state_ref.I') | 534 | 5/11/2024 7:55:57 PM | Edit | Delete |
| BookingFlightsSimple | select top 50 bfs.booking_flight_segment_id ,fs.flight_id ,fs.departure_airport_id ,fs.arrival_airport_id ,ff.amount ,ff.financial_currency_id ,ff.financial_fare_id from booking_flight_segment as bfs inner join flight_segment as fs on fs.flight_segment_id = bfs.flight_segment_id inner join financial_fare as ff on ff.departure_airport_id = fs.departure_airport_id and ff.arrival_airport_id = fs.arrival_airport_id where bfs.booking_id = '7718b4bd-bc57-4f3d-a569-00966bf06846' and bfs.became_booking_flight_segment_id is null and bfs.default_state_rcd <> dbo.ref('default_state_ref.I') | 531 | 5/12/2024 6:56:17 PM | Edit | Delete |
| BookingFlightsSimple | select top 50 bfs.booking_flight_segment_id ,fs.flight_id ,fs.departure_airport_id ,fs.arrival_airport_id ,ff.amount ,ff.financial_currency_id ,ff.financial_fare_id from booking_flight_segment as bfs inner join flight_segment as fs on fs.flight_segment_id = bfs.flight_segment_id inner join financial_fare as ff on ff.departure_airport_id = fs.departure_airport_id and ff.arrival_airport_id = fs.arrival_airport_id where bfs.booking_id = '82dac3af-8f32-4d7e-9420-fcb6e1db3fe8' and bfs.became_booking_flight_segment_id is null and bfs.default_state_rcd <> dbo.ref('default_state_ref.I') | 1045 | 5/13/2024 3:55:53 PM | Edit | Delete |
| BookingFlightsSimple | select top 50 bfs.booking_flight_segment_id ,fs.flight_id ,fs.departure_airport_id ,fs.arrival_airport_id ,ff.amount ,ff.financial_currency_id ,ff.financial_fare_id from booking_flight_segment as bfs inner join flight_segment as fs on fs.flight_segment_id = bfs.flight_segment_id inner join financial_fare as ff on ff.departure_airport_id = fs.departure_airport_id and ff.arrival_airport_id = fs.arrival_airport_id where bfs.booking_id = '3970cc34-d665-489c-844e-0f3a3b942266' and bfs.became_booking_flight_segment_id is null and bfs.default_state_rcd <> dbo.ref('default_state_ref.I') | 1033 | 5/11/2024 9:55:55 PM | Edit | Delete |
| BookingFlightsSimple | select top 50 bfs.booking_flight_segment_id ,fs.flight_id ,fs.departure_airport_id ,fs.arrival_airport_id ,ff.amount ,ff.financial_currency_id ,ff.financial_fare_id from booking_flight_segment as bfs inner join flight_segment as fs on fs.flight_segment_id = bfs.flight_segment_id inner join financial_fare as ff on ff.departure_airport_id = fs.departure_airport_id and ff.arrival_airport_id = fs.arrival_airport_id where bfs.booking_id = 'fac00a1c-37ed-47d0-a1dd-78038c2cc912' and bfs.became_booking_flight_segment_id is null and bfs.default_state_rcd <> dbo.ref('default_state_ref.I') | 1042 | 5/9/2024 1:56:26 PM | Edit | Delete |
| BookingFlightsSimple | select top 50 bfs.booking_flight_segment_id ,fs.flight_id ,fs.departure_airport_id ,fs.arrival_airport_id ,ff.amount ,ff.financial_currency_id ,ff.financial_fare_id from booking_flight_segment as bfs inner join flight_segment as fs on fs.flight_segment_id = bfs.flight_segment_id inner join financial_fare as ff on ff.departure_airport_id = fs.departure_airport_id and ff.arrival_airport_id = fs.arrival_airport_id where bfs.booking_id = 'd628ae19-7121-474d-b570-f018e8df3bc1' and bfs.became_booking_flight_segment_id is null and bfs.default_state_rcd <> dbo.ref('default_state_ref.I') | 1040 | 5/11/2024 9:55:55 AM | Edit | Delete |
| BookingFlightsSimple | select top 50 bfs.booking_flight_segment_id ,fs.flight_id ,fs.departure_airport_id ,fs.arrival_airport_id ,ff.amount ,ff.financial_currency_id ,ff.financial_fare_id from booking_flight_segment as bfs inner join flight_segment as fs on fs.flight_segment_id = bfs.flight_segment_id inner join financial_fare as ff on ff.departure_airport_id = fs.departure_airport_id and ff.arrival_airport_id = fs.arrival_airport_id where bfs.booking_id = 'b5de8322-0bd1-49b6-9d69-1678309e2d5a' and bfs.became_booking_flight_segment_id is null and bfs.default_state_rcd <> dbo.ref('default_state_ref.I') | 1040 | 5/11/2024 6:56:21 AM | Edit | Delete |
| BookingFlightsSimple | select top 50 bfs.booking_flight_segment_id ,fs.flight_id ,fs.departure_airport_id ,fs.arrival_airport_id ,ff.amount ,ff.financial_currency_id ,ff.financial_fare_id from booking_flight_segment as bfs inner join flight_segment as fs on fs.flight_segment_id = bfs.flight_segment_id inner join financial_fare as ff on ff.departure_airport_id = fs.departure_airport_id and ff.arrival_airport_id = fs.arrival_airport_id where bfs.booking_id = 'b7cdc3f1-d27c-4826-a8cc-2de572fca6b6' and bfs.became_booking_flight_segment_id is null and bfs.default_state_rcd <> dbo.ref('default_state_ref.I') | 1031 | 5/10/2024 10:55:53 AM | Edit | Delete |
| BookingFlightsSimple | select top 50 bfs.booking_flight_segment_id ,fs.flight_id ,fs.departure_airport_id ,fs.arrival_airport_id ,ff.amount ,ff.financial_currency_id ,ff.financial_fare_id from booking_flight_segment as bfs inner join flight_segment as fs on fs.flight_segment_id = bfs.flight_segment_id inner join financial_fare as ff on ff.departure_airport_id = fs.departure_airport_id and ff.arrival_airport_id = fs.arrival_airport_id where bfs.booking_id = '71a8a0b9-27fd-41a7-b781-f403bb3d87ab' and bfs.became_booking_flight_segment_id is null and bfs.default_state_rcd <> dbo.ref('default_state_ref.I') | 1039 | 5/12/2024 7:55:50 AM | Edit | Delete |
| BookingFlightsSimple | select top 50 bfs.booking_flight_segment_id ,fs.flight_id ,fs.departure_airport_id ,fs.arrival_airport_id ,ff.amount ,ff.financial_currency_id ,ff.financial_fare_id from booking_flight_segment as bfs inner join flight_segment as fs on fs.flight_segment_id = bfs.flight_segment_id inner join financial_fare as ff on ff.departure_airport_id = fs.departure_airport_id and ff.arrival_airport_id = fs.arrival_airport_id where bfs.booking_id = 'bbd4ad98-5729-4574-88a8-eb89cf0a2311' and bfs.became_booking_flight_segment_id is null and bfs.default_state_rcd <> dbo.ref('default_state_ref.I') | 1026 | 5/13/2024 12:55:53 PM | Edit | Delete |
| BookingFlightsSimple | select top 50 bfs.booking_flight_segment_id ,fs.flight_id ,fs.departure_airport_id ,fs.arrival_airport_id ,ff.amount ,ff.financial_currency_id ,ff.financial_fare_id from booking_flight_segment as bfs inner join flight_segment as fs on fs.flight_segment_id = bfs.flight_segment_id inner join financial_fare as ff on ff.departure_airport_id = fs.departure_airport_id and ff.arrival_airport_id = fs.arrival_airport_id where bfs.booking_id = 'a2e5285c-f410-435e-8058-dd40c2e28879' and bfs.became_booking_flight_segment_id is null and bfs.default_state_rcd <> dbo.ref('default_state_ref.I') | 1027 | 5/10/2024 2:55:57 AM | Edit | Delete |
| BookingFlightsSimple | select top 50 bfs.booking_flight_segment_id ,fs.flight_id ,fs.departure_airport_id ,fs.arrival_airport_id ,ff.amount ,ff.financial_currency_id ,ff.financial_fare_id from booking_flight_segment as bfs inner join flight_segment as fs on fs.flight_segment_id = bfs.flight_segment_id inner join financial_fare as ff on ff.departure_airport_id = fs.departure_airport_id and ff.arrival_airport_id = fs.arrival_airport_id where bfs.booking_id = 'a8b0a34e-df28-4027-aa9c-c8b7df433758' and bfs.became_booking_flight_segment_id is null and bfs.default_state_rcd <> dbo.ref('default_state_ref.I') | 518 | 5/9/2024 11:55:49 PM | Edit | Delete |
| BookingFlightsSimple | select top 50 bfs.booking_flight_segment_id ,fs.flight_id ,fs.departure_airport_id ,fs.arrival_airport_id ,ff.amount ,ff.financial_currency_id ,ff.financial_fare_id from booking_flight_segment as bfs inner join flight_segment as fs on fs.flight_segment_id = bfs.flight_segment_id inner join financial_fare as ff on ff.departure_airport_id = fs.departure_airport_id and ff.arrival_airport_id = fs.arrival_airport_id where bfs.booking_id = 'd68cd304-824f-4112-9af3-c62c0a1c1eb9' and bfs.became_booking_flight_segment_id is null and bfs.default_state_rcd <> dbo.ref('default_state_ref.I') | 1028 | 5/11/2024 11:56:23 PM | Edit | Delete |
| BookingFlightsSimple | select top 50 bfs.booking_flight_segment_id ,fs.flight_id ,fs.departure_airport_id ,fs.arrival_airport_id ,ff.amount ,ff.financial_currency_id ,ff.financial_fare_id from booking_flight_segment as bfs inner join flight_segment as fs on fs.flight_segment_id = bfs.flight_segment_id inner join financial_fare as ff on ff.departure_airport_id = fs.departure_airport_id and ff.arrival_airport_id = fs.arrival_airport_id where bfs.booking_id = '3133a8e5-5e62-45d0-852d-84dc7272a779' and bfs.became_booking_flight_segment_id is null and bfs.default_state_rcd <> dbo.ref('default_state_ref.I') | 1048 | 5/10/2024 5:55:46 PM | Edit | Delete |
| BookingFlightsSimple | select top 50 bfs.booking_flight_segment_id ,fs.flight_id ,fs.departure_airport_id ,fs.arrival_airport_id ,ff.amount ,ff.financial_currency_id ,ff.financial_fare_id from booking_flight_segment as bfs inner join flight_segment as fs on fs.flight_segment_id = bfs.flight_segment_id inner join financial_fare as ff on ff.departure_airport_id = fs.departure_airport_id and ff.arrival_airport_id = fs.arrival_airport_id where bfs.booking_id = 'aef9e2c7-6c7b-4f8e-9fd9-d842d5846fce' and bfs.became_booking_flight_segment_id is null and bfs.default_state_rcd <> dbo.ref('default_state_ref.I') | 539 | 5/12/2024 6:56:08 AM | Edit | Delete |
| BookingFlightsSimple | select top 50 bfs.booking_flight_segment_id ,fs.flight_id ,fs.departure_airport_id ,fs.arrival_airport_id ,ff.amount ,ff.financial_currency_id ,ff.financial_fare_id from booking_flight_segment as bfs inner join flight_segment as fs on fs.flight_segment_id = bfs.flight_segment_id inner join financial_fare as ff on ff.departure_airport_id = fs.departure_airport_id and ff.arrival_airport_id = fs.arrival_airport_id where bfs.booking_id = 'b8c35710-2a54-4c6a-adc7-3c2e3332618d' and bfs.became_booking_flight_segment_id is null and bfs.default_state_rcd <> dbo.ref('default_state_ref.I') | 1040 | 5/10/2024 9:55:56 AM | Edit | Delete |
| BookingFlightsSimple | select top 50 bfs.booking_flight_segment_id ,fs.flight_id ,fs.departure_airport_id ,fs.arrival_airport_id ,ff.amount ,ff.financial_currency_id ,ff.financial_fare_id from booking_flight_segment as bfs inner join flight_segment as fs on fs.flight_segment_id = bfs.flight_segment_id inner join financial_fare as ff on ff.departure_airport_id = fs.departure_airport_id and ff.arrival_airport_id = fs.arrival_airport_id where bfs.booking_id = 'a4005a8e-3cee-44b6-ba97-249174807aaa' and bfs.became_booking_flight_segment_id is null and bfs.default_state_rcd <> dbo.ref('default_state_ref.I') | 1028 | 5/10/2024 4:55:47 AM | Edit | Delete |
| BookingFlightsSimple | select top 50 bfs.booking_flight_segment_id ,fs.flight_id ,fs.departure_airport_id ,fs.arrival_airport_id ,ff.amount ,ff.financial_currency_id ,ff.financial_fare_id from booking_flight_segment as bfs inner join flight_segment as fs on fs.flight_segment_id = bfs.flight_segment_id inner join financial_fare as ff on ff.departure_airport_id = fs.departure_airport_id and ff.arrival_airport_id = fs.arrival_airport_id where bfs.booking_id = 'c2821410-18e7-42cd-a345-6d1396d590bb' and bfs.became_booking_flight_segment_id is null and bfs.default_state_rcd <> dbo.ref('default_state_ref.I') | 1042 | 5/12/2024 8:55:53 PM | Edit | Delete |
| BookingFlightsSimple | select top 50 bfs.booking_flight_segment_id ,fs.flight_id ,fs.departure_airport_id ,fs.arrival_airport_id ,ff.amount ,ff.financial_currency_id ,ff.financial_fare_id from booking_flight_segment as bfs inner join flight_segment as fs on fs.flight_segment_id = bfs.flight_segment_id inner join financial_fare as ff on ff.departure_airport_id = fs.departure_airport_id and ff.arrival_airport_id = fs.arrival_airport_id where bfs.booking_id = '52aac26b-42c6-421a-a577-2f0dde82d5e0' and bfs.became_booking_flight_segment_id is null and bfs.default_state_rcd <> dbo.ref('default_state_ref.I') | 1034 | 5/9/2024 9:56:36 PM | Edit | Delete |
| BookingFlightsSimple | select top 50 bfs.booking_flight_segment_id ,fs.flight_id ,fs.departure_airport_id ,fs.arrival_airport_id ,ff.amount ,ff.financial_currency_id ,ff.financial_fare_id from booking_flight_segment as bfs inner join flight_segment as fs on fs.flight_segment_id = bfs.flight_segment_id inner join financial_fare as ff on ff.departure_airport_id = fs.departure_airport_id and ff.arrival_airport_id = fs.arrival_airport_id where bfs.booking_id = '3522f9d8-ee9e-46d7-8a8c-b769c0d40fb5' and bfs.became_booking_flight_segment_id is null and bfs.default_state_rcd <> dbo.ref('default_state_ref.I') | 1042 | 5/11/2024 7:18:24 AM | Edit | Delete |
| BookingFlightsSimple | select top 50 bfs.booking_flight_segment_id ,fs.flight_id ,fs.departure_airport_id ,fs.arrival_airport_id ,ff.amount ,ff.financial_currency_id ,ff.financial_fare_id from booking_flight_segment as bfs inner join flight_segment as fs on fs.flight_segment_id = bfs.flight_segment_id inner join financial_fare as ff on ff.departure_airport_id = fs.departure_airport_id and ff.arrival_airport_id = fs.arrival_airport_id where bfs.booking_id = 'd673b7e4-5941-4542-984f-c6deac8649eb' and bfs.became_booking_flight_segment_id is null and bfs.default_state_rcd <> dbo.ref('default_state_ref.I') | 1044 | 5/10/2024 12:55:46 AM | Edit | Delete |
| BookingFlightsSimple | select top 50 bfs.booking_flight_segment_id ,fs.flight_id ,fs.departure_airport_id ,fs.arrival_airport_id ,ff.amount ,ff.financial_currency_id ,ff.financial_fare_id from booking_flight_segment as bfs inner join flight_segment as fs on fs.flight_segment_id = bfs.flight_segment_id inner join financial_fare as ff on ff.departure_airport_id = fs.departure_airport_id and ff.arrival_airport_id = fs.arrival_airport_id where bfs.booking_id = '7ad198bd-4d75-4a3c-b0b9-18704fed5399' and bfs.became_booking_flight_segment_id is null and bfs.default_state_rcd <> dbo.ref('default_state_ref.I') | 517 | 5/11/2024 9:55:49 AM | Edit | Delete |
| BookingFlightsSimple | select top 50 bfs.booking_flight_segment_id ,fs.flight_id ,fs.departure_airport_id ,fs.arrival_airport_id ,ff.amount ,ff.financial_currency_id ,ff.financial_fare_id from booking_flight_segment as bfs inner join flight_segment as fs on fs.flight_segment_id = bfs.flight_segment_id inner join financial_fare as ff on ff.departure_airport_id = fs.departure_airport_id and ff.arrival_airport_id = fs.arrival_airport_id where bfs.booking_id = '19db2def-fe25-4ce0-a16b-be26f7bc846f' and bfs.became_booking_flight_segment_id is null and bfs.default_state_rcd <> dbo.ref('default_state_ref.I') | 533 | 5/10/2024 11:56:28 PM | Edit | Delete |
| BookingsOpen | select top 50 bo.booking_id ,( select top 1 booking_identifier_value from booking_identifier as bi where bi.booking_id = bo.booking_id and bi.booking_identifier_type_rcd = 'RL' order by bi.date_time desc ) as record_locator ,( select top 1 betr.booking_event_type_name from booking_event as be inner join booking_event_type_ref as betr on betr.booking_event_type_rcd = be.booking_event_type_rcd where be.booking_id = bo.booking_id order by be.date_time desc ) as last_booking_event_type_name ,( select top 1 be.date_time from booking_event as be where be.booking_id = bo.booking_id order by be.date_time desc ) as last_booking_event_date_time ,( select top 1 bcm.contact_method_way from booking_contact_method as bcm inner join contact_method_ref as cmr on cmr.contact_method_rcd = bcm.contact_method_rcd where bcm.booking_id = bo.booking_id order by bcm.date_time desc ) as last_booking_contact_method ,bsr.booking_source_name ,(select count(*) from booking_passenger as bp inner join passenger as pa on pa.passenger_id = bp.passenger_id and pa.passenger_type_rcd = 'AD' where bp.booking_id = bo.booking_id ) as adult_count ,(select count(*) from booking_passenger as bp inner join passenger as pa on pa.passenger_id = bp.passenger_id and pa.passenger_type_rcd = 'CHD' where bp.booking_id = bo.booking_id ) as child_count ,(select count(*) from booking_passenger as bp inner join passenger as pa on pa.passenger_id = bp.passenger_id and pa.passenger_type_rcd = 'INF' where bp.booking_id = bo.booking_id ) as infant_count ,( select coalesce((select sum(fbt.amount) from financial_booking_transaction as fbt where fbt.booking_id = bo.booking_id and (fbt.financial_payment_id is null and fbt.financial_adjustment_id is null) ), 0) - coalesce((select sum(fbt.amount) from financial_booking_transaction as fbt where fbt.booking_id = bo.booking_id and (fbt.financial_payment_id is not null or fbt.financial_adjustment_id is not null) ), 0)) as balance_amount from booking as bo inner join booking_source_ref as bsr on bsr.booking_source_rcd = bo.booking_source_rcd --realwhere order by bo.date_time desc -- (todo, crazy expensive) order by last_booking_event_date_time desc | 1070 | 5/12/2024 11:34:56 PM | Edit | Delete |
| DefaultErrorOverview | select top 50 de.default_error_id ,de.date_time ,delr.default_error_layer_name ,detr.default_error_type_name ,de.domain_name ,de.class_name ,de.method_name ,de.error_message from default_error as de inner join default_error_layer_ref as delr on delr.default_error_layer_rcd = de.default_error_layer_rcd inner join default_error_type_ref as detr on detr.default_error_type_rcd = de.default_error_type_rcd order by de.date_time desc | 548 | 5/15/2024 5:19:39 PM | Edit | Delete |
| DefaultErrorOverview | select top 50 de.default_error_id ,de.date_time ,delr.default_error_layer_name ,detr.default_error_type_name ,de.domain_name ,de.class_name ,de.method_name ,de.error_message from default_error as de inner join default_error_layer_ref as delr on delr.default_error_layer_rcd = de.default_error_layer_rcd inner join default_error_type_ref as detr on detr.default_error_type_rcd = de.default_error_type_rcd order by de.date_time desc | 2128 | 5/15/2024 12:47:25 AM | Edit | Delete |
| SolutionNorSolutionPort.DataAccessLayer.FlightSearch.BookingStatistics | select rr.date ,( select rri.count_number from reporting_roundup as rri where rri.date = rr.date and rri.reporting_roundup_type_rcd = dbo.ref('reporting_roundup_type_ref.Bookings') ) as passengers_booked_count ,( select rri.count_number from reporting_roundup as rri where rri.date = rr.date and rri.reporting_roundup_type_rcd = dbo.ref('reporting_roundup_type_ref.BP') and rri.reporting_reference_code = dbo.ref('passenger_type_ref.AD') ) as adult_booked_count ,( select rri.count_number from reporting_roundup as rri where rri.date = rr.date and rri.reporting_roundup_type_rcd = dbo.ref('reporting_roundup_type_ref.BP') and rri.reporting_reference_code = dbo.ref('passenger_type_ref.CHD') ) as child_booked_count ,( select rri.count_number from reporting_roundup as rri where rri.date = rr.date and rri.reporting_roundup_type_rcd = dbo.ref('reporting_roundup_type_ref.BP') and rri.reporting_reference_code = dbo.ref('passenger_type_ref.INF') ) as infant_booked_count from reporting_roundup as rr --realwhere where rr.date between '4/25/2024 4:27:07 PM' and '4/29/2024 4:27:07 PM' group by rr.date order by rr.date | 534 | 5/9/2024 12:55:45 PM | Edit | Delete |
| SolutionNorSolutionPort.DataAccessLayer.FlightSearch.BookingStatistics | select rr.date ,( select rri.count_number from reporting_roundup as rri where rri.date = rr.date and rri.reporting_roundup_type_rcd = dbo.ref('reporting_roundup_type_ref.Bookings') ) as passengers_booked_count ,( select rri.count_number from reporting_roundup as rri where rri.date = rr.date and rri.reporting_roundup_type_rcd = dbo.ref('reporting_roundup_type_ref.BP') and rri.reporting_reference_code = dbo.ref('passenger_type_ref.AD') ) as adult_booked_count ,( select rri.count_number from reporting_roundup as rri where rri.date = rr.date and rri.reporting_roundup_type_rcd = dbo.ref('reporting_roundup_type_ref.BP') and rri.reporting_reference_code = dbo.ref('passenger_type_ref.CHD') ) as child_booked_count ,( select rri.count_number from reporting_roundup as rri where rri.date = rr.date and rri.reporting_roundup_type_rcd = dbo.ref('reporting_roundup_type_ref.BP') and rri.reporting_reference_code = dbo.ref('passenger_type_ref.INF') ) as infant_booked_count from reporting_roundup as rr --realwhere where rr.date between '4/29/2024 2:07:38 PM' and '5/3/2024 2:07:38 PM' group by rr.date order by rr.date | 2047 | 5/9/2024 10:56:38 AM | Edit | Delete |
| SolutionNorSolutionPort.DataAccessLayer.FlightSearch.BookingStatistics | select rr.date ,( select rri.count_number from reporting_roundup as rri where rri.date = rr.date and rri.reporting_roundup_type_rcd = dbo.ref('reporting_roundup_type_ref.Bookings') ) as passengers_booked_count ,( select rri.count_number from reporting_roundup as rri where rri.date = rr.date and rri.reporting_roundup_type_rcd = dbo.ref('reporting_roundup_type_ref.BP') and rri.reporting_reference_code = dbo.ref('passenger_type_ref.AD') ) as adult_booked_count ,( select rri.count_number from reporting_roundup as rri where rri.date = rr.date and rri.reporting_roundup_type_rcd = dbo.ref('reporting_roundup_type_ref.BP') and rri.reporting_reference_code = dbo.ref('passenger_type_ref.CHD') ) as child_booked_count ,( select rri.count_number from reporting_roundup as rri where rri.date = rr.date and rri.reporting_roundup_type_rcd = dbo.ref('reporting_roundup_type_ref.BP') and rri.reporting_reference_code = dbo.ref('passenger_type_ref.INF') ) as infant_booked_count from reporting_roundup as rr --realwhere where rr.date between '4/26/2024 1:59:25 AM' and '4/30/2024 1:59:25 AM' group by rr.date order by rr.date | 518 | 5/9/2024 12:56:08 PM | Edit | Delete |
| SolutionNorSolutionPort.DataAccessLayer.FlightSearch.BookingStatistics | select rr.date ,( select rri.count_number from reporting_roundup as rri where rri.date = rr.date and rri.reporting_roundup_type_rcd = dbo.ref('reporting_roundup_type_ref.Bookings') ) as passengers_booked_count ,( select rri.count_number from reporting_roundup as rri where rri.date = rr.date and rri.reporting_roundup_type_rcd = dbo.ref('reporting_roundup_type_ref.BP') and rri.reporting_reference_code = dbo.ref('passenger_type_ref.AD') ) as adult_booked_count ,( select rri.count_number from reporting_roundup as rri where rri.date = rr.date and rri.reporting_roundup_type_rcd = dbo.ref('reporting_roundup_type_ref.BP') and rri.reporting_reference_code = dbo.ref('passenger_type_ref.CHD') ) as child_booked_count ,( select rri.count_number from reporting_roundup as rri where rri.date = rr.date and rri.reporting_roundup_type_rcd = dbo.ref('reporting_roundup_type_ref.BP') and rri.reporting_reference_code = dbo.ref('passenger_type_ref.INF') ) as infant_booked_count from reporting_roundup as rr --realwhere where rr.date between '5/4/2024 11:06:46 AM' and '5/8/2024 11:06:46 AM' group by rr.date order by rr.date | 520 | 5/9/2024 4:56:16 PM | Edit | Delete |
| SolutionNorSolutionPort.DataAccessLayer.FlightSearch.BookingStatistics | select rr.date ,( select rri.count_number from reporting_roundup as rri where rri.date = rr.date and rri.reporting_roundup_type_rcd = dbo.ref('reporting_roundup_type_ref.Bookings') ) as passengers_booked_count ,( select rri.count_number from reporting_roundup as rri where rri.date = rr.date and rri.reporting_roundup_type_rcd = dbo.ref('reporting_roundup_type_ref.BP') and rri.reporting_reference_code = dbo.ref('passenger_type_ref.AD') ) as adult_booked_count ,( select rri.count_number from reporting_roundup as rri where rri.date = rr.date and rri.reporting_roundup_type_rcd = dbo.ref('reporting_roundup_type_ref.BP') and rri.reporting_reference_code = dbo.ref('passenger_type_ref.CHD') ) as child_booked_count ,( select rri.count_number from reporting_roundup as rri where rri.date = rr.date and rri.reporting_roundup_type_rcd = dbo.ref('reporting_roundup_type_ref.BP') and rri.reporting_reference_code = dbo.ref('passenger_type_ref.INF') ) as infant_booked_count from reporting_roundup as rr --realwhere where rr.date between '4/11/2024 11:08:51 PM' and '4/15/2024 11:08:51 PM' group by rr.date order by rr.date | 2053 | 5/9/2024 12:42:06 PM | Edit | Delete |
| SolutionNorSolutionPort.DataAccessLayer.FlightSearch.BookingStatistics | select rr.date ,( select rri.count_number from reporting_roundup as rri where rri.date = rr.date and rri.reporting_roundup_type_rcd = dbo.ref('reporting_roundup_type_ref.Bookings') ) as passengers_booked_count ,( select rri.count_number from reporting_roundup as rri where rri.date = rr.date and rri.reporting_roundup_type_rcd = dbo.ref('reporting_roundup_type_ref.BP') and rri.reporting_reference_code = dbo.ref('passenger_type_ref.AD') ) as adult_booked_count ,( select rri.count_number from reporting_roundup as rri where rri.date = rr.date and rri.reporting_roundup_type_rcd = dbo.ref('reporting_roundup_type_ref.BP') and rri.reporting_reference_code = dbo.ref('passenger_type_ref.CHD') ) as child_booked_count ,( select rri.count_number from reporting_roundup as rri where rri.date = rr.date and rri.reporting_roundup_type_rcd = dbo.ref('reporting_roundup_type_ref.BP') and rri.reporting_reference_code = dbo.ref('passenger_type_ref.INF') ) as infant_booked_count from reporting_roundup as rr --realwhere where rr.date between '4/30/2024 5:35:23 PM' and '5/4/2024 5:35:23 PM' group by rr.date order by rr.date | 1039 | 5/9/2024 12:41:44 PM | Edit | Delete |
| SolutionNorSolutionPort.DataAccessLayer.FlightSearch.BookingStatistics | select rr.date ,( select rri.count_number from reporting_roundup as rri where rri.date = rr.date and rri.reporting_roundup_type_rcd = dbo.ref('reporting_roundup_type_ref.Bookings') ) as passengers_booked_count ,( select rri.count_number from reporting_roundup as rri where rri.date = rr.date and rri.reporting_roundup_type_rcd = dbo.ref('reporting_roundup_type_ref.BP') and rri.reporting_reference_code = dbo.ref('passenger_type_ref.AD') ) as adult_booked_count ,( select rri.count_number from reporting_roundup as rri where rri.date = rr.date and rri.reporting_roundup_type_rcd = dbo.ref('reporting_roundup_type_ref.BP') and rri.reporting_reference_code = dbo.ref('passenger_type_ref.CHD') ) as child_booked_count ,( select rri.count_number from reporting_roundup as rri where rri.date = rr.date and rri.reporting_roundup_type_rcd = dbo.ref('reporting_roundup_type_ref.BP') and rri.reporting_reference_code = dbo.ref('passenger_type_ref.INF') ) as infant_booked_count from reporting_roundup as rr --realwhere where rr.date between '4/21/2024 4:40:47 AM' and '4/25/2024 4:40:47 AM' group by rr.date order by rr.date | 1026 | 5/9/2024 12:42:12 PM | Edit | Delete |
| SolutionNorSolutionPort.DataAccessLayer.FlightSearch.FlightsOpenForCheckinWithDescription | select ai.airline_identifier_code ,fi.flight_identifier_code as flight_number ,dai.airport_identifier_code as departure_airport_identifier_code ,da.airport_name as departure_airport_name ,aai.airport_identifier_code as arrival_airport_identifier_code ,aa.airport_name as arrival_airport_name ,fl.from_date_time ,fl.until_date_time ,( select count(*) from flight_segment as fs inner join booking_flight_segment as bfs on bfs.flight_segment_id = fs.flight_segment_id and bfs.became_booking_flight_segment_id is null inner join booking_passenger as bp on bp.booking_id = bfs.booking_id and bp.became_booking_passenger_id is null where fs.flight_id = fl.flight_id ) as passengers_booked_count , ai.airline_identifier_code + ' ' + fi.flight_identifier_code + ' ' + dai.airport_identifier_code + ' ' + aai.airport_identifier_code as flight_description ,fl.flight_id from flight as fl inner join airline_identifier as ai on ai.airline_id = fl.airline_id and ai.airline_identifier_type_rcd = dbo.ref('airline_identifier_type_ref.AC3') inner join airport as da on da.airport_id = fl.departure_airport_id inner join airport as aa on aa.airport_id = fl.arrival_airport_id inner join airport_identifier as dai on dai.airport_id = fl.departure_airport_id and dai.airport_identifier_type_rcd = dbo.ref('airport_identifier_type_ref.AC3') inner join airport_identifier as aai on aai.airport_id = fl.arrival_airport_id and aai.airport_identifier_type_rcd = dbo.ref('airport_identifier_type_ref.AC3') left join flight_identifier as fi on fi.flight_id = fl.flight_id and fi.flight_identifier_type_rcd = dbo.ref('flight_identifier_type_ref.FN3') --realwhere where fl.from_date_time between '5/12/2024 12:00:00 AM' and '5/13/2024 12:00:00 AM' and fl.became_flight_id is null and dbo.FlightEventOneIsLast( fl.flight_id, dbo.ref('date_time_type_ref.CO'), dbo.ref('date_time_type_ref.CC') ) = 1 order by fl.from_date_time | 870 | 5/12/2024 10:22:29 PM | Edit | Delete |
| SolutionNorSolutionPort.DataAccessLayer.FlightSearch.FlightsWithBookingInformation | select fl.flight_id ,ai.airline_identifier_code ,fi.flight_identifier_code as flight_number ,dai.airport_identifier_code as departure_airport_identifier_code ,da.airport_name as departure_airport_name ,aai.airport_identifier_code as arrival_airport_identifier_code ,aa.airport_name as arrival_airport_name ,fl.from_date_time ,fl.until_date_time ,dbo.FlightEventOneIsLast( fl.flight_id, dbo.ref('date_time_type_ref.BO'), dbo.ref('date_time_type_ref.BC') ) as can_book_flag ,dbo.FlightEventOneIsLast( fl.flight_id, dbo.ref('date_time_type_ref.CO'), dbo.ref('date_time_type_ref.CC') ) as can_checkin_flag ,dbo.FlightEventOneIsLast( fl.flight_id, dbo.ref('date_time_type_ref.TO'), dbo.ref('date_time_type_ref.TD') ) as in_flight_flag ,( select count(*) from flight_segment as fs inner join booking_flight_segment as bfs on bfs.flight_segment_id = fs.flight_segment_id and bfs.became_booking_flight_segment_id is null where fs.flight_id = fl.flight_id ) as flights_booked_count ,( select top 1 dttr.date_time_type_name from flight_event as fe inner join date_time_type_ref as dttr on dttr.date_time_type_rcd = fe.date_time_type_rcd where fe.flight_id = fl.flight_id order by fe.date_time desc ) as last_date_time_type_name ,( select top 1 fe.new_date_time from flight_event as fe where fe.flight_id = fl.flight_id and fe.date_time_type_rcd = dbo.ref('date_time_type_ref.PD') order by fe.date_time desc ) as planned_departure_date_time ,( select top 1 fe.new_date_time from flight_event as fe where fe.flight_id = fl.flight_id and fe.date_time_type_rcd = dbo.ref('date_time_type_ref.ED') order by fe.date_time desc ) as estimated_departure_date_time from flight as fl inner join airline_identifier as ai on ai.airline_id = fl.airline_id and ai.airline_identifier_type_rcd = dbo.ref('airline_identifier_type_ref.AC3') inner join airport as da on da.airport_id = fl.departure_airport_id inner join airport as aa on aa.airport_id = fl.arrival_airport_id inner join airport_identifier as dai on dai.airport_id = fl.departure_airport_id and dai.airport_identifier_type_rcd = dbo.ref('airport_identifier_type_ref.AC3') inner join airport_identifier as aai on aai.airport_id = fl.arrival_airport_id and aai.airport_identifier_type_rcd = dbo.ref('airport_identifier_type_ref.AC3') left join flight_identifier as fi on fi.flight_id = fl.flight_id and fi.flight_identifier_type_rcd = dbo.ref('flight_identifier_type_ref.FN3') --realwhere where fl.from_date_time between '5/20/2024 12:00:00 AM' and '5/21/2024 12:00:00 AM' and fl.became_flight_id is null order by fl.from_date_time | 525 | 5/20/2024 3:49:09 AM | Edit | Delete |
| SolutionNorSolutionPort.DataAccessLayer.FlightSearch.FlightsWithBookingInformation | select fl.flight_id ,ai.airline_identifier_code ,fi.flight_identifier_code as flight_number ,dai.airport_identifier_code as departure_airport_identifier_code ,da.airport_name as departure_airport_name ,aai.airport_identifier_code as arrival_airport_identifier_code ,aa.airport_name as arrival_airport_name ,fl.from_date_time ,fl.until_date_time ,dbo.FlightEventOneIsLast( fl.flight_id, dbo.ref('date_time_type_ref.BO'), dbo.ref('date_time_type_ref.BC') ) as can_book_flag ,dbo.FlightEventOneIsLast( fl.flight_id, dbo.ref('date_time_type_ref.CO'), dbo.ref('date_time_type_ref.CC') ) as can_checkin_flag ,dbo.FlightEventOneIsLast( fl.flight_id, dbo.ref('date_time_type_ref.TO'), dbo.ref('date_time_type_ref.TD') ) as in_flight_flag ,( select count(*) from flight_segment as fs inner join booking_flight_segment as bfs on bfs.flight_segment_id = fs.flight_segment_id and bfs.became_booking_flight_segment_id is null where fs.flight_id = fl.flight_id ) as flights_booked_count ,( select top 1 dttr.date_time_type_name from flight_event as fe inner join date_time_type_ref as dttr on dttr.date_time_type_rcd = fe.date_time_type_rcd where fe.flight_id = fl.flight_id order by fe.date_time desc ) as last_date_time_type_name ,( select top 1 fe.new_date_time from flight_event as fe where fe.flight_id = fl.flight_id and fe.date_time_type_rcd = dbo.ref('date_time_type_ref.PD') order by fe.date_time desc ) as planned_departure_date_time ,( select top 1 fe.new_date_time from flight_event as fe where fe.flight_id = fl.flight_id and fe.date_time_type_rcd = dbo.ref('date_time_type_ref.ED') order by fe.date_time desc ) as estimated_departure_date_time from flight as fl inner join airline_identifier as ai on ai.airline_id = fl.airline_id and ai.airline_identifier_type_rcd = dbo.ref('airline_identifier_type_ref.AC3') inner join airport as da on da.airport_id = fl.departure_airport_id inner join airport as aa on aa.airport_id = fl.arrival_airport_id inner join airport_identifier as dai on dai.airport_id = fl.departure_airport_id and dai.airport_identifier_type_rcd = dbo.ref('airport_identifier_type_ref.AC3') inner join airport_identifier as aai on aai.airport_id = fl.arrival_airport_id and aai.airport_identifier_type_rcd = dbo.ref('airport_identifier_type_ref.AC3') left join flight_identifier as fi on fi.flight_id = fl.flight_id and fi.flight_identifier_type_rcd = dbo.ref('flight_identifier_type_ref.FN3') --realwhere where fl.from_date_time between '5/17/2024 12:00:00 AM' and '5/18/2024 12:00:00 AM' and fl.became_flight_id is null order by fl.from_date_time | 633 | 5/17/2024 3:38:50 AM | Edit | Delete |
| SolutionNorSolutionPort.DataAccessLayer.FlightSearch.TransactionsCreditDebitBalance | select top 50 cast(datepart(year, fl.from_date_time) as char(4)) + cast(datepart(month, fl.from_date_time) as varchar(2)) + cast(datepart(day, fl.from_date_time) as varchar(2)) as date ,( select sum(fbt.amount) from financial_booking_transaction as fbt where datepart(year, fbt.date_time) = datepart(year, fl.from_date_time) and datepart(month, fbt.date_time) = datepart(month, fl.from_date_time) and datepart(day, fbt.date_time) = datepart(day, fl.from_date_time) and fbt.financial_payment_id is null and fbt.financial_adjustment_id is null ) as debit_amount ,( select sum(fbt.amount) from financial_booking_transaction as fbt where datepart(year, fbt.date_time) = datepart(year, fl.from_date_time) and datepart(month, fbt.date_time) = datepart(month, fl.from_date_time) and datepart(day, fbt.date_time) = datepart(day, fl.from_date_time) and (fbt.financial_payment_id is not null or fbt.financial_adjustment_id is not null) ) as credit_amount from flight as fl --realwhere where fl.from_date_time between '5/10/2024 8:55:29 AM' and '5/14/2024 8:55:29 AM' and fl.became_flight_id is null group by datepart(year, fl.from_date_time) ,datepart(month, fl.from_date_time) ,datepart(day, fl.from_date_time) order by datepart(year, fl.from_date_time) ,datepart(month, fl.from_date_time) ,datepart(day, fl.from_date_time) | 1040 | 5/12/2024 9:12:17 AM | Edit | Delete |