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', 
j12.isys_obj__title AS 'LC__UNIVERSAL__TITLE#LC__UNIVERSAL__INSTALLED_ON###catg_1', 
j16.isys_cats_person_list__department AS 'LC__CONTACT__PERSON_DEPARTMENT#LC__UNIVERSAL__INSTALLED_ON###cats_49', 
job15.isys_obj__title AS 'LC__UNIVERSAL__TITLE#LC__CONTACT__PERSON_ASSIGNED_ORGANISATION#LC__UNIVERSAL__INSTALLED_ON###catg_1', 
j17.isys_cats_lic_list__key AS 'LC__CMDB__CATS__LICENCE_KEY#LC__CMDB__CATG__LIC_ASSIGN__LICENSE###cats_26', 
j17.isys_cats_lic_list__description AS 'LC__CMDB__LOGBOOK__DESCRIPTION#LC__CMDB__CATG__LIC_ASSIGN__LICENSE###cats_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 
INNER JOIN isys_cmdb_status AS j1 ON j1.isys_cmdb_status__id = obj_main.isys_obj__isys_cmdb_status__id 
INNER JOIN (SELECT * FROM isys_catg_application_list INNER JOIN isys_connection ON isys_connection__id = isys_catg_application_list__isys_connection__id) AS j4 ON j4.isys_connection__isys_obj__id = obj_main.isys_obj__id 
INNER JOIN isys_obj AS j7 ON j4.isys_catg_application_list__isys_obj__id = j7.isys_obj__id 
INNER JOIN isys_cats_lic_list AS j8 ON j4.isys_catg_application_list__isys_cats_lic_list__id = j8.isys_cats_lic_list__id 
INNER JOIN isys_obj AS j11 ON j8.isys_cats_lic_list__isys_obj__id = j11.isys_obj__id 
INNER JOIN isys_obj AS j12 ON j12.isys_obj__id = j4.isys_catg_application_list__isys_obj__id 
INNER JOIN isys_cats_person_list AS j16 ON j16.isys_cats_person_list__isys_obj__id = j4.isys_catg_application_list__isys_obj__id  
INNER JOIN isys_obj AS j14 ON j14.isys_obj__id = j16.isys_cats_person_list__isys_obj__id 
INNER JOIN isys_connection AS j15 ON j15.isys_connection__id = j16.isys_cats_person_list__isys_connection__id 
INNER JOIN isys_obj AS job15 ON j15.isys_connection__isys_obj__id = job15.isys_obj__id 
INNER JOIN isys_cats_lic_list AS j17 ON j17.isys_cats_lic_list__isys_obj__id = j11.isys_obj__id  
INNER JOIN isys_obj AS j18 ON j18.isys_obj__id = j17.isys_cats_lic_list__isys_obj__id 
INNER JOIN isys_obj_type AS j20 ON j20.isys_obj_type__id = obj_main.isys_obj__isys_obj_type__id 

WHERE TRUE 
 AND  ( (j20.isys_obj_type__id != '60' ) AND (j20.isys_obj_type__id != '63' ) ) AND ( (j20.isys_obj_type__id = '2' ) ) AND ( (j1.isys_cmdb_status__id != '10' ) AND obj_main.isys_obj__status = '2' ) AND ( obj_main.isys_obj__title LIKE '%copilot%' )
 ORDER BY obj_main.isys_obj__title DESC