SELECT 
obj_main.isys_obj__id AS '__id__', 
obj_main.isys_obj__title AS 'LC__UNIVERSAL__TITLE###0_1', 
j6.isys_cats_person_list__first_name AS 'LC__CONTACT__PERSON_FIRST_NAME###1_49', 
j6.isys_cats_person_list__last_name AS 'LC__CONTACT__PERSON_LAST_NAME###1_49', 
j6.isys_cats_person_list__title AS 'LC__CONTACT__PERSON_USER_NAME###1_50', 
j9.isys_catg_mail_addresses_list__title AS 'LC__CONTACT__GROUP_EMAIL_ADDRESS###1_53', 
j6.isys_cats_person_list__phone_company AS 'LC__CONTACT__PERSON_TELEPHONE_COMPANY###1_49', 
j6.isys_cats_person_list__phone_home AS 'LC__CONTACT__PERSON_TELEPHONE_HOME###1_49', 
job8.isys_obj__title AS 'LC__CONTACT__PERSON_ASSIGNED_ORGANISATION###1_49', 
j6.isys_cats_person_list__department AS 'LC__CONTACT__PERSON_DEPARTMENT###1_49', 
j6.isys_cats_person_list__service_designation AS 'LC__CONTACT__PERSON_SERVICE_DESIGNATION###1_49', 
j6.isys_cats_person_list__function AS 'LC__CONTACT__PERSON_FUNKTION###1_49', 
j11.isys_catg_custom_fields_list__field_content AS 'locales::fmt_date::Eintrittsdatum###4_22', 
j1.isys_cmdb_status__title AS 'LC__UNIVERSAL__CMDB_STATUS###0_1', 
obj_main.isys_obj__created_by AS 'LC__UNIVERSAL__CREATED_BY###0_1', 
obj_main.isys_obj__created AS 'isys_cmdb_dao_category_g_global::dynamic_property_callback_created::isys_obj__created::LC__TASK__DETAIL__WORKORDER__CREATION_DATE', 
obj_main.isys_obj__updated AS 'isys_cmdb_dao_category_g_global::dynamic_property_callback_changed::isys_obj__updated::LC__CMDB__LAST_CHANGE', 
obj_main.isys_obj__updated_by AS 'LC__CMDB__LAST_CHANGE_BY###0_1', 
j5.isys_obj_type__title AS 'LC__REPORT__FORM__OBJECT_TYPE###0_1', 
j2.isys_catg_global_category__title AS 'LC__CMDB__CATG__GLOBAL_CATEGORY###0_1', 
obj_main.isys_obj__id  AS 'isys_cmdb_dao_category_g_global::getAssignedTags::isys_obj__id::LC__CMDB__CATG__GLOBAL_TAG' 

 FROM isys_obj AS obj_main 
INNER 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_catg_global_list AS j3 ON j3.isys_catg_global_list__isys_obj__id = obj_main.isys_obj__id  
LEFT JOIN isys_catg_global_category AS j2 ON j2.isys_catg_global_category__id = j3.isys_catg_global_list__isys_catg_global_category__id 
LEFT JOIN isys_cmdb_status AS j1 ON j1.isys_cmdb_status__id = obj_main.isys_obj__isys_cmdb_status__id 
LEFT JOIN isys_obj_type AS j5 ON j5.isys_obj_type__id = obj_main.isys_obj__isys_obj_type__id 
LEFT JOIN isys_cats_person_list AS j6 ON j6.isys_cats_person_list__isys_obj__id = obj_main.isys_obj__id  
LEFT JOIN isys_connection AS j8 ON j8.isys_connection__id = j6.isys_cats_person_list__isys_connection__id 
LEFT JOIN isys_obj AS job8 ON j8.isys_connection__isys_obj__id = job8.isys_obj__id 
LEFT JOIN isys_catg_mail_addresses_list AS j9 ON j9.isys_catg_mail_addresses_list__isys_obj__id = obj_main.isys_obj__id  AND j9.isys_catg_mail_addresses_list__primary = 1  
LEFT JOIN isys_catg_custom_fields_list AS ROOT_C__CATG__CUSTOM_FIELDS_EIN_UND_AUSTRITTSDATUM ON obj_main.isys_obj__id = ROOT_C__CATG__CUSTOM_FIELDS_EIN_UND_AUSTRITTSDATUM.isys_catg_custom_fields_list__isys_obj__id
                                AND ROOT_C__CATG__CUSTOM_FIELDS_EIN_UND_AUSTRITTSDATUM.isys_catg_custom_fields_list__isysgui_catg_custom__id = (SELECT isysgui_catg_custom__id FROM isysgui_catg_custom WHERE isysgui_catg_custom__const = 'C__CATG__CUSTOM_FIELDS_EIN_UND_AUSTRITTSDATUM')
                                AND ROOT_C__CATG__CUSTOM_FIELDS_EIN_UND_AUSTRITTSDATUM.isys_catg_custom_fields_list__field_type = 'commentary'  LEFT JOIN isys_catg_custom_fields_list AS j11 ON obj_main.isys_obj__id = j11.isys_catg_custom_fields_list__isys_obj__id AND j11.isys_catg_custom_fields_list__field_key = 'c_17628546009944330' 
                                AND j11.isys_catg_custom_fields_list__data__id = ROOT_C__CATG__CUSTOM_FIELDS_EIN_UND_AUSTRITTSDATUM.isys_catg_custom_fields_list__data__id  

WHERE TRUE 
 AND  ( (j5.isys_obj_type__id != '60' ) AND (j5.isys_obj_type__id != '63' ) ) AND ( (j5.isys_obj_type__id = '53' ) ) AND ( (j1.isys_cmdb_status__id = '6' ) AND obj_main.isys_obj__status = '2' ) AND (  (j6.isys_cats_person_list__title IS NOT NULL AND j6.isys_cats_person_list__title != '')  )
 ORDER BY obj_main.isys_obj__title ASC