SELECT `travels`.`id`, `travels`.`destination`, `travels`.`user_id`, `travels`.`vehicle_id`, `travels`.`responsible_id`, `travels`.`distance`, `travels`.`createdAt`, `travels`.`updatedAt`, `user`.`id` AS `user.id`, `user`.`firstName` AS `user.firstName`, `user`.`lastName` AS `user.lastName`, `user`.`cpf` AS `user.cpf`, `user`.`email` AS `user.email`, `user`.`registration` AS `user.registration`, `responsible`.`id` AS `responsible.id`, `responsible`.`firstName` AS `responsible.firstName`, `responsible`.`lastName` AS `responsible.lastName`, `responsible`.`cpf` AS `responsible.cpf`, `responsible`.`email` AS `responsible.email`, `responsible`.`registration` AS `responsible.registration`, `travel_products`.`id` AS `travel_products.id`, `travel_products`.`travel_id` AS `travel_products.travel_id`, `travel_products`.`product_id` AS `travel_products.product_id`, `travel_products`.`createdAt` AS `travel_products.createdAt`, `travel_products`.`updatedAt` AS `travel_products.updatedAt`, `travel_products->product`.`id` AS `travel_products.product.id`, `travel_products->product`.`name` AS `travel_products.product.name`, `travel_products->product`.`type` AS `travel_products.product.type`, `travel_products->product`.`delivered` AS `travel_products.product.delivered`, `travel_products->product`.`user_id` AS `travel_products.product.user_id`, `travel_products->product`.`createdAt` AS `travel_products.product.createdAt`, `travel_products->product`.`updatedAt` AS `travel_products.product.updatedAt` FROM `travels` AS `travels` LEFT OUTER JOIN `users` AS `user` ON `travels`.`user_id` = `user`.`id` LEFT OUTER JOIN `users` AS `responsible` ON `travels`.`responsible_id` = `responsible`.`id` LEFT OUTER JOIN `travel_products` AS `travel_products` ON `travels`.`id` = `travel_products`.`travel_id` LEFT OUTER JOIN `product` AS `travel_products->product` ON `travel_products`.`product_id` = `travel_products->product`.`id`;