SELECT * FROM ((nagios_servicestatus
  INNER JOIN nagios_services
    ON nagios_servicestatus.service_object_id=nagios_services.service_object_id)
  INNER JOIN nagios_hosts
    ON nagios_services.host_object_id=nagios_hosts.host_object_id)
  INNER JOIN nagios_hoststatus
    ON nagios_hosts.host_id=nagios_hoststatus.hoststatus_id
  WHERE nagios_servicestatus.current_state > 1 AND    
    nagios_servicestatus.problem_has_been_acknowledged=0 AND
    nagios_hoststatus.problem_has_been_acknowledged=0;