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', 
job2.isys_obj__title AS 'LC__CMDB__CATG__APPLICATION_OBJ_APPLICATION###0_12', 
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__created_by AS 'LC__UNIVERSAL__CREATED_BY###0_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 (SELECT * FROM isys_catg_application_list
            INNER JOIN isys_connection ON isys_connection__id = isys_catg_application_list__isys_connection__id
            AND (
                isys_catg_application_list__isys_catg_application_priority__id IS NULL OR
                isys_catg_application_list__isys_catg_application_priority__id = 2
            ) ) AS j3 ON
                                    j3.isys_catg_application_list__isys_obj__id = obj_main.isys_obj__id 
LEFT JOIN isys_obj AS job2 ON j3.isys_connection__isys_obj__id = job2.isys_obj__id 
LEFT JOIN isys_catg_global_list AS j5 ON j5.isys_catg_global_list__isys_obj__id = obj_main.isys_obj__id  
LEFT JOIN isys_obj_type AS j7 ON j7.isys_obj_type__id = obj_main.isys_obj__isys_obj_type__id 

WHERE TRUE 
 AND  ( (j7.isys_obj_type__id != '60' ) AND (j7.isys_obj_type__id != '63' ) ) AND ( (j7.isys_obj_type__id = '33' ) ) AND ( (j1.isys_cmdb_status__id = '6' ) ) AND ( obj_main.isys_obj__status = '2' ) AND ( (job2.isys_obj__id IS NULL) )
 ORDER BY j1.isys_cmdb_status__title DESC