bp_member_type_post_by_type( $member_type )

function bp_member_type_post_by_type($member_type) {
	global $wpdb;

	$query = "SELECT post_id FROM {$wpdb->postmeta} WHERE meta_key = '%s' AND LOWER(meta_value) = '%s'";
	$query = $wpdb->prepare( $query, '_bp_member_type_key', $member_type );
	$post_id = $wpdb->get_var( $query );

	// Fallback to legacy way to retrieve profile type from name by using singular label
	if ( ! $post_id ) {
		$name = str_replace( array( '-', '-' ), array( ' ', ',' ), $member_type );
		$query = "SELECT post_id FROM {$wpdb->postmeta} WHERE meta_key = '%s' AND LOWER(meta_value) = '%s'";
		$query = $wpdb->prepare( $query, '_bp_member_type_label_singular_name', $name );
		$post_id = $wpdb->get_var( $query );
	}

	return apply_filters( 'bp_member_type_post_by_type', $post_id );
}