SELECT
     era_db.tbl_computers.computer_name,
     era_db.tbl_computers.computer_comment,
     era_db.tbld_network_ipaddresses_status_address.Address,
     era_db.tbl_staff_user.name,
     era_db.tbl_staff_user.description,
     era_db.tbl_staff_user.mail
  FROM
     era_db.tbl_computers
          LEFT OUTER JOIN era_db.tbl_staff_relations ON (era_db.tbl_computers.computer_id = era_db.tbl_staff_relations.computer_id )
          LEFT OUTER JOIN era_db.tbl_staff_user ON
               (
               era_db.tbl_staff_user.staff_user_id=era_db.tbl_staff_relations.staff_user_id
               AND
               era_db.tbl_staff_relations.removed!=1
               )
          LEFT OUTER JOIN era_db.tblf_network_ipaddresses_status ON
               (
               era_db.tbl_computers.computer_id = era_db.tblf_network_ipaddresses_status.SourceUuid_id
               AND
               era_db.tblf_network_ipaddresses_status.Ordering=0
               )
          LEFT OUTER JOIN era_db.tbld_network_ipaddresses_status_address ON
               (
               era_db.tblf_network_ipaddresses_status.Address_skey = era_db.tbld_network_ipaddresses_status_address.skey
               )
   WHERE era_db.tbl_staff_user.name IS NULL AND era_db.tbl_computers.removed!=1
   ORDER BY era_db.tbl_staff_user.name