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', 
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', 
j4.isys_catg_accounting_list__isys_contact__id AS 'isys_cmdb_dao_category_g_accounting::dynamic_property_callback_contact::isys_catg_accounting_list__isys_contact__id::LC__CMDB__CATG__GLOBAL_PURCHASED_AT' 

 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_catg_global_list AS j2 ON j2.isys_catg_global_list__isys_obj__id = obj_main.isys_obj__id  
LEFT JOIN isys_catg_accounting_list AS j4 ON j4.isys_catg_accounting_list__isys_obj__id = obj_main.isys_obj__id  
LEFT JOIN isys_obj_type AS j6 ON j6.isys_obj_type__id = obj_main.isys_obj__isys_obj_type__id 
LEFT JOIN isys_contact AS j10 ON j10.isys_contact__id = j4.isys_catg_accounting_list__isys_contact__id 
LEFT JOIN isys_contact_2_isys_obj AS j11 ON j10.isys_contact__id = j11.isys_contact_2_isys_obj__isys_contact__id 
LEFT JOIN isys_obj AS job12 ON job12.isys_obj__id = j11.isys_contact_2_isys_obj__isys_obj__id 

WHERE TRUE 
 AND  ( (j6.isys_obj_type__id != '60' ) AND (j6.isys_obj_type__id != '63' ) ) AND ( (j1.isys_cmdb_status__id != '10' ) AND obj_main.isys_obj__status = '2' ) AND ( (j6.isys_obj_type__id = '33' ) ) AND ( (job12.isys_obj__id = ''  OR job12.isys_obj__id IS NULL) )
 ORDER BY obj_main.isys_obj__title ASC