Hat sich erledigt!
Habe das ganze ohne JOINS gelöst. Die haben eh nur verwirrt :D
Funktionierender SQL Befehl:
PHP-Code:
$query = "
SELECT
icinga_services.host_object_id,
icinga_services.service_object_id,
icinga_services.display_name,
icinga_servicestatus.service_object_id,
icinga_servicestatus.output,
icinga_servicestatus.last_check,
icinga_hosts.host_object_id,
icinga_hosts.alias
FROM
icinga_services,
icinga_hosts,
icinga_servicestatus
WHERE
icinga_services.service_object_id = icinga_servicestatus.service_object_id
AND
icinga_services.host_object_id = icinga_hosts.host_object_id
AND
icinga_hosts.alias LIKE '%rad-az%'
AND
icinga_services.display_name LIKE '%ping%'";