"select ".TABLE_PREFIX.DB_USERTABLE.".".DB_USERTABLE_USERID." userid, ".TABLE_PREFIX.DB_USERTABLE.".".DB_USERTABLE_NAME." username, ".TABLE_PREFIX.DB_USERTABLE.".".DB_USERTABLE_NAME." link, ".DB_AVATARFIELD." avatar,substring_index(substring_index(wp_usermeta.meta_value ,'"',-2),'"',1) role from  ".TABLE_PREFIX.DB_USERTABLE."left join wp_usermeta on ".TABLE_PREFIX.DB_USERTABLE.".".DB_USERTABLE_USERID."= wp_usermeta.user_id  left join cometchat_status on ".TABLE_PREFIX.DB_USERTABLE.".".DB_USERTABLE_USERID." = cometchat_status.userid ".DB_AVATARTABLE." where (select count(*) from wp_bp_friends where (initiator_user_id='".$userid."' and friend_user_id=wp_users.ID) or (initiator_user_id=wp_users.ID and friend_user_id='".$userid."'))=1 and wp_usermeta.meta_key = 'wp_capabilities' order by username asc"