SELECT emp_dir.*, pobs.nombre as pob, provs.nombre as provincia, emp.apikey, emp.comercial as nombrebueno, emails.email as email_empresa, paises.nombre as nombre_pais FROM emp_dir LEFT JOIN emails ON emails.cod=emp_dir.cod_emp LEFT JOIN emp ON emails.cod_emp=emp.cod LEFT JOIN pobs ON emp_dir.cod_pob=pobs.cod LEFT JOIN provs ON emp_dir.cod_prov=provs.cod LEFT JOIN paises ON paises.cod=emp_dir.pais WHERE emails.cod_emp=607 ORDER BY emp_dir.orden