SELECT 
obj_main.isys_obj__id AS '__id__', 
obj_main.isys_obj__title AS 'LC__UNIVERSAL__TITLE###0_1', 
j1.isys_cmdb_status__title AS 'LC__UNIVERSAL__CMDB_STATUS###0_1', 
j5.isys_contact_tag__title AS 'LC__CMDB__CONTACT_ROLE###0_21', 
job2.isys_obj__title AS 'LC__UNIVERSAL__TITLE#LC__CMDB__CATG__GLOBAL_CONTACT###catg_1', 
j7.isys_cmdb_status__title AS 'LC__UNIVERSAL__CMDB_STATUS#LC__CMDB__CATG__GLOBAL_CONTACT###catg_1', 
j13.isys_cats_organization_list__title AS 'LC__CMDB__LOGBOOK__TITLE#LC__CONTACT__PERSON_ASSIGNED_ORGANISATION#LC__CMDB__CATG__GLOBAL_CONTACT###cats_46' 

 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_contact_list AS j3 ON j3.isys_catg_contact_list__isys_obj__id = obj_main.isys_obj__id  
LEFT JOIN isys_connection AS j2 ON j2.isys_connection__id = j3.isys_catg_contact_list__isys_connection__id 
LEFT JOIN isys_obj AS job2 ON j2.isys_connection__isys_obj__id = job2.isys_obj__id 
LEFT JOIN isys_contact_tag AS j5 ON j5.isys_contact_tag__id = j3.isys_catg_contact_list__isys_contact_tag__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_cmdb_status AS j7 ON j7.isys_cmdb_status__id = job2.isys_obj__isys_cmdb_status__id 
LEFT JOIN isys_cats_person_list AS j10 ON j10.isys_cats_person_list__isys_obj__id = job2.isys_obj__id  
LEFT JOIN isys_connection AS j9 ON j9.isys_connection__id = j10.isys_cats_person_list__isys_connection__id 
LEFT JOIN isys_obj AS job9 ON j9.isys_connection__isys_obj__id = job9.isys_obj__id 
LEFT JOIN isys_cats_organization_list AS j13 ON j13.isys_cats_organization_list__isys_obj__id = job9.isys_obj__id  
LEFT JOIN isys_obj AS j14 ON j14.isys_obj__id = j13.isys_cats_organization_list__isys_obj__id 

WHERE TRUE 
 AND  ( (j5.isys_contact_tag__id = '24' ) ) AND ( (j1.isys_cmdb_status__id = '6' ) AND obj_main.isys_obj__status = '2' )
 ORDER BY obj_main.isys_obj__title ASC