SELECT 
obj_main.isys_obj__id AS '__id__', 
j1.isys_cmdb_status__title AS 'LC__UNIVERSAL__CMDB_STATUS###0_1', 
obj_main.isys_obj__title AS 'LC__UNIVERSAL__TITLE###0_1', 
obj_main.isys_obj__description AS 'LC__CMDB__LOGBOOK__DESCRIPTION###0_1', 
j8.isys_obj__title AS 'LC__UNIVERSAL__TITLE#LC__CONTACT__TREE__MEMBERS###catg_1', 
j14.isys_cats_person_list__last_name AS 'LC__CONTACT__PERSON_LAST_NAME#LC__CONTACT__TREE__MEMBERS###cats_49', 
j14.isys_cats_person_list__first_name AS 'LC__CONTACT__PERSON_FIRST_NAME#LC__CONTACT__TREE__MEMBERS###cats_49', 
j14.isys_cats_person_list__department AS 'LC__CONTACT__PERSON_DEPARTMENT#LC__CONTACT__TREE__MEMBERS###cats_49', 
j14.isys_cats_person_list__service_designation AS 'LC__CONTACT__PERSON_SERVICE_DESIGNATION#LC__CONTACT__TREE__MEMBERS###cats_49', 
j11.isys_catg_mail_addresses_list__title AS 'LC__CONTACT__PERSON_MAIL_ADDRESS#LC__CONTACT__TREE__MEMBERS###cats_49', 
job13.isys_obj__title AS 'LC__UNIVERSAL__TITLE#LC__CONTACT__PERSON_ASSIGNED_ORGANISATION#LC__CONTACT__TREE__MEMBERS###catg_1' 

 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_cmdb_status AS j1 ON j1.isys_cmdb_status__id = obj_main.isys_obj__isys_cmdb_status__id 
LEFT JOIN isys_person_2_group AS j2 ON obj_main.isys_obj__id = j2.isys_person_2_group__isys_obj__id__group 
LEFT JOIN isys_cats_person_list AS j4 ON j2.isys_person_2_group__isys_obj__id__person = j4.isys_cats_person_list__isys_obj__id 
LEFT JOIN isys_obj AS j7 ON j7.isys_obj__id = j4.isys_cats_person_list__isys_obj__id 
LEFT JOIN isys_obj AS j8 ON j8.isys_obj__id = j4.isys_cats_person_list__isys_obj__id 
LEFT JOIN isys_cats_person_list AS j14 ON j14.isys_cats_person_list__isys_obj__id = j4.isys_cats_person_list__isys_obj__id  
LEFT JOIN isys_obj AS j10 ON j10.isys_obj__id = j14.isys_cats_person_list__isys_obj__id 
LEFT JOIN isys_catg_mail_addresses_list AS j11 ON j11.isys_catg_mail_addresses_list__isys_obj__id = j14.isys_cats_person_list__isys_obj__id  AND j11.isys_catg_mail_addresses_list__primary = 1  
LEFT JOIN isys_obj AS j12 ON j12.isys_obj__id = j11.isys_catg_mail_addresses_list__isys_obj__id 
LEFT JOIN isys_connection AS j13 ON j13.isys_connection__id = j14.isys_cats_person_list__isys_connection__id 
LEFT JOIN isys_obj AS job13 ON j13.isys_connection__isys_obj__id = job13.isys_obj__id 
LEFT JOIN isys_obj_type AS j16 ON j16.isys_obj_type__id = obj_main.isys_obj__isys_obj_type__id 

WHERE TRUE 
 AND  ( (j16.isys_obj_type__id != '60' ) AND (j16.isys_obj_type__id != '63' ) ) AND ( (j1.isys_cmdb_status__id != '10' ) AND obj_main.isys_obj__status = '2' ) AND ( (j16.isys_obj_type__id = '54' ) ) AND ( obj_main.isys_obj__title LIKE '%sentinel%' )
 ORDER BY j1.isys_cmdb_status__title ASC