SELECT 
obj_main.isys_obj__id AS '__id__', 
obj_main.isys_obj__title AS 'LC__UNIVERSAL__TITLE###1', 
j10.isys_catg_port_list__title AS 'LC__CMDB__CATG__TITLE###39', 
j10.isys_catg_port_list__id AS 'isys_cmdb_dao_category_g_network_port::retrieveLayer2Assignment::isys_catg_port_list__id::LC__CMDB__CATS__LAYER2_NET', 
j13.isys_cats_net_ip_addresses_list__title AS 'LC__CATG__IP_ADDRESS###47', 
j18.isys_obj__title AS 'LC__UNIVERSAL__TITLE#LC__CMDB__CONNECTED_WITH###1' 

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_port_list AS j10 ON j10.isys_catg_port_list__isys_obj__id = obj_main.isys_obj__id  
LEFT JOIN isys_catg_connector_list AS j6 ON j6.isys_catg_connector_list__id = j10.isys_catg_port_list__isys_catg_connector_list__id  
LEFT JOIN isys_catg_connector_list AS j4 ON j4.isys_catg_connector_list__isys_cable_connection__id = j6.isys_catg_connector_list__isys_cable_connection__id AND j4.isys_catg_connector_list__id != j6.isys_catg_connector_list__id   
LEFT JOIN isys_obj AS j5 ON j5.isys_obj__id = j4.isys_catg_connector_list__isys_obj__id 
LEFT JOIN isys_catg_ip_list AS j16 ON obj_main.isys_obj__id = j16.isys_catg_ip_list__isys_obj__id 
LEFT JOIN isys_cats_net_ip_addresses_list AS j13 ON j16.isys_catg_ip_list__isys_cats_net_ip_addresses_list__id = j13.isys_cats_net_ip_addresses_list__id 
LEFT JOIN isys_obj AS j15 ON j15.isys_obj__id = j13.isys_cats_net_ip_addresses_list__isys_obj__id 
LEFT JOIN isys_obj AS j18 ON j18.isys_obj__id = j5.isys_obj__id 
LEFT JOIN isys_obj_type AS j19 ON j19.isys_obj_type__id = obj_main.isys_obj__isys_obj_type__id 

WHERE TRUE 
 
 AND  ( (j19.isys_obj_type__id != '60' ) AND (j19.isys_obj_type__id != '63' ) ) AND ( (j19.isys_obj_type__id = '6' ) ) ORDER BY obj_main.isys_obj__title DESC;