SELECT * FROM ((nagios

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;