SELECT isys_catg_contact_list.*, o1.*, isys_connection.* FROM isys_catg_contact_list INNER JOIN isys_connection ON isys_connection__id = isys_catg_contact_list.isys_catg_contact_list__isys_connection__id LEFT JOIN isys_contact_tag ON isys_contact_tag__id = isys_catg_contact_list.isys_catg_contact_list__isys_contact_tag__id LEFT JOIN isys_obj AS o1 ON isys_catg_contact_list.isys_catg_contact_list__isys_obj__id = o1.isys_obj__id INNER JOIN isys_obj AS o2 ON o2.isys_obj__id = isys_connection__isys_obj__id WHERE TRUE   AND isys_catg_contact_list.isys_catg_contact_list__id = 450 AND (isys_connection__isys_obj__id = 1774) ;