SELECT xyzs_from.fa_name AS fa_name_from,xyzs_to.fa_name AS fa_name_to,CONCAT( ezr_iranianvehicles.plak ,'--', ezr_vehicle_colors.fa_vehicle_color ,'--', ezr_vehicle_types.fa_vehicle_name) AS vehicle,ezr_partners.partner_fa_name,CONCAT(ezr_persons.fa_fname , ' ' , ezr_persons.fa_lname) AS name,ezr_tasks_iraniantransfers.DATE,ezr_tasks_iraniantransfers.TIME,ezr_tasks_iraniantransfers.iraniantransfer_details FROM ezr_tasks_iraniantransfers ( LEFT JOIN ezr_partners ON ezr_partners.id = ezr_tasks_iraniantransfers.id_ezr_partners ) INNER JOIN ezr_iraniandrivers ON ezr_iraniandrivers.id_ezr_iraniandrivers = ezr_tasks_iraniantransfers.id_ezr_iraniandrivers INNER JOIN ezr_persons_types ON ezr_persons_types.id_ezr_persons_types = ezr_iraniandrivers.id_ezr_persons_types INNER JOIN ezr_persons ON ezr_persons.id = ezr_persons_types.id_ezr_persons INNER JOIN ezr_iranianvehicles ON ezr_iranianvehicles.id_ezr_iranianvehicles = ezr_tasks_iraniantransfers.id_ezr_iranianvehicles INNER JOIN ezr_vehicle_types ON ezr_iranianvehicles.id_ezr_vehicle_types = ezr_vehicle_types.id INNER JOIN ezr_vehicle_colors ON ezr_iranianvehicles.id_ezr_vehicle_colors = ezr_vehicle_colors.id INNER JOIN xyzs AS xyzs_from ON xyzs_from.id = ezr_tasks_iraniantransfers.id_xyzs_from INNER JOIN xyzs AS xyzs_to ON xyzs_to.id = ezr_tasks_iraniantransfers.id_xyzs_to