select host_id as ID,
host_name as Name,
host_ip as IP,
avail_name as Avail,
host_serial as 'Serial',
host_app as App,
os_name as OS,
host_oslevel as 'Level',
manufac_name as Manufac,
model_name as Model,
console_name as Console,
console_name as Console2,
constype_name as 'Console Type'
from ee_host 
LEFT JOIN ee_os on os_id=host_os 
LEFT JOIN model_model on model_id=host_model
LEFT JOIN model_manufac on manufac_id=model_manufac
LEFT JOIN ee_avail on host_avail=avail_id
LEFT JOIN console_name on console_id=host_console 
LEFT JOIN console_name as console_name2 on console_id=host_console2
LEFT JOIN console_type on constype_id=console_type