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_modelLEFT JOIN model_manufac on manufac_id=model_manufacLEFT JOIN ee_avail on host_avail=avail_idLEFT JOIN console_name on console_id=host_console LEFT JOIN console_name as console_name2 on console_id=host_console2LEFT JOIN console_type on constype_id=console_type