[2025-01-25 13:40:54] live.INFO: Business ID: 1  
[2025-01-25 13:40:54] live.INFO: Raw Query: select `transactions`.`id`, `transactions`.`transaction_date`, `transactions`.`ref_no`, `l1`.`name` as `location_from`, `l2`.`name` as `location_to`, COALESCE(transactions.final_total, 0) as final_total, COALESCE(transactions.shipping_charges, 0) as shipping_charges, `transactions`.`additional_notes`, `transactions`.`status`, `transactions`.`driver`, `transactions`.`vehicle`, `transactions`.`dropoff_datetime`, `transactions`.`region`, `transactions`.`waybill_no`, `transactions`.`mileage` from `transactions` inner join `business_locations` as `l1` on `transactions`.`location_id` = `l1`.`id` left join `transactions` as `t2` on `transactions`.`id` = `t2`.`transfer_parent_id` left join `business_locations` as `l2` on `t2`.`location_id` = `l2`.`id` where `transactions`.`business_id` = ? and `transactions`.`type` = ?  
[2025-01-25 13:40:54] live.INFO: Query Bindings: [1,"sell_transfer"]  
[2025-01-25 14:03:14] live.INFO: Business ID: 1  
[2025-01-25 14:03:14] live.INFO: Raw Query: select `transactions`.`id`, `transactions`.`transaction_date`, `transactions`.`ref_no`, `l1`.`name` as `location_from`, `l2`.`name` as `location_to`, COALESCE(transactions.final_total, 0) as final_total, COALESCE(transactions.shipping_charges, 0) as shipping_charges, `transactions`.`additional_notes`, `transactions`.`status`, `transactions`.`driver`, `transactions`.`vehicle`, `transactions`.`dropoff_datetime`, `transactions`.`region`, `transactions`.`waybill_no`, `transactions`.`mileage` from `transactions` inner join `business_locations` as `l1` on `transactions`.`location_id` = `l1`.`id` left join `transactions` as `t2` on `transactions`.`id` = `t2`.`transfer_parent_id` left join `business_locations` as `l2` on `t2`.`location_id` = `l2`.`id` where `transactions`.`business_id` = ? and `transactions`.`type` = ?  
[2025-01-25 14:03:14] live.INFO: Query Bindings: [1,"sell_transfer"]