SELECT 
obj_main.isys_obj__id AS '__id__', 
obj_main.isys_obj__title AS 'LC__UNIVERSAL__TITLE###0_1', 
j2.isys_catg_model_list__serial AS 'LC__CMDB__CATG__SERIAL###0_2', 
j4.isys_client_type__title AS 'LC__CMDB__CATS__CLIENT_TYPE###1_15', 
j1.isys_cmdb_status__title AS 'LC__UNIVERSAL__CMDB_STATUS###0_1', 
job7.isys_obj__title AS 'LC__CMDB__CATG__GLOBAL_CONTACT###0_21', 
j10.isys_contact_tag__title AS 'LC__CMDB__CONTACT_ROLE###0_21', 
j11.isys_catg_accounting_list__delivery_date AS 'locales::fmt_date::LC__CMDB__CATG__ACCOUNTING_DELIVERY_DATE###0_38', 
j11.isys_catg_accounting_list__guarantee_date AS 'locales::fmt_date::LC__CMDB__CATG__ACCOUNTING_GUARANTEE_PERIOD_DATE###0_38', 
j11.isys_catg_accounting_list__id AS 'isys_cmdb_dao_category_g_accounting::dynamic_property_callback_guarantee_status::isys_catg_accounting_list__id::LC__CMDB__CATG__GLOBAL_GUARANTEE_STATUS', 
j13.isys_catg_location_list__parentid AS 'isys_cmdb_dao_category_g_location::dynamic_property_callback_location_path::isys_catg_location_list__parentid::LC__CMDB__CATG__LOCATION_PATH' 

 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 j8 ON j8.isys_catg_contact_list__isys_obj__id = obj_main.isys_obj__id  
LEFT JOIN isys_connection AS j7 ON j7.isys_connection__id = j8.isys_catg_contact_list__isys_connection__id 
LEFT JOIN isys_obj AS job7 ON j7.isys_connection__isys_obj__id = job7.isys_obj__id 
LEFT JOIN isys_contact_tag AS j10 ON j10.isys_contact_tag__id = j8.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_catg_model_list AS j2 ON j2.isys_catg_model_list__isys_obj__id = obj_main.isys_obj__id  
LEFT JOIN isys_cats_client_list AS j5 ON j5.isys_cats_client_list__isys_obj__id = obj_main.isys_obj__id  
LEFT JOIN isys_client_type AS j4 ON j4.isys_client_type__id = j5.isys_cats_client_list__isys_client_type__id 
LEFT JOIN isys_catg_accounting_list AS j11 ON j11.isys_catg_accounting_list__isys_obj__id = obj_main.isys_obj__id  
LEFT JOIN isys_catg_location_list AS j13 ON j13.isys_catg_location_list__isys_obj__id = obj_main.isys_obj__id  
LEFT JOIN isys_obj_type AS j15 ON j15.isys_obj_type__id = obj_main.isys_obj__isys_obj_type__id 

WHERE TRUE 
 AND  ( (j15.isys_obj_type__id != '60' ) AND (j15.isys_obj_type__id != '63' ) ) AND ( (j15.isys_obj_type__id = '10' ) AND (j11.isys_catg_accounting_list__delivery_date PLACEHOLDER.2 'older-then-date-time 2102400' ) ) AND ( (j1.isys_cmdb_status__id != '10' ) AND obj_main.isys_obj__status = '2' )
 ORDER BY obj_main.isys_obj__title DESC