SELECT 
obj_main.isys_obj__id AS '__id__', 
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', 
j2.isys_cats_person_list__first_name AS 'LC__CONTACT__PERSON_FIRST_NAME###1_49', 
j2.isys_cats_person_list__last_name AS 'LC__CONTACT__PERSON_LAST_NAME###1_49' 

 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_cats_person_list AS j2 ON j2.isys_cats_person_list__isys_obj__id = obj_main.isys_obj__id  
LEFT JOIN isys_catg_global_list AS j4 ON j4.isys_catg_global_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 

WHERE TRUE 
 AND  ( (j6.isys_obj_type__id != '60' ) AND (j6.isys_obj_type__id != '63' ) ) AND ( (j6.isys_obj_type__id = '53' ) ) AND (  obj_main.isys_obj__created > '2025-10-27 00:00:00'  ) AND (  obj_main.isys_obj__created < '2025-10-29 00:00:00'  ) AND ( (obj_main.isys_obj__created_by = 'admin' ) )
 ORDER BY obj_main.isys_obj__created DESC