Hallo Barracuda,

versuch mal folgende Abfrage:

SELECT
obj_main.isys_obj__id AS 'ID',
(CASE obj_main.isys_obj__status WHEN 1 THEN 'LC__CMDB__RECORD_STATUS__BIRTH' WHEN 2 THEN 'LC__CMDB__RECORD_STATUS__NORMAL' WHEN 3 THEN 'LC__CMDB__RECORD_STATUS__ARCHIVED' WHEN 4 THEN 'LC__CMDB__RECORD_STATUS__DELETED' END) AS 'LC__UNIVERSAL__CONDITION' ,
jn1.isys_obj_type__title AS 'LC__REPORT__FORM__OBJECT_TYPE###1',
j3.isys_obj__title AS 'LC__CMDB__CATG__LOCATION###26' ,
loc.isys_catg_location_list__description AS 'Beschreibung'

FROM isys_obj AS obj_main
LEFT JOIN isys_cmdb_status AS obj_main_status ON obj_main_status.isys_cmdb_status__id = obj_main.isys_obj__isys_cmdb_status__id
LEFT JOIN isys_obj_type AS jn1 ON jn1.isys_obj_type__id = obj_main.isys_obj__isys_obj_type__id
LEFT JOIN isys_catg_location_list AS loc  ON loc.isys_catg_location_list__isys_obj__id = obj_main.isys_obj__id
LEFT JOIN isys_obj AS j3 ON loc.isys_catg_location_list__parentid = j3.isys_obj__id

WHERE TRUE
AND obj_main.isys_obj__status = 2;

Gruss,
jkondek