SELECT 
obj_main.isys_obj__id AS '__id__', 
obj_main.isys_obj__title AS 'LC__UNIVERSAL__TITLE###0_1', 
j6.isys_catg_address_list__street AS 'LC__CONTACT__ORGANISATION_STREET###0_134', 
j6.isys_catg_address_list__house_no AS 'LC__CATG__ADDRESS__HOUSE_NO###0_134', 
j6.isys_catg_address_list__postalcode AS 'LC__CONTACT__ORGANISATION_POSTAL_CODE###0_134', 
j6.isys_catg_address_list__city AS 'LC__CONTACT__ORGANISATION_CITY###0_134', 
j2.isys_catg_mail_addresses_list__title AS 'LC__CONTACT__PERSON_MAIL_ADDRESS###0_104', 
j4.isys_cats_organization_list__website AS 'LC__CONTACT__ORGANISATION_WEBSITE###1_46', 
obj_main.isys_obj__id AS 'ID###0_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_mail_addresses_list AS j2 ON j2.isys_catg_mail_addresses_list__isys_obj__id = obj_main.isys_obj__id  
LEFT JOIN isys_cats_organization_list AS j4 ON j4.isys_cats_organization_list__isys_obj__id = obj_main.isys_obj__id  
LEFT JOIN isys_catg_address_list AS j6 ON j6.isys_catg_address_list__isys_obj__id = obj_main.isys_obj__id  
LEFT JOIN isys_obj_type AS j8 ON j8.isys_obj_type__id = obj_main.isys_obj__isys_obj_type__id 

WHERE TRUE 
 AND  ( (j8.isys_obj_type__id != '60' ) AND (j8.isys_obj_type__id != '63' ) ) AND (  (obj_main.isys_obj__id  IN  ((SELECT tobj.isys_obj__id
                                FROM isys_tag_2_isys_obj AS tobj
                                INNER JOIN isys_tag AS tag ON tag.isys_tag__id = tobj.isys_tag__id  WHERE tag.isys_tag__id = '105'   ) ))  )
 ORDER BY obj_main.isys_obj__title ASC