SELECT 
obj_main.isys_obj__id AS '__id__', 
obj_main.isys_obj__title AS 'LC__UNIVERSAL__TITLE###0_1', 
j3.isys_catg_certificate_list__description AS 'LC__CMDB__CATG__DESCRIPTION###0_111', 
j3.isys_catg_certificate_list__created AS 'locales::fmt_date::LC__CMDB__CATG__CERTIFICATE__CREATE_DATE###0_111', 
j3.isys_catg_certificate_list__expire AS 'locales::fmt_date::LC__CMDB__CATG__CERTIFICATE__EXPIRE_DATE###0_111', 
j3.isys_catg_certificate_list__common_name AS 'LC__CMDB__CATG__CERTIFICATE__COMMON_NAME###0_111', 
j2.isys_certificate_type__title AS 'LC__CMDB__CATG__TYPE###0_111' 

 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_certificate_list AS j3 ON j3.isys_catg_certificate_list__isys_obj__id = obj_main.isys_obj__id  
LEFT JOIN isys_certificate_type AS j2 ON j2.isys_certificate_type__id = j3.isys_catg_certificate_list__isys_certificate_type__id 
LEFT JOIN isys_obj_type AS j5 ON j5.isys_obj_type__id = obj_main.isys_obj__isys_obj_type__id 

WHERE TRUE 
 AND  ( (j5.isys_obj_type__id != '60' ) AND (j5.isys_obj_type__id != '63' ) ) AND ( (j3.isys_catg_certificate_list__expire PLACEHOLDER.2 'greater-than-current-date-time 57600' ) )
 ORDER BY obj_main.isys_obj__title ASC