WP_Site_Query::parse_orderby( string $orderby ): string|false

Source

protected function parse_orderby( $orderby ) {	global $wpdb;	$parsed = false;	switch ( $orderby ) {	case 'site__in':	$site__in = implode( ',', array_map( 'absint', $this->query_vars['site__in'] ) );	$parsed = "FIELD( {$wpdb->blogs}.blog_id, $site__in )";	break;	case 'network__in':	$network__in = implode( ',', array_map( 'absint', $this->query_vars['network__in'] ) );	$parsed = "FIELD( {$wpdb->blogs}.site_id, $network__in )";	break;	case 'domain':	case 'last_updated':	case 'path':	case 'registered':	case 'deleted':	case 'spam':	case 'mature':	case 'archived':	case 'public':	$parsed = $orderby;	break;	case 'network_id':	$parsed = 'site_id';	break;	case 'domain_length':	$parsed = 'CHAR_LENGTH(domain)';	break;	case 'path_length':	$parsed = 'CHAR_LENGTH(path)';	break;	case 'id':	$parsed = "{$wpdb->blogs}.blog_id";	break;	}	if ( ! empty( $parsed ) || empty( $this->meta_query_clauses ) ) {	return $parsed;	}	$meta_clauses = $this->meta_query->get_clauses();	if ( empty( $meta_clauses ) ) {	return $parsed;	}	$primary_meta_query = reset( $meta_clauses );	if ( ! empty( $primary_meta_query['key'] ) && $primary_meta_query['key'] === $orderby ) {	$orderby = 'meta_value';	}	switch ( $orderby ) {	case 'meta_value':	if ( ! empty( $primary_meta_query['type'] ) ) {	$parsed = "CAST({$primary_meta_query['alias']}.meta_value AS {$primary_meta_query['cast']})";	} else {	$parsed = "{$primary_meta_query['alias']}.meta_value";	}	break;	case 'meta_value_num':	$parsed = "{$primary_meta_query['alias']}.meta_value+0";	break;	default:	if ( isset( $meta_clauses[ $orderby ] ) ) {	$meta_clause = $meta_clauses[ $orderby ];	$parsed = "CAST({$meta_clause['alias']}.meta_value AS {$meta_clause['cast']})";	}	}	return $parsed; } 

View all references View on Trac View on GitHub