SELECT 
obj_main.isys_obj__id AS '__id__', 
j2.isys_obj_type__title AS 'LC__REPORT__FORM__OBJECT_TYPE###0_1', 
j1.isys_cmdb_status__title AS 'LC__UNIVERSAL__CMDB_STATUS###0_1', 
obj_main.isys_obj__title AS 'LC__UNIVERSAL__TITLE###0_1', 
j3.isys_catg_model_list__serial AS 'LC__CMDB__CATG__SERIAL###0_2', 
(CASE obj_main.isys_obj__status WHEN '3' THEN 'LC__CMDB__RECORD_STATUS__ARCHIVED' WHEN '1' THEN 'LC__CMDB__RECORD_STATUS__BIRTH' WHEN '4' THEN 'LC__CMDB__RECORD_STATUS__DELETED' WHEN '2' THEN 'LC__CMDB__RECORD_STATUS__NORMAL' WHEN '6' THEN 'LC__CMDB_STATUS__IDOIT_STATUS_TEMPLATE' WHEN '7' THEN 'LC__MASS_CHANGE__CHANGE_TEMPLATE' END)  AS 'LC__UNIVERSAL__CONDITION###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', 
j6.isys_obj__title AS 'LC__CMDB__CATG__LOCATION###0_26' 

 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_obj_type AS j2 ON j2.isys_obj_type__id = obj_main.isys_obj__isys_obj_type__id 
LEFT JOIN isys_catg_model_list AS j3 ON j3.isys_catg_model_list__isys_obj__id = obj_main.isys_obj__id  
LEFT JOIN isys_catg_location_list AS j5 ON obj_main.isys_obj__id = j5.isys_catg_location_list__isys_obj__id 
LEFT JOIN isys_obj AS j6 ON j5.isys_catg_location_list__parentid = j6.isys_obj__id 
LEFT JOIN isys_catg_global_list AS j7 ON j7.isys_catg_global_list__isys_obj__id = obj_main.isys_obj__id  

WHERE TRUE 
 AND  ( (j2.isys_obj_type__id != '60' ) AND (j2.isys_obj_type__id != '63' ) ) AND ( (j1.isys_cmdb_status__id = '11' ) ) AND ( obj_main.isys_obj__status = '2' )
 ORDER BY j2.isys_obj_type__title ASC