WP_User_Search::prepare_query()

531	public function prepare_query() {532		global $wpdb;533		$this->first_user = ($this->page - 1) * $this->users_per_page;534 535		$this->query_limit = $wpdb->prepare(" LIMIT %d, %d", $this->first_user, $this->users_per_page);536		$this->query_orderby = ' ORDER BY user_login';537 538		$search_sql = '';539		if ( $this->search_term ) {540			$searches = array();541			$search_sql = 'AND (';542			foreach ( array('user_login', 'user_nicename', 'user_email', 'user_url', 'display_name') as $col )543				$searches[] = $wpdb->prepare( $col . ' LIKE %s', '%' . like_escape($this->search_term) . '%' );544			$search_sql .= implode(' OR ', $searches);545			$search_sql .= ')';546		}547 548		$this->query_from = " FROM $wpdb->users";549		$this->query_where = " WHERE 1=1 $search_sql";550 551		if ( $this->role ) {552			$this->query_from .= " INNER JOIN $wpdb->usermeta ON $wpdb->users.ID = $wpdb->usermeta.user_id";553			$this->query_where .= $wpdb->prepare(" AND $wpdb->usermeta.meta_key = '{$wpdb->prefix}capabilities' AND $wpdb->usermeta.meta_value LIKE %s", '%' . $this->role . '%');554		} elseif ( is_multisite() ) {555			$level_key = $wpdb->prefix . 'capabilities'; // WPMU site admins don't have user_levels.556			$this->query_from .= ", $wpdb->usermeta";557			$this->query_where .= " AND $wpdb->users.ID = $wpdb->usermeta.user_id AND meta_key = '{$level_key}'";558		}559 560		do_action_ref_array( 'pre_user_search', array( &$this ) );561	}