SELECT 
	 era_db.dbo.tbl_computers.computer_name
	,era_db.dbo.tbl_computers.computer_comment
	,era_db.dbo.tbld_network_ipaddresses_status_address.Address
	,era_db.dbo.tbl_staff_user.name
	,era_db.dbo.tbl_staff_user.description 
	,era_db.dbo.tbl_staff_user.mail
	
   FROM	  
	era_db.dbo.tbl_computers
		 
	LEFT OUTER JOIN era_db.dbo.tbl_staff_relations ON (era_db.dbo.tbl_computers.computer_id = era_db.dbo.tbl_staff_relations.computer_id )
  
	LEFT OUTER JOIN era_db.dbo.tbl_staff_user ON 
		(
			era_db.dbo.tbl_staff_user.staff_user_id=era_db.dbo.tbl_staff_relations.staff_user_id 
			AND
			era_db.dbo.tbl_staff_relations.removed!=1
		)

        LEFT OUTER JOIN era_db.dbo.tblf_network_ipaddresses_status ON
		(
			era_db.dbo.tbl_computers.computer_id = era_db.dbo.tblf_network_ipaddresses_status.SourceUuid_id
			AND
			era_db.dbo.tblf_network_ipaddresses_status.Ordering=0
		)

        LEFT OUTER JOIN era_db.dbo.tbld_network_ipaddresses_status_address ON
		(
			era_db.dbo.tblf_network_ipaddresses_status.Address_skey = era_db.dbo.tbld_network_ipaddresses_status_address.skey
		)

   WHERE era_db.dbo.tbl_staff_user.name IS NULL AND era_db.dbo.tbl_computers.removed!=1
   
   ORDER BY era_db.dbo.tbl_staff_user.name