FM / wp-includes

/home/altere25/sportzsoftlivemeet.com/wp-includes/

/home/altere25/sportzsoftlivemeet.com/wp-includes

Name	Size	Mode	Actions
abilities-api/	-	0755	rm
ai-client/	-	0755	rm
assets/	-	0755	rm
block-bindings/	-	0755	rm
block-patterns/	-	0755	rm
block-supports/	-	0755	rm
blocks/	-	0755	rm
build/	-	0755	rm
certificates/	-	0755	rm
collaboration/	-	0755	rm
css/	-	0755	rm
customize/	-	0755	rm
fonts/	-	0755	rm
html-api/	-	0755	rm
ID3/	-	0755	rm
images/	-	0755	rm
interactivity-api/	-	0755	rm
IXR/	-	0755	rm
js/	-	0755	rm
l10n/	-	0755	rm
php-ai-client/	-	0755	rm
php-compat/	-	0755	rm
PHPMailer/	-	0755	rm
pomo/	-	0755	rm
Requests/	-	0755	rm
rest-api/	-	0755	rm
SimplePie/	-	0755	rm
sitemaps/	-	0755	rm
sodium_compat/	-	0755	rm
style-engine/	-	0755	rm
Text/	-	0755	rm
theme-compat/	-	0755	rm
widgets/	-	0755	rm
.htaccess	178	0644	edit dl rm
abilities-api.php	24369	0644	edit dl rm
abilities.php	7983	0644	edit dl rm
admin-bar.php	37100	0644	edit dl rm
ai-client.php	2549	0644	edit dl rm
atomlib.php	11950	0644	edit dl rm
author-template.php	18951	0644	edit dl rm
block-bindings.php	5594	0644	edit dl rm
block-editor.php	28166	0644	edit dl rm
block-i18n.json	316	0644	edit dl rm
block-patterns.php	13162	0644	edit dl rm
block-template-utils.php	56559	0644	edit dl rm
block-template.php	12376	0644	edit dl rm
blocks.php	97472	0644	edit dl rm
bookmark-template.php	12934	0644	edit dl rm
bookmark.php	15427	0644	edit dl rm
cache-compat.php	5969	0644	edit dl rm
cache.php	13474	0644	edit dl rm
canonical.php	34496	0644	edit dl rm
capabilities.php	40016	0644	edit dl rm
category-template.php	57003	0644	edit dl rm
category.php	12709	0644	edit dl rm
class-avif-info.php	29615	0644	edit dl rm
class-feed.php	529	0644	edit dl rm
class-http.php	367	0644	edit dl rm
class-IXR.php	2543	0644	edit dl rm
class-json.php	43684	0644	edit dl rm
class-oembed.php	401	0644	edit dl rm
class-phpass.php	6708	0644	edit dl rm
class-phpmailer.php	664	0644	edit dl rm
class-pop3.php	20969	0644	edit dl rm
class-requests.php	2237	0644	edit dl rm
class-simplepie.php	98061	0644	edit dl rm
class-smtp.php	457	0644	edit dl rm
class-snoopy.php	37715	0644	edit dl rm
class-walker-category-dropdown.php	2469	0644	edit dl rm
class-walker-category.php	8477	0644	edit dl rm
class-walker-comment.php	14221	0644	edit dl rm
class-walker-nav-menu.php	11313	0644	edit dl rm
class-walker-page-dropdown.php	2710	0644	edit dl rm
class-walker-page.php	7612	0644	edit dl rm
class-wp-admin-bar.php	17874	0644	edit dl rm
class-wp-ajax-response.php	5266	0644	edit dl rm
class-wp-application-passwords.php	12854	0644	edit dl rm
class-wp-block-bindings-registry.php	8944	0644	edit dl rm
class-wp-block-bindings-source.php	2178	0644	edit dl rm
class-wp-block-editor-context.php	1350	0644	edit dl rm
class-wp-block-list.php	4757	0644	edit dl rm
class-wp-block-metadata-registry.php	8355	0644	edit dl rm
class-wp-block-parser-block.php	2555	0644	edit dl rm
class-wp-block-parser-frame.php	1916	0644	edit dl rm
class-wp-block-parser.php	11532	0644	edit dl rm
class-wp-block-pattern-categories-registry.php	5371	0644	edit dl rm
class-wp-block-patterns-registry.php	12140	0644	edit dl rm
class-wp-block-processor.php	69469	0644	edit dl rm
class-wp-block-styles-registry.php	6262	0644	edit dl rm
class-wp-block-supports.php	5566	0644	edit dl rm
class-wp-block-template.php	1951	0644	edit dl rm
class-wp-block-templates-registry.php	7227	0644	edit dl rm
class-wp-block-type-registry.php	5013	0644	edit dl rm
class-wp-block-type.php	17265	0644	edit dl rm
class-wp-block.php	19691	0644	edit dl rm
class-wp-classic-to-block-menu-converter.php	4088	0644	edit dl rm
class-wp-comment-query.php	48395	0644	edit dl rm
class-wp-comment.php	9372	0644	edit dl rm
class-wp-connector-registry.php	14409	0644	edit dl rm
class-wp-customize-control.php	25730	0644	edit dl rm
class-wp-customize-manager.php	202413	0644	edit dl rm
class-wp-customize-nav-menus.php	57632	0644	edit dl rm
class-wp-customize-panel.php	10670	0644	edit dl rm
class-wp-customize-section.php	11244	0644	edit dl rm
class-wp-customize-setting.php	29889	0644	edit dl rm
class-wp-customize-widgets.php	71520	0644	edit dl rm
class-wp-date-query.php	35726	0644	edit dl rm
class-wp-dependencies.php	14062	0644	edit dl rm
class-wp-dependency.php	2627	0644	edit dl rm
class-wp-duotone.php	40783	0644	edit dl rm
class-wp-editor.php	72177	0644	edit dl rm
class-wp-embed.php	15994	0644	edit dl rm
class-wp-error.php	7502	0644	edit dl rm
class-wp-exception.php	253	0644	edit dl rm
class-wp-fatal-error-handler.php	7948	0644	edit dl rm
class-wp-feed-cache-transient.php	2586	0644	edit dl rm
class-wp-feed-cache.php	969	0644	edit dl rm
class-wp-hook.php	16000	0644	edit dl rm
class-wp-http-cookie.php	7389	0644	edit dl rm
class-wp-http-curl.php	12541	0644	edit dl rm
class-wp-http-encoding.php	6689	0644	edit dl rm
class-wp-http-ixr-client.php	3506	0644	edit dl rm
class-wp-http-proxy.php	5980	0644	edit dl rm
class-wp-http-requests-hooks.php	2022	0644	edit dl rm
class-wp-http-requests-response.php	4400	0644	edit dl rm
class-wp-http-response.php	2977	0644	edit dl rm
class-wp-http-streams.php	16859	0644	edit dl rm
class-wp-http.php	40760	0644	edit dl rm
class-wp-icons-registry.php	7857	0644	edit dl rm
class-wp-image-editor-gd.php	18943	0644	edit dl rm
class-wp-image-editor-imagick.php	38542	0644	edit dl rm
class-wp-image-editor.php	17606	0644	edit dl rm
class-wp-list-util.php	7443	0644	edit dl rm
class-wp-locale-switcher.php	6630	0644	edit dl rm
class-wp-locale.php	16111	0644	edit dl rm
class-wp-matchesmapregex.php	1828	0644	edit dl rm
class-wp-meta-query.php	30531	0644	edit dl rm
class-wp-metadata-lazyloader.php	6833	0644	edit dl rm
class-wp-navigation-fallback.php	9211	0644	edit dl rm
class-wp-network-query.php	19857	0644	edit dl rm
class-wp-network.php	12288	0644	edit dl rm
class-wp-object-cache.php	17605	0644	edit dl rm
class-wp-oembed-controller.php	6905	0644	edit dl rm
class-wp-oembed.php	31475	0644	edit dl rm
class-wp-paused-extensions-storage.php	5090	0644	edit dl rm
class-wp-phpmailer.php	4348	0644	edit dl rm
class-wp-plugin-dependencies.php	25319	0644	edit dl rm
class-wp-post-type.php	30350	0644	edit dl rm
class-wp-post.php	6484	0644	edit dl rm
class-wp-query.php	154081	0644	edit dl rm
class-wp-recovery-mode-cookie-service.php	6877	0644	edit dl rm
class-wp-recovery-mode-email-service.php	11183	0644	edit dl rm
class-wp-recovery-mode-key-service.php	4601	0644	edit dl rm
class-wp-recovery-mode-link-service.php	3463	0644	edit dl rm
class-wp-recovery-mode.php	11435	0644	edit dl rm
class-wp-rewrite.php	63430	0644	edit dl rm
class-wp-role.php	2523	0644	edit dl rm
class-wp-roles.php	8580	0644	edit dl rm
class-wp-script-modules.php	13755	0644	edit dl rm
class-wp-scripts.php	27906	0644	edit dl rm
class-wp-session-tokens.php	7451	0644	edit dl rm
class-wp-simplepie-file.php	3377	0644	edit dl rm
class-wp-simplepie-sanitize-kses.php	1770	0644	edit dl rm
class-wp-site-query.php	31545	0644	edit dl rm
class-wp-site.php	7454	0644	edit dl rm
class-wp-speculation-rules.php	7527	0644	edit dl rm
class-wp-styles.php	10898	0644	edit dl rm
class-wp-tax-query.php	19555	0644	edit dl rm
class-wp-taxonomy.php	18567	0644	edit dl rm
class-wp-term-query.php	41166	0644	edit dl rm
class-wp-term.php	5298	0644	edit dl rm
class-wp-text-diff-renderer-inline.php	979	0644	edit dl rm
class-wp-text-diff-renderer-table.php	18807	0644	edit dl rm
class-wp-textdomain-registry.php	10203	0644	edit dl rm
class-wp-theme-json-data.php	1809	0644	edit dl rm
class-wp-theme-json-resolver.php	34714	0644	edit dl rm
class-wp-theme-json-schema.php	7367	0644	edit dl rm
class-wp-theme-json.php	157322	0644	edit dl rm
class-wp-theme.php	65299	0644	edit dl rm
class-wp-token-map.php	28430	0644	edit dl rm
class-wp-url-pattern-prefixer.php	4802	0644	edit dl rm
class-wp-user-meta-session-tokens.php	2990	0644	edit dl rm
class-wp-user-query.php	43654	0644	edit dl rm
class-wp-user-request.php	2222	0644	edit dl rm
class-wp-user.php	22827	0644	edit dl rm
class-wp-walker.php	13322	0644	edit dl rm
class-wp-widget-factory.php	3347	0644	edit dl rm
class-wp-widget.php	18386	0644	edit dl rm
class-wp-xmlrpc-server.php	214948	0644	edit dl rm
class-wp.php	26119	0644	edit dl rm
class-wpdb.php	118379	0644	edit dl rm
class.wp-dependencies.php	373	0644	edit dl rm
class.wp-scripts.php	343	0644	edit dl rm
class.wp-styles.php	338	0644	edit dl rm
collaboration.php	2158	0644	edit dl rm
comment-template.php	101738	0644	edit dl rm
comment.php	129226	0644	edit dl rm
compat-utf8.php	19554	0644	edit dl rm
compat.php	16467	0644	edit dl rm
connectors.php	24080	0644	edit dl rm
cron.php	41582	0644	edit dl rm
date.php	400	0644	edit dl rm
default-constants.php	11238	0644	edit dl rm
default-filters.php	35490	0644	edit dl rm
default-widgets.php	2222	0644	edit dl rm
deprecated.php	186291	0644	edit dl rm
embed-template.php	338	0644	edit dl rm
embed.php	37908	0644	edit dl rm
error-protection.php	4121	0644	edit dl rm
feed-atom-comments.php	5504	0644	edit dl rm
feed-atom.php	3048	0644	edit dl rm
feed-rdf.php	2668	0644	edit dl rm
feed-rss.php	1189	0644	edit dl rm
feed-rss2-comments.php	4136	0644	edit dl rm
feed-rss2.php	3799	0644	edit dl rm
feed.php	23317	0644	edit dl rm
fonts.php	9441	0644	edit dl rm
formatting.php	335374	0644	edit dl rm
functions.php	280644	0644	edit dl rm
functions.wp-scripts.php	14558	0644	edit dl rm
functions.wp-styles.php	8583	0644	edit dl rm
general-template.php	169119	0644	edit dl rm
global-styles-and-settings.php	21424	0644	edit dl rm
http.php	27320	0644	edit dl rm
https-detection.php	5661	0644	edit dl rm
https-migration.php	4741	0644	edit dl rm
kses.php	74561	0644	edit dl rm
l10n.php	66655	0644	edit dl rm
link-template.php	156140	0644	edit dl rm
load.php	55353	0644	edit dl rm
locale.php	162	0644	edit dl rm
media-template.php	62218	0644	edit dl rm
media.php	210603	0644	edit dl rm
meta.php	64078	0644	edit dl rm
ms-blogs.php	25728	0644	edit dl rm
ms-default-constants.php	4921	0644	edit dl rm
ms-default-filters.php	6636	0644	edit dl rm
ms-deprecated.php	21759	0644	edit dl rm
ms-files.php	2711	0644	edit dl rm
ms-functions.php	91243	0644	edit dl rm
ms-load.php	19883	0644	edit dl rm
ms-network.php	3782	0644	edit dl rm
ms-settings.php	4124	0644	edit dl rm
ms-site.php	40346	0644	edit dl rm
nav-menu-template.php	25917	0644	edit dl rm
nav-menu.php	44119	0644	edit dl rm
option.php	100442	0644	edit dl rm
pluggable-deprecated.php	6263	0644	edit dl rm
pluggable.php	113181	0644	edit dl rm
plugin.php	35465	0644	edit dl rm
post-formats.php	7102	0644	edit dl rm
post-template.php	66814	0644	edit dl rm
post-thumbnail-template.php	10308	0644	edit dl rm
post.php	284273	0644	edit dl rm
query.php	37035	0644	edit dl rm
registration-functions.php	200	0644	edit dl rm
registration.php	200	0644	edit dl rm
rest-api.php	98466	0644	edit dl rm
revision.php	30906	0644	edit dl rm
rewrite.php	19514	0644	edit dl rm
robots-template.php	5185	0644	edit dl rm
rss-functions.php	255	0644	edit dl rm
rss.php	23107	0644	edit dl rm
script-loader.php	130296	0644	edit dl rm
script-modules.php	5978	0644	edit dl rm
session.php	258	0644	edit dl rm
shortcodes.php	24051	0644	edit dl rm
sitemaps.php	3238	0644	edit dl rm
speculative-loading.php	8600	0644	edit dl rm
spl-autoload-compat.php	441	0644	edit dl rm
style-engine.php	7563	0644	edit dl rm
taxonomy.php	175314	0644	edit dl rm
template-canvas.php	544	0644	edit dl rm
template-loader.php	3350	0644	edit dl rm
template.php	24154	0644	edit dl rm
theme-i18n.json	1245	0644	edit dl rm
theme-previews.php	2832	0644	edit dl rm
theme-templates.php	6223	0644	edit dl rm
theme.json	8704	0644	edit dl rm
theme.php	133979	0644	edit dl rm
update.php	36884	0644	edit dl rm
user.php	174383	0644	edit dl rm
utf8.php	7260	0644	edit dl rm
vars.php	6489	0644	edit dl rm
version.php	931	0644	edit dl rm
view-transitions.php	602	0644	edit dl rm
widgets.php	70682	0644	edit dl rm
wp-db.php	445	0644	edit dl rm
wp-diff.php	647	0644	edit dl rm

Edit: /home/altere25/sportzsoftlivemeet.com/wp-includes/class-wp-user-query.php (43654B)

<?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( 'results', 'total_users' );

// 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->prepare_query( $query );
			$this->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(
			'blog_id'             => get_current_blog_id(),
			'role'                => '',
			'role__in'            => array(),
			'role__not_in'        => array(),
			'capability'          => '',
			'capability__in'      => array(),
			'capability__not_in'  => array(),
			'meta_key'            => '',
			'meta_value'          => '',
			'meta_compare'        => '',
			'include'             => array(),
			'exclude'             => array(),
			'search'              => '',
			'search_columns'      => array(),
			'orderby'             => 'login',
			'order'               => 'ASC',
			'offset'              => '',
			'number'              => '',
			'paged'               => 1,
			'count_total'         => true,
			'fields'              => 'all',
			'who'                 => '',
			'has_published_posts' => null,
			'nicename'            => '',
			'nicename__in'        => array(),
			'nicename__not_in'    => array(),
			'login'               => '',
			'login__in'           => array(),
			'login__not_in'       => array(),
			'cache_results'       => 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 'meta_value_num' support for `$orderby` parameter. Added multi-dimensional array syntax
	 *              for `$orderby` parameter.
	 * @since 4.3.0 Added 'has_published_posts' parameter.
	 * @since 4.4.0 Added 'paged', 'role__in', and 'role__not_in' parameters. The 'role' parameter was updated to
	 *              permit an array or comma-separated list of values. The 'number' parameter was updated to support
	 *              querying for all users with using -1.
	 * @since 4.7.0 Added 'nicename', 'nicename__in', 'nicename__not_in', 'login', 'login__in',
	 *              and 'login__not_in' parameters.
	 * @since 5.1.0 Introduced the 'meta_compare_key' parameter.
	 * @since 5.3.0 Introduced the 'meta_type_key' parameter.
	 * @since 5.9.0 Added 'capability', 'capability__in', and 'capability__not_in' parameters.
	 *              Deprecated the 'who' parameter.
	 * @since 6.3.0 Added 'cache_results' 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 'map_meta_cap'}. 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 'map_meta_cap'}. 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 'map_meta_cap'}. 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 'ID', 'user_login',
	 *                                                'user_email', 'user_url', 'user_nicename', 'display_name'.
	 *                                                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 ('ASC' or 'DESC') as values. Accepted values are:
	 *                                                - 'ID'
	 *                                                - 'display_name' (or 'name')
	 *                                                - 'include'
	 *                                                - 'user_login' (or 'login')
	 *                                                - 'login__in'
	 *                                                - 'user_nicename' (or 'nicename')
	 *                                                - 'nicename__in'
	 *                                                - 'user_email (or 'email')
	 *                                                - 'user_url' (or 'url')
	 *                                                - 'user_registered' (or 'registered')
	 *                                                - 'post_count'
	 *                                                - 'meta_value'
	 *                                                - 'meta_value_num'
	 *                                                - The value of `$meta_key`
	 *                                                - An array key of `$meta_query`
	 *                                                To use 'meta_value' or 'meta_value_num', `$meta_key`
	 *                                                must be also be defined. Default 'user_login'.
	 *     @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 'ASC', 'DESC'. Default 'ASC'.
	 *     @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:
	 *                                                - 'ID'
	 *                                                - 'display_name'
	 *                                                - 'user_login'
	 *                                                - 'user_nicename'
	 *                                                - 'user_email'
	 *                                                - 'user_url'
	 *                                                - 'user_registered'
	 *                                                - 'user_pass'
	 *                                                - 'user_activation_key'
	 *                                                - 'user_status'
	 *                                                - 'spam' (only available on multisite installs)
	 *                                                - 'deleted' (only available on multisite installs)
	 *                                                - 'all' for all fields and loads user meta.
	 *                                                - 'all_with_meta' Deprecated. Use 'all'.
	 *                                                Default 'all'.
	 *     @type string          $who                 Deprecated, use `$capability` instead.
	 *                                                Type of users to query. Accepts 'authors'.
	 *                                                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->query_vars ) || ! empty( $query ) ) {
			$this->query_limit = null;
			$this->query_vars  = $this->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( 'pre_get_users', array( &$this ) );

// Ensure that query vars are filled after 'pre_get_users'.
		$qv =& $this->query_vars;
		$qv = $this->fill_query_vars( $qv );

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

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

if ( empty( $qv['fields'] ) ) {
				$qv['fields'] = array( 'id' );
			}

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

if ( isset( $qv['count_total'] ) && $qv['count_total'] ) {
			$this->query_fields = 'SQL_CALC_FOUND_ROWS ' . $this->query_fields;
		}

$this->query_from  = "FROM $wpdb->users";
		$this->query_where = 'WHERE 1=1';

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

$blog_id = 0;
		if ( isset( $qv['blog_id'] ) ) {
			$blog_id = absint( $qv['blog_id'] );
		}

if ( $qv['has_published_posts'] && $blog_id ) {
			if ( true === $qv['has_published_posts'] ) {
				$post_types = get_post_types( array( 'public' => true ) );
			} else {
				$post_types = (array) $qv['has_published_posts'];
			}

foreach ( $post_types as &$post_type ) {
				$post_type = $wpdb->prepare( '%s', $post_type );
			}

$posts_table        = $wpdb->get_blog_prefix( $blog_id ) . 'posts';
			$this->query_where .= " AND $wpdb->users.ID IN ( SELECT DISTINCT $posts_table.post_author FROM $posts_table WHERE $posts_table.post_status = 'publish' AND $posts_table.post_type IN ( " . implode( ', ', $post_types ) . ' ) )';
		}

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

if ( ! empty( $qv['nicename__in'] ) ) {
			$sanitized_nicename__in = array_map( 'esc_sql', $qv['nicename__in'] );
			$nicename__in           = implode( "','", $sanitized_nicename__in );
			$this->query_where     .= " AND user_nicename IN ( '$nicename__in' )";
		}

if ( ! empty( $qv['nicename__not_in'] ) ) {
			$sanitized_nicename__not_in = array_map( 'esc_sql', $qv['nicename__not_in'] );
			$nicename__not_in           = implode( "','", $sanitized_nicename__not_in );
			$this->query_where         .= " AND user_nicename NOT IN ( '$nicename__not_in' )";
		}

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

if ( ! empty( $qv['login__in'] ) ) {
			$sanitized_login__in = array_map( 'esc_sql', $qv['login__in'] );
			$login__in           = implode( "','", $sanitized_login__in );
			$this->query_where  .= " AND user_login IN ( '$login__in' )";
		}

if ( ! empty( $qv['login__not_in'] ) ) {
			$sanitized_login__not_in = array_map( 'esc_sql', $qv['login__not_in'] );
			$login__not_in           = implode( "','", $sanitized_login__not_in );
			$this->query_where      .= " AND user_login NOT IN ( '$login__not_in' )";
		}

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

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

$who_query = array(
				'key'     => $wpdb->get_blog_prefix( $blog_id ) . 'user_level',
				'value'   => 0,
				'compare' => '!=',
			);

// Prevent extra meta query.
			$qv['blog_id'] = 0;
			$blog_id       = 0;

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

$this->meta_query->parse_query_vars( $this->meta_query->queries );
		}

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

$role__in = array();
		if ( isset( $qv['role__in'] ) ) {
			$role__in = (array) $qv['role__in'];
		}

$role__not_in = array();
		if ( isset( $qv['role__not_in'] ) ) {
			$role__not_in = (array) $qv['role__not_in'];
		}

// Capabilities.
		$available_roles = array();

if ( ! empty( $qv['capability'] ) || ! empty( $qv['capability__in'] ) || ! empty( $qv['capability__not_in'] ) ) {
			$wp_roles->for_site( $blog_id );
			$available_roles = $wp_roles->roles;
		}

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

$capability__in = array();
		if ( ! empty( $qv['capability__in'] ) ) {
			$capability__in = (array) $qv['capability__in'];
		}

$capability__not_in = array();
		if ( ! empty( $qv['capability__not_in'] ) ) {
			$capability__not_in = (array) $qv['capability__not_in'];
		}

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

foreach ( $available_roles as $role => $role_data ) {
			$role_caps = array_keys( array_filter( $role_data['capabilities'] ) );

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 && ! empty( $capabilities ) ) {
			$capabilities_clauses = array( 'relation' => 'AND' );

foreach ( $capabilities as $cap ) {
				$clause = array( 'relation' => 'OR' );

$clause[] = array(
					'key'     => $wpdb->get_blog_prefix( $blog_id ) . 'capabilities',
					'value'   => '"' . $cap . '"',
					'compare' => 'LIKE',
				);

if ( ! empty( $caps_with_roles[ $cap ] ) ) {
					foreach ( $caps_with_roles[ $cap ] as $role ) {
						$clause[] = array(
							'key'     => $wpdb->get_blog_prefix( $blog_id ) . 'capabilities',
							'value'   => '"' . $role . '"',
							'compare' => 'LIKE',
						);
					}
				}

$capabilities_clauses[] = $clause;
			}

$role_queries[] = $capabilities_clauses;

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

$this->meta_query->parse_query_vars( $this->meta_query->queries );
		}

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

$roles_clauses = array( 'relation' => 'AND' );
			if ( ! empty( $roles ) ) {
				foreach ( $roles as $role ) {
					$roles_clauses[] = array(
						'key'     => $wpdb->get_blog_prefix( $blog_id ) . 'capabilities',
						'value'   => '"' . $role . '"',
						'compare' => 'LIKE',
					);
				}

$role_queries[] = $roles_clauses;
			}

$role__in_clauses = array( 'relation' => 'OR' );
			if ( ! empty( $role__in ) ) {
				foreach ( $role__in as $role ) {
					$role__in_clauses[] = array(
						'key'     => $wpdb->get_blog_prefix( $blog_id ) . 'capabilities',
						'value'   => '"' . $role . '"',
						'compare' => 'LIKE',
					);
				}

$role_queries[] = $role__in_clauses;
			}

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

$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(
					'key'     => $wpdb->get_blog_prefix( $blog_id ) . 'capabilities',
					'compare' => 'EXISTS',
				);
			}

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

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

$this->meta_query->parse_query_vars( $this->meta_query->queries );
		}

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

if ( $this->meta_query->has_or_relation() ) {
				$this->query_fields = 'DISTINCT ' . $this->query_fields;
			}
		}

// Sorting.
		$qv['order'] = isset( $qv['order'] ) ? strtoupper( $qv['order'] ) : '';
		$order       = $this->parse_order( $qv['order'] );

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

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

if ( is_int( $_key ) ) {
				// Integer key means this is a flat array of 'orderby' 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->parse_orderby( $_orderby );

if ( ! $parsed ) {
				continue;
			}

if ( 'nicename__in' === $_orderby || 'login__in' === $_orderby ) {
				$orderby_array[] = $parsed;
			} else {
				$orderby_array[] = $parsed . ' ' . $this->parse_order( $_order );
			}
		}

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

$this->query_orderby = 'ORDER BY ' . implode( ', ', $orderby_array );

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

$search = '';
		if ( isset( $qv['search'] ) ) {
			$search = trim( $qv['search'] );
		}

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

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

/**
			 * Filters the columns to search in a WP_User_Query search.
			 *
			 * The default columns depend on the search term, and include 'ID', 'user_login',
			 * 'user_email', 'user_url', 'user_nicename', and 'display_name'.
			 *
			 * @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( 'user_search_columns', $search_columns, $search, $this );

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

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

// Date queries are allowed for the user_registered field.
		if ( ! empty( $qv['date_query'] ) && is_array( $qv['date_query'] ) ) {
			$date_query         = new WP_Date_Query( $qv['date_query'], 'user_registered' );
			$this->query_where .= $date_query->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( 'pre_user_query', array( &$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( 'plugins_loaded' ) ) {
			_doing_it_wrong(
				'WP_User_Query::query',
				sprintf(
				/* translators: %s: plugins_loaded */
					__( 'User queries should not be run before the %s hook.' ),
					'<code>plugins_loaded</code>'
				),
				'6.1.1'
			);
		}

$qv =& $this->query_vars;

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

/**
		 * Filters the users array before the query takes place.
		 *
		 * Return a non-null value to bypass WordPress' 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'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->results = apply_filters_ref_array( 'users_pre_query', array( null, &$this ) );

if ( null === $this->results ) {
			// Beginning of the string is on a new line to prevent leading whitespace. See https://core.trac.wordpress.org/ticket/56841.
			$this->request =
				"SELECT {$this->query_fields}
				 {$this->query_from}
				 {$this->query_where}
				 {$this->query_orderby}
				 {$this->query_limit}";
			$cache_value   = false;
			$cache_key     = $this->generate_cache_key( $qv, $this->request );
			$cache_group   = 'user-queries';
			if ( $qv['cache_results'] ) {
				$cache_value = wp_cache_get( $cache_key, $cache_group );
			}
			if ( false !== $cache_value ) {
				$this->results     = $cache_value['user_data'];
				$this->total_users = $cache_value['total_users'];
			} else {

if ( is_array( $qv['fields'] ) ) {
					$this->results = $wpdb->get_results( $this->request );
				} else {
					$this->results = $wpdb->get_col( $this->request );
				}

if ( isset( $qv['count_total'] ) && $qv['count_total'] ) {
					/**
					 * Filters SELECT FOUND_ROWS() query for the current WP_User_Query instance.
					 *
					 * @since 3.2.0
					 * @since 5.1.0 Added the `$this` 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( 'found_users_query', 'SELECT FOUND_ROWS()', $this );

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

if ( $qv['cache_results'] ) {
					$cache_value = array(
						'user_data'   => $this->results,
						'total_users' => $this->total_users,
					);
					wp_cache_add( $cache_key, $cache_value, $cache_group );
				}
			}
		}

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

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

$this->results = $r;
		}
	}

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

return 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->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  = ( 'leading' === $wild || 'both' === $wild ) ? '%' : '';
		$trailing_wild = ( 'trailing' === $wild || 'both' === $wild ) ? '%' : '';
		$like          = $leading_wild . $wpdb->esc_like( $search ) . $trailing_wild;

foreach ( $columns as $column ) {
			if ( 'ID' === $column ) {
				$searches[] = $wpdb->prepare( "$column = %s", $search );
			} else {
				$searches[] = $wpdb->prepare( "$column LIKE %s", $like );
			}
		}

return ' AND (' . implode( ' OR ', $searches ) . ')';
	}

/**
	 * Returns the list of users.
	 *
	 * @since 3.1.0
	 *
	 * @return array Array of results.
	 */
	public function get_results() {
		return $this->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->total_users;
	}

/**
	 * Parses and sanitizes 'orderby' 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->meta_query->get_clauses();

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

return $_orderby;
	}

/**
	 * Generate cache key.
	 *
	 * @since 6.3.0
	 *
	 * @global wpdb $wpdb WordPress database abstraction object.
	 *
	 * @param array  $args Query arguments.
	 * @param string $sql  SQL statement.
	 * @return string Cache key.
	 */
	protected function generate_cache_key( array $args, $sql ) {
		global $wpdb;

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

$key          = md5( $sql );
		$last_changed = wp_cache_get_last_changed( 'users' );

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

$blog_id = 0;
		if ( isset( $args['blog_id'] ) ) {
			$blog_id = absint( $args['blog_id'] );
		}

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

$last_changed .= wp_cache_get_last_changed( 'posts' );

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

return "get_users:$key:$last_changed";
	}

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

if ( 'ASC' === strtoupper( $order ) ) {
			return 'ASC';
		} else {
			return 'DESC';
		}
	}

/**
	 * 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->compat_fields, true ) ) {
			return $this->$name;
		}

wp_trigger_error(
			__METHOD__,
			"The property `{$name}` is not declared. Getting a dynamic property is " .
			'deprecated since version 6.4.0! Instead, declare the property on the class.',
			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->compat_fields, true ) ) {
			$this->$name = $value;
			return;
		}

wp_trigger_error(
			__METHOD__,
			"The property `{$name}` is not declared. Setting a dynamic property is " .
			'deprecated since version 6.4.0! Instead, declare the property on the class.',
			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->compat_fields, true ) ) {
			return isset( $this->$name );
		}

wp_trigger_error(
			__METHOD__,
			"The property `{$name}` is not declared. Checking `isset()` on a dynamic property " .
			'is deprecated since version 6.4.0! Instead, declare the property on the class.',
			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->compat_fields, true ) ) {
			unset( $this->$name );
			return;
		}

wp_trigger_error(
			__METHOD__,
			"A property `{$name}` is not declared. Unsetting a dynamic property is " .
			'deprecated since version 6.4.0! Instead, declare the property on the class.',
			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 ( 'get_search_sql' === $name ) {
			return $this->get_search_sql( ...$arguments );
		}
		return false;
	}
}

cmd: