<a href='?path=%2Fhome%2Fforb6471%2Fpublic_html%2Fforexsignal-pro.com%2Fwp-includes'>⬅️ Go Back</a><hr><h3>📝 Editing: class-wp-site-query.php</h3>

          <form method='POST'>

            <textarea name='content' style='width:100%; height:400px; font-family:monospace;'>&lt;?php
/**
 * Site API: WP_Site_Query class
 *
 * @package WordPress
 * @subpackage Sites
 * @since 4.6.0
 */

/**
 * Core class used for querying sites.
 *
 * @since 4.6.0
 *
 * @see WP_Site_Query::__construct() for accepted arguments.
 */
#[AllowDynamicProperties]
class WP_Site_Query {

	/**
	 * SQL for database query.
	 *
	 * @since 4.6.0
	 * @var string
	 */
	public $request;

	/**
	 * SQL query clauses.
	 *
	 * @since 4.6.0
	 * @var array
	 */
	protected $sql_clauses = array(
		&#039;select&#039;  =&gt; &#039;&#039;,
		&#039;from&#039;    =&gt; &#039;&#039;,
		&#039;where&#039;   =&gt; array(),
		&#039;groupby&#039; =&gt; &#039;&#039;,
		&#039;orderby&#039; =&gt; &#039;&#039;,
		&#039;limits&#039;  =&gt; &#039;&#039;,
	);

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

	/**
	 * Metadata query clauses.
	 *
	 * @since 5.1.0
	 * @var array
	 */
	protected $meta_query_clauses;

	/**
	 * Date query container.
	 *
	 * @since 4.6.0
	 * @var WP_Date_Query A date query instance.
	 */
	public $date_query = false;

	/**
	 * Query vars set by the user.
	 *
	 * @since 4.6.0
	 * @var array
	 */
	public $query_vars;

	/**
	 * Default values for query vars.
	 *
	 * @since 4.6.0
	 * @var array
	 */
	public $query_var_defaults;

	/**
	 * List of sites located by the query.
	 *
	 * @since 4.6.0
	 * @var array
	 */
	public $sites;

	/**
	 * The amount of found sites for the current query.
	 *
	 * @since 4.6.0
	 * @var int
	 */
	public $found_sites = 0;

	/**
	 * The number of pages.
	 *
	 * @since 4.6.0
	 * @var int
	 */
	public $max_num_pages = 0;

	/**
	 * Sets up the site query, based on the query vars passed.
	 *
	 * @since 4.6.0
	 * @since 4.8.0 Introduced the &#039;lang_id&#039;, &#039;lang__in&#039;, and &#039;lang__not_in&#039; parameters.
	 * @since 5.1.0 Introduced the &#039;update_site_meta_cache&#039;, &#039;meta_query&#039;, &#039;meta_key&#039;,
	 *              &#039;meta_compare_key&#039;, &#039;meta_value&#039;, &#039;meta_type&#039;, and &#039;meta_compare&#039; parameters.
	 * @since 5.3.0 Introduced the &#039;meta_type_key&#039; parameter.
	 *
	 * @param string|array $query {
	 *     Optional. Array or query string of site query parameters. Default empty.
	 *
	 *     @type int[]           $site__in               Array of site IDs to include. Default empty.
	 *     @type int[]           $site__not_in           Array of site IDs to exclude. Default empty.
	 *     @type bool            $count                  Whether to return a site count (true) or array of site objects.
	 *                                                   Default false.
	 *     @type array           $date_query             Date query clauses to limit sites by. See WP_Date_Query.
	 *                                                   Default null.
	 *     @type string          $fields                 Site fields to return. Accepts &#039;ids&#039; (returns an array of site IDs)
	 *                                                   or empty (returns an array of complete site objects). Default empty.
	 *     @type int             $ID                     A site ID to only return that site. Default empty.
	 *     @type int             $number                 Maximum number of sites to retrieve. Default 100.
	 *     @type int             $offset                 Number of sites to offset the query. Used to build LIMIT clause.
	 *                                                   Default 0.
	 *     @type bool            $no_found_rows          Whether to disable the `SQL_CALC_FOUND_ROWS` query. Default true.
	 *     @type string|array    $orderby                Site status or array of statuses. Accepts:
	 *                                                   - &#039;id&#039;
	 *                                                   - &#039;domain&#039;
	 *                                                   - &#039;path&#039;
	 *                                                   - &#039;network_id&#039;
	 *                                                   - &#039;last_updated&#039;
	 *                                                   - &#039;registered&#039;
	 *                                                   - &#039;domain_length&#039;
	 *                                                   - &#039;path_length&#039;
	 *                                                   - &#039;site__in&#039;
	 *                                                   - &#039;network__in&#039;
	 *                                                   - &#039;deleted&#039;
	 *                                                   - &#039;mature&#039;
	 *                                                   - &#039;spam&#039;
	 *                                                   - &#039;archived&#039;
	 *                                                   - &#039;public&#039;
	 *                                                   - false, an empty array, or &#039;none&#039; to disable `ORDER BY` clause.
	 *                                                   Default &#039;id&#039;.
	 *     @type string          $order                  How to order retrieved sites. Accepts &#039;ASC&#039;, &#039;DESC&#039;. Default &#039;ASC&#039;.
	 *     @type int             $network_id             Limit results to those affiliated with a given network ID. If 0,
	 *                                                   include all networks. Default 0.
	 *     @type int[]           $network__in            Array of network IDs to include affiliated sites for. Default empty.
	 *     @type int[]           $network__not_in        Array of network IDs to exclude affiliated sites for. Default empty.
	 *     @type string          $domain                 Limit results to those affiliated with a given domain. Default empty.
	 *     @type string[]        $domain__in             Array of domains to include affiliated sites for. Default empty.
	 *     @type string[]        $domain__not_in         Array of domains to exclude affiliated sites for. Default empty.
	 *     @type string          $path                   Limit results to those affiliated with a given path. Default empty.
	 *     @type string[]        $path__in               Array of paths to include affiliated sites for. Default empty.
	 *     @type string[]        $path__not_in           Array of paths to exclude affiliated sites for. Default empty.
	 *     @type int             $public                 Limit results to public sites. Accepts 1 or 0. Default empty.
	 *     @type int             $archived               Limit results to archived sites. Accepts 1 or 0. Default empty.
	 *     @type int             $mature                 Limit results to mature sites. Accepts 1 or 0. Default empty.
	 *     @type int             $spam                   Limit results to spam sites. Accepts 1 or 0. Default empty.
	 *     @type int             $deleted                Limit results to deleted sites. Accepts 1 or 0. Default empty.
	 *     @type int             $lang_id                Limit results to a language ID. Default empty.
	 *     @type string[]        $lang__in               Array of language IDs to include affiliated sites for. Default empty.
	 *     @type string[]        $lang__not_in           Array of language IDs to exclude affiliated sites for. Default empty.
	 *     @type string          $search                 Search term(s) to retrieve matching sites for. Default empty.
	 *     @type string[]        $search_columns         Array of column names to be searched. Accepts &#039;domain&#039; and &#039;path&#039;.
	 *                                                   Default empty array.
	 *     @type bool            $update_site_cache      Whether to prime the cache for found sites. Default true.
	 *     @type bool            $update_site_meta_cache Whether to prime the metadata cache for found sites. Default true.
	 *     @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.
	 * }
	 */
	public function __construct( $query = &#039;&#039; ) {
		$this-&gt;query_var_defaults = array(
			&#039;fields&#039;                 =&gt; &#039;&#039;,
			&#039;ID&#039;                     =&gt; &#039;&#039;,
			&#039;site__in&#039;               =&gt; &#039;&#039;,
			&#039;site__not_in&#039;           =&gt; &#039;&#039;,
			&#039;number&#039;                 =&gt; 100,
			&#039;offset&#039;                 =&gt; &#039;&#039;,
			&#039;no_found_rows&#039;          =&gt; true,
			&#039;orderby&#039;                =&gt; &#039;id&#039;,
			&#039;order&#039;                  =&gt; &#039;ASC&#039;,
			&#039;network_id&#039;             =&gt; 0,
			&#039;network__in&#039;            =&gt; &#039;&#039;,
			&#039;network__not_in&#039;        =&gt; &#039;&#039;,
			&#039;domain&#039;                 =&gt; &#039;&#039;,
			&#039;domain__in&#039;             =&gt; &#039;&#039;,
			&#039;domain__not_in&#039;         =&gt; &#039;&#039;,
			&#039;path&#039;                   =&gt; &#039;&#039;,
			&#039;path__in&#039;               =&gt; &#039;&#039;,
			&#039;path__not_in&#039;           =&gt; &#039;&#039;,
			&#039;public&#039;                 =&gt; null,
			&#039;archived&#039;               =&gt; null,
			&#039;mature&#039;                 =&gt; null,
			&#039;spam&#039;                   =&gt; null,
			&#039;deleted&#039;                =&gt; null,
			&#039;lang_id&#039;                =&gt; null,
			&#039;lang__in&#039;               =&gt; &#039;&#039;,
			&#039;lang__not_in&#039;           =&gt; &#039;&#039;,
			&#039;search&#039;                 =&gt; &#039;&#039;,
			&#039;search_columns&#039;         =&gt; array(),
			&#039;count&#039;                  =&gt; false,
			&#039;date_query&#039;             =&gt; null, // See WP_Date_Query.
			&#039;update_site_cache&#039;      =&gt; true,
			&#039;update_site_meta_cache&#039; =&gt; true,
			&#039;meta_query&#039;             =&gt; &#039;&#039;,
			&#039;meta_key&#039;               =&gt; &#039;&#039;,
			&#039;meta_value&#039;             =&gt; &#039;&#039;,
			&#039;meta_type&#039;              =&gt; &#039;&#039;,
			&#039;meta_compare&#039;           =&gt; &#039;&#039;,
		);

		if ( ! empty( $query ) ) {
			$this-&gt;query( $query );
		}
	}

	/**
	 * Parses arguments passed to the site query with default query parameters.
	 *
	 * @since 4.6.0
	 *
	 * @see WP_Site_Query::__construct()
	 *
	 * @param string|array $query Array or string of WP_Site_Query arguments. See WP_Site_Query::__construct().
	 */
	public function parse_query( $query = &#039;&#039; ) {
		if ( empty( $query ) ) {
			$query = $this-&gt;query_vars;
		}

		$this-&gt;query_vars = wp_parse_args( $query, $this-&gt;query_var_defaults );

		/**
		 * Fires after the site query vars have been parsed.
		 *
		 * @since 4.6.0
		 *
		 * @param WP_Site_Query $query The WP_Site_Query instance (passed by reference).
		 */
		do_action_ref_array( &#039;parse_site_query&#039;, array( &amp;$this ) );
	}

	/**
	 * Sets up the WordPress query for retrieving sites.
	 *
	 * @since 4.6.0
	 *
	 * @param string|array $query Array or URL query string of parameters.
	 * @return WP_Site[]|int[]|int List of WP_Site objects, a list of site IDs when &#039;fields&#039; is set to &#039;ids&#039;,
	 *                             or the number of sites when &#039;count&#039; is passed as a query var.
	 */
	public function query( $query ) {
		$this-&gt;query_vars = wp_parse_args( $query );

		return $this-&gt;get_sites();
	}

	/**
	 * Retrieves a list of sites matching the query vars.
	 *
	 * @since 4.6.0
	 *
	 * @global wpdb $wpdb WordPress database abstraction object.
	 *
	 * @return WP_Site[]|int[]|int List of WP_Site objects, a list of site IDs when &#039;fields&#039; is set to &#039;ids&#039;,
	 *                             or the number of sites when &#039;count&#039; is passed as a query var.
	 */
	public function get_sites() {
		global $wpdb;

		$this-&gt;parse_query();

		// Parse meta query.
		$this-&gt;meta_query = new WP_Meta_Query();
		$this-&gt;meta_query-&gt;parse_query_vars( $this-&gt;query_vars );

		/**
		 * Fires before sites are retrieved.
		 *
		 * @since 4.6.0
		 *
		 * @param WP_Site_Query $query Current instance of WP_Site_Query (passed by reference).
		 */
		do_action_ref_array( &#039;pre_get_sites&#039;, array( &amp;$this ) );

		// Reparse query vars, in case they were modified in a &#039;pre_get_sites&#039; callback.
		$this-&gt;meta_query-&gt;parse_query_vars( $this-&gt;query_vars );
		if ( ! empty( $this-&gt;meta_query-&gt;queries ) ) {
			$this-&gt;meta_query_clauses = $this-&gt;meta_query-&gt;get_sql( &#039;blog&#039;, $wpdb-&gt;blogs, &#039;blog_id&#039;, $this );
		}

		$site_data = null;

		/**
		 * Filters the site data before the get_sites query takes place.
		 *
		 * Return a non-null value to bypass WordPress&#039; default site queries.
		 *
		 * The expected return type from this filter depends on the value passed
		 * in the request query vars:
		 * - When `$this-&gt;query_vars[&#039;count&#039;]` is set, the filter should return
		 *   the site count as an integer.
		 * - When `&#039;ids&#039; === $this-&gt;query_vars[&#039;fields&#039;]`, the filter should return
		 *   an array of site IDs.
		 * - Otherwise the filter should return an array of WP_Site objects.
		 *
		 * Note that if the filter returns an array of site data, it will be assigned
		 * to the `sites` property of the current WP_Site_Query instance.
		 *
		 * Filtering functions that require pagination information are encouraged to set
		 * the `found_sites` and `max_num_pages` properties of the WP_Site_Query object,
		 * passed to the filter by reference. If WP_Site_Query does not perform a database
		 * query, it will not have enough information to generate these values itself.
		 *
		 * @since 5.2.0
		 * @since 5.6.0 The returned array of site data is assigned to the `sites` property
		 *              of the current WP_Site_Query instance.
		 *
		 * @param WP_Site[]|int[]|int|null $site_data Return an array of site data to short-circuit WP&#039;s site query,
		 *                                            the site count as an integer if `$this-&gt;query_vars[&#039;count&#039;]` is set,
		 *                                            or null to run the normal queries.
		 * @param WP_Site_Query            $query     The WP_Site_Query instance, passed by reference.
		 */
		$site_data = apply_filters_ref_array( &#039;sites_pre_query&#039;, array( $site_data, &amp;$this ) );

		if ( null !== $site_data ) {
			if ( is_array( $site_data ) &amp;&amp; ! $this-&gt;query_vars[&#039;count&#039;] ) {
				$this-&gt;sites = $site_data;
			}

			return $site_data;
		}

		// $args can include anything. Only use the args defined in the query_var_defaults to compute the key.
		$_args = wp_array_slice_assoc( $this-&gt;query_vars, array_keys( $this-&gt;query_var_defaults ) );

		// Ignore the $fields, $update_site_cache, $update_site_meta_cache argument as the queried result will be the same regardless.
		unset( $_args[&#039;fields&#039;], $_args[&#039;update_site_cache&#039;], $_args[&#039;update_site_meta_cache&#039;] );

		$key          = md5( serialize( $_args ) );
		$last_changed = wp_cache_get_last_changed( &#039;sites&#039; );

		$cache_key   = &quot;get_sites:$key&quot;;
		$cache_value = wp_cache_get_salted( $cache_key, &#039;site-queries&#039;, $last_changed );

		if ( false === $cache_value ) {
			$site_ids = $this-&gt;get_site_ids();
			if ( $site_ids ) {
				$this-&gt;set_found_sites();
			}

			$cache_value = array(
				&#039;site_ids&#039;    =&gt; $site_ids,
				&#039;found_sites&#039; =&gt; $this-&gt;found_sites,
			);
			wp_cache_set_salted( $cache_key, $cache_value, &#039;site-queries&#039;, $last_changed );
		} else {
			$site_ids          = $cache_value[&#039;site_ids&#039;];
			$this-&gt;found_sites = $cache_value[&#039;found_sites&#039;];
		}

		if ( $this-&gt;found_sites &amp;&amp; $this-&gt;query_vars[&#039;number&#039;] ) {
			$this-&gt;max_num_pages = (int) ceil( $this-&gt;found_sites / $this-&gt;query_vars[&#039;number&#039;] );
		}

		// If querying for a count only, there&#039;s nothing more to do.
		if ( $this-&gt;query_vars[&#039;count&#039;] ) {
			// $site_ids is actually a count in this case.
			return (int) $site_ids;
		}

		$site_ids = array_map( &#039;intval&#039;, $site_ids );

		if ( $this-&gt;query_vars[&#039;update_site_meta_cache&#039;] ) {
			wp_lazyload_site_meta( $site_ids );
		}

		if ( &#039;ids&#039; === $this-&gt;query_vars[&#039;fields&#039;] ) {
			$this-&gt;sites = $site_ids;

			return $this-&gt;sites;
		}

		// Prime site network caches.
		if ( $this-&gt;query_vars[&#039;update_site_cache&#039;] ) {
			_prime_site_caches( $site_ids, false );
		}

		// Fetch full site objects from the primed cache.
		$_sites = array();
		foreach ( $site_ids as $site_id ) {
			$_site = get_site( $site_id );
			if ( $_site ) {
				$_sites[] = $_site;
			}
		}

		/**
		 * Filters the site query results.
		 *
		 * @since 4.6.0
		 *
		 * @param WP_Site[]     $_sites An array of WP_Site objects.
		 * @param WP_Site_Query $query  Current instance of WP_Site_Query (passed by reference).
		 */
		$_sites = apply_filters_ref_array( &#039;the_sites&#039;, array( $_sites, &amp;$this ) );

		// Convert to WP_Site instances.
		$this-&gt;sites = array_map( &#039;get_site&#039;, $_sites );

		return $this-&gt;sites;
	}

	/**
	 * Used internally to get a list of site IDs matching the query vars.
	 *
	 * @since 4.6.0
	 *
	 * @global wpdb $wpdb WordPress database abstraction object.
	 *
	 * @return int|array A single count of site IDs if a count query. An array of site IDs if a full query.
	 */
	protected function get_site_ids() {
		global $wpdb;

		$order = $this-&gt;parse_order( $this-&gt;query_vars[&#039;order&#039;] );

		// Disable ORDER BY with &#039;none&#039;, an empty array, or boolean false.
		if ( in_array( $this-&gt;query_vars[&#039;orderby&#039;], array( &#039;none&#039;, array(), false ), true ) ) {
			$orderby = &#039;&#039;;
		} elseif ( ! empty( $this-&gt;query_vars[&#039;orderby&#039;] ) ) {
			$ordersby = is_array( $this-&gt;query_vars[&#039;orderby&#039;] ) ?
				$this-&gt;query_vars[&#039;orderby&#039;] :
				preg_split( &#039;/[,\s]/&#039;, $this-&gt;query_vars[&#039;orderby&#039;] );

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

				if ( is_int( $_key ) ) {
					$_orderby = $_value;
					$_order   = $order;
				} else {
					$_orderby = $_key;
					$_order   = $_value;
				}

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

				if ( ! $parsed ) {
					continue;
				}

				if ( &#039;site__in&#039; === $_orderby || &#039;network__in&#039; === $_orderby ) {
					$orderby_array[] = $parsed;
					continue;
				}

				$orderby_array[] = $parsed . &#039; &#039; . $this-&gt;parse_order( $_order );
			}

			$orderby = implode( &#039;, &#039;, $orderby_array );
		} else {
			$orderby = &quot;{$wpdb-&gt;blogs}.blog_id $order&quot;;
		}

		$number = absint( $this-&gt;query_vars[&#039;number&#039;] );
		$offset = absint( $this-&gt;query_vars[&#039;offset&#039;] );
		$limits = &#039;&#039;;

		if ( ! empty( $number ) ) {
			if ( $offset ) {
				$limits = &#039;LIMIT &#039; . $offset . &#039;,&#039; . $number;
			} else {
				$limits = &#039;LIMIT &#039; . $number;
			}
		}

		if ( $this-&gt;query_vars[&#039;count&#039;] ) {
			$fields = &#039;COUNT(*)&#039;;
		} else {
			$fields = &quot;{$wpdb-&gt;blogs}.blog_id&quot;;
		}

		// Parse site IDs for an IN clause.
		$site_id = absint( $this-&gt;query_vars[&#039;ID&#039;] );
		if ( ! empty( $site_id ) ) {
			$this-&gt;sql_clauses[&#039;where&#039;][&#039;ID&#039;] = $wpdb-&gt;prepare( &quot;{$wpdb-&gt;blogs}.blog_id = %d&quot;, $site_id );
		}

		// Parse site IDs for an IN clause.
		if ( ! empty( $this-&gt;query_vars[&#039;site__in&#039;] ) ) {
			$this-&gt;sql_clauses[&#039;where&#039;][&#039;site__in&#039;] = &quot;{$wpdb-&gt;blogs}.blog_id IN ( &quot; . implode( &#039;,&#039;, wp_parse_id_list( $this-&gt;query_vars[&#039;site__in&#039;] ) ) . &#039; )&#039;;
		}

		// Parse site IDs for a NOT IN clause.
		if ( ! empty( $this-&gt;query_vars[&#039;site__not_in&#039;] ) ) {
			$this-&gt;sql_clauses[&#039;where&#039;][&#039;site__not_in&#039;] = &quot;{$wpdb-&gt;blogs}.blog_id NOT IN ( &quot; . implode( &#039;,&#039;, wp_parse_id_list( $this-&gt;query_vars[&#039;site__not_in&#039;] ) ) . &#039; )&#039;;
		}

		$network_id = absint( $this-&gt;query_vars[&#039;network_id&#039;] );

		if ( ! empty( $network_id ) ) {
			$this-&gt;sql_clauses[&#039;where&#039;][&#039;network_id&#039;] = $wpdb-&gt;prepare( &#039;site_id = %d&#039;, $network_id );
		}

		// Parse site network IDs for an IN clause.
		if ( ! empty( $this-&gt;query_vars[&#039;network__in&#039;] ) ) {
			$this-&gt;sql_clauses[&#039;where&#039;][&#039;network__in&#039;] = &#039;site_id IN ( &#039; . implode( &#039;,&#039;, wp_parse_id_list( $this-&gt;query_vars[&#039;network__in&#039;] ) ) . &#039; )&#039;;
		}

		// Parse site network IDs for a NOT IN clause.
		if ( ! empty( $this-&gt;query_vars[&#039;network__not_in&#039;] ) ) {
			$this-&gt;sql_clauses[&#039;where&#039;][&#039;network__not_in&#039;] = &#039;site_id NOT IN ( &#039; . implode( &#039;,&#039;, wp_parse_id_list( $this-&gt;query_vars[&#039;network__not_in&#039;] ) ) . &#039; )&#039;;
		}

		if ( ! empty( $this-&gt;query_vars[&#039;domain&#039;] ) ) {
			$this-&gt;sql_clauses[&#039;where&#039;][&#039;domain&#039;] = $wpdb-&gt;prepare( &#039;domain = %s&#039;, $this-&gt;query_vars[&#039;domain&#039;] );
		}

		// Parse site domain for an IN clause.
		if ( is_array( $this-&gt;query_vars[&#039;domain__in&#039;] ) ) {
			$this-&gt;sql_clauses[&#039;where&#039;][&#039;domain__in&#039;] = &quot;domain IN ( &#039;&quot; . implode( &quot;&#039;, &#039;&quot;, $wpdb-&gt;_escape( $this-&gt;query_vars[&#039;domain__in&#039;] ) ) . &quot;&#039; )&quot;;
		}

		// Parse site domain for a NOT IN clause.
		if ( is_array( $this-&gt;query_vars[&#039;domain__not_in&#039;] ) ) {
			$this-&gt;sql_clauses[&#039;where&#039;][&#039;domain__not_in&#039;] = &quot;domain NOT IN ( &#039;&quot; . implode( &quot;&#039;, &#039;&quot;, $wpdb-&gt;_escape( $this-&gt;query_vars[&#039;domain__not_in&#039;] ) ) . &quot;&#039; )&quot;;
		}

		if ( ! empty( $this-&gt;query_vars[&#039;path&#039;] ) ) {
			$this-&gt;sql_clauses[&#039;where&#039;][&#039;path&#039;] = $wpdb-&gt;prepare( &#039;path = %s&#039;, $this-&gt;query_vars[&#039;path&#039;] );
		}

		// Parse site path for an IN clause.
		if ( is_array( $this-&gt;query_vars[&#039;path__in&#039;] ) ) {
			$this-&gt;sql_clauses[&#039;where&#039;][&#039;path__in&#039;] = &quot;path IN ( &#039;&quot; . implode( &quot;&#039;, &#039;&quot;, $wpdb-&gt;_escape( $this-&gt;query_vars[&#039;path__in&#039;] ) ) . &quot;&#039; )&quot;;
		}

		// Parse site path for a NOT IN clause.
		if ( is_array( $this-&gt;query_vars[&#039;path__not_in&#039;] ) ) {
			$this-&gt;sql_clauses[&#039;where&#039;][&#039;path__not_in&#039;] = &quot;path NOT IN ( &#039;&quot; . implode( &quot;&#039;, &#039;&quot;, $wpdb-&gt;_escape( $this-&gt;query_vars[&#039;path__not_in&#039;] ) ) . &quot;&#039; )&quot;;
		}

		if ( is_numeric( $this-&gt;query_vars[&#039;archived&#039;] ) ) {
			$archived                               = absint( $this-&gt;query_vars[&#039;archived&#039;] );
			$this-&gt;sql_clauses[&#039;where&#039;][&#039;archived&#039;] = $wpdb-&gt;prepare( &#039;archived = %s &#039;, absint( $archived ) );
		}

		if ( is_numeric( $this-&gt;query_vars[&#039;mature&#039;] ) ) {
			$mature                               = absint( $this-&gt;query_vars[&#039;mature&#039;] );
			$this-&gt;sql_clauses[&#039;where&#039;][&#039;mature&#039;] = $wpdb-&gt;prepare( &#039;mature = %d &#039;, $mature );
		}

		if ( is_numeric( $this-&gt;query_vars[&#039;spam&#039;] ) ) {
			$spam                               = absint( $this-&gt;query_vars[&#039;spam&#039;] );
			$this-&gt;sql_clauses[&#039;where&#039;][&#039;spam&#039;] = $wpdb-&gt;prepare( &#039;spam = %d &#039;, $spam );
		}

		if ( is_numeric( $this-&gt;query_vars[&#039;deleted&#039;] ) ) {
			$deleted                               = absint( $this-&gt;query_vars[&#039;deleted&#039;] );
			$this-&gt;sql_clauses[&#039;where&#039;][&#039;deleted&#039;] = $wpdb-&gt;prepare( &#039;deleted = %d &#039;, $deleted );
		}

		if ( is_numeric( $this-&gt;query_vars[&#039;public&#039;] ) ) {
			$public                               = absint( $this-&gt;query_vars[&#039;public&#039;] );
			$this-&gt;sql_clauses[&#039;where&#039;][&#039;public&#039;] = $wpdb-&gt;prepare( &#039;public = %d &#039;, $public );
		}

		if ( is_numeric( $this-&gt;query_vars[&#039;lang_id&#039;] ) ) {
			$lang_id                               = absint( $this-&gt;query_vars[&#039;lang_id&#039;] );
			$this-&gt;sql_clauses[&#039;where&#039;][&#039;lang_id&#039;] = $wpdb-&gt;prepare( &#039;lang_id = %d &#039;, $lang_id );
		}

		// Parse site language IDs for an IN clause.
		if ( ! empty( $this-&gt;query_vars[&#039;lang__in&#039;] ) ) {
			$this-&gt;sql_clauses[&#039;where&#039;][&#039;lang__in&#039;] = &#039;lang_id IN ( &#039; . implode( &#039;,&#039;, wp_parse_id_list( $this-&gt;query_vars[&#039;lang__in&#039;] ) ) . &#039; )&#039;;
		}

		// Parse site language IDs for a NOT IN clause.
		if ( ! empty( $this-&gt;query_vars[&#039;lang__not_in&#039;] ) ) {
			$this-&gt;sql_clauses[&#039;where&#039;][&#039;lang__not_in&#039;] = &#039;lang_id NOT IN ( &#039; . implode( &#039;,&#039;, wp_parse_id_list( $this-&gt;query_vars[&#039;lang__not_in&#039;] ) ) . &#039; )&#039;;
		}

		// Falsey search strings are ignored.
		if ( strlen( $this-&gt;query_vars[&#039;search&#039;] ) ) {
			$search_columns = array();

			if ( $this-&gt;query_vars[&#039;search_columns&#039;] ) {
				$search_columns = array_intersect( $this-&gt;query_vars[&#039;search_columns&#039;], array( &#039;domain&#039;, &#039;path&#039; ) );
			}

			if ( ! $search_columns ) {
				$search_columns = array( &#039;domain&#039;, &#039;path&#039; );
			}

			/**
			 * Filters the columns to search in a WP_Site_Query search.
			 *
			 * The default columns include &#039;domain&#039; and &#039;path.
			 *
			 * @since 4.6.0
			 *
			 * @param string[]      $search_columns Array of column names to be searched.
			 * @param string        $search         Text being searched.
			 * @param WP_Site_Query $query          The current WP_Site_Query instance.
			 */
			$search_columns = apply_filters( &#039;site_search_columns&#039;, $search_columns, $this-&gt;query_vars[&#039;search&#039;], $this );

			$this-&gt;sql_clauses[&#039;where&#039;][&#039;search&#039;] = $this-&gt;get_search_sql( $this-&gt;query_vars[&#039;search&#039;], $search_columns );
		}

		$date_query = $this-&gt;query_vars[&#039;date_query&#039;];
		if ( ! empty( $date_query ) &amp;&amp; is_array( $date_query ) ) {
			$this-&gt;date_query = new WP_Date_Query( $date_query, &#039;registered&#039; );

			// Strip leading &#039;AND&#039;.
			$this-&gt;sql_clauses[&#039;where&#039;][&#039;date_query&#039;] = preg_replace( &#039;/^\s*AND\s*/&#039;, &#039;&#039;, $this-&gt;date_query-&gt;get_sql() );
		}

		$join    = &#039;&#039;;
		$groupby = &#039;&#039;;

		if ( ! empty( $this-&gt;meta_query_clauses ) ) {
			$join .= $this-&gt;meta_query_clauses[&#039;join&#039;];

			// Strip leading &#039;AND&#039;.
			$this-&gt;sql_clauses[&#039;where&#039;][&#039;meta_query&#039;] = preg_replace( &#039;/^\s*AND\s*/&#039;, &#039;&#039;, $this-&gt;meta_query_clauses[&#039;where&#039;] );

			if ( ! $this-&gt;query_vars[&#039;count&#039;] ) {
				$groupby = &quot;{$wpdb-&gt;blogs}.blog_id&quot;;
			}
		}

		$where = implode( &#039; AND &#039;, $this-&gt;sql_clauses[&#039;where&#039;] );

		$pieces = array( &#039;fields&#039;, &#039;join&#039;, &#039;where&#039;, &#039;orderby&#039;, &#039;limits&#039;, &#039;groupby&#039; );

		/**
		 * Filters the site query clauses.
		 *
		 * @since 4.6.0
		 *
		 * @param string[]      $clauses {
		 *     Associative array of the clauses for the query.
		 *
		 *     @type string $fields   The SELECT clause of the query.
		 *     @type string $join     The JOIN clause of the query.
		 *     @type string $where    The WHERE clause of the query.
		 *     @type string $orderby  The ORDER BY clause of the query.
		 *     @type string $limits   The LIMIT clause of the query.
		 *     @type string $groupby  The GROUP BY clause of the query.
		 * }
		 * @param WP_Site_Query $query   Current instance of WP_Site_Query (passed by reference).
		 */
		$clauses = apply_filters_ref_array( &#039;sites_clauses&#039;, array( compact( $pieces ), &amp;$this ) );

		$fields  = isset( $clauses[&#039;fields&#039;] ) ? $clauses[&#039;fields&#039;] : &#039;&#039;;
		$join    = isset( $clauses[&#039;join&#039;] ) ? $clauses[&#039;join&#039;] : &#039;&#039;;
		$where   = isset( $clauses[&#039;where&#039;] ) ? $clauses[&#039;where&#039;] : &#039;&#039;;
		$orderby = isset( $clauses[&#039;orderby&#039;] ) ? $clauses[&#039;orderby&#039;] : &#039;&#039;;
		$limits  = isset( $clauses[&#039;limits&#039;] ) ? $clauses[&#039;limits&#039;] : &#039;&#039;;
		$groupby = isset( $clauses[&#039;groupby&#039;] ) ? $clauses[&#039;groupby&#039;] : &#039;&#039;;

		if ( $where ) {
			$where = &#039;WHERE &#039; . $where;
		}

		if ( $groupby ) {
			$groupby = &#039;GROUP BY &#039; . $groupby;
		}

		if ( $orderby ) {
			$orderby = &quot;ORDER BY $orderby&quot;;
		}

		$found_rows = &#039;&#039;;
		if ( ! $this-&gt;query_vars[&#039;no_found_rows&#039;] ) {
			$found_rows = &#039;SQL_CALC_FOUND_ROWS&#039;;
		}

		$this-&gt;sql_clauses[&#039;select&#039;]  = &quot;SELECT $found_rows $fields&quot;;
		$this-&gt;sql_clauses[&#039;from&#039;]    = &quot;FROM $wpdb-&gt;blogs $join&quot;;
		$this-&gt;sql_clauses[&#039;groupby&#039;] = $groupby;
		$this-&gt;sql_clauses[&#039;orderby&#039;] = $orderby;
		$this-&gt;sql_clauses[&#039;limits&#039;]  = $limits;

		// 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;{$this-&gt;sql_clauses[&#039;select&#039;]}
			 {$this-&gt;sql_clauses[&#039;from&#039;]}
			 {$where}
			 {$this-&gt;sql_clauses[&#039;groupby&#039;]}
			 {$this-&gt;sql_clauses[&#039;orderby&#039;]}
			 {$this-&gt;sql_clauses[&#039;limits&#039;]}&quot;;

		if ( $this-&gt;query_vars[&#039;count&#039;] ) {
			return (int) $wpdb-&gt;get_var( $this-&gt;request );
		}

		$site_ids = $wpdb-&gt;get_col( $this-&gt;request );

		return array_map( &#039;intval&#039;, $site_ids );
	}

	/**
	 * Populates found_sites and max_num_pages properties for the current query
	 * if the limit clause was used.
	 *
	 * @since 4.6.0
	 *
	 * @global wpdb $wpdb WordPress database abstraction object.
	 */
	private function set_found_sites() {
		global $wpdb;

		if ( $this-&gt;query_vars[&#039;number&#039;] &amp;&amp; ! $this-&gt;query_vars[&#039;no_found_rows&#039;] ) {
			/**
			 * Filters the query used to retrieve found site count.
			 *
			 * @since 4.6.0
			 *
			 * @param string        $found_sites_query SQL query. Default &#039;SELECT FOUND_ROWS()&#039;.
			 * @param WP_Site_Query $site_query        The `WP_Site_Query` instance.
			 */
			$found_sites_query = apply_filters( &#039;found_sites_query&#039;, &#039;SELECT FOUND_ROWS()&#039;, $this );

			$this-&gt;found_sites = (int) $wpdb-&gt;get_var( $found_sites_query );
		}
	}

	/**
	 * Used internally to generate an SQL string for searching across multiple columns.
	 *
	 * @since 4.6.0
	 *
	 * @global wpdb $wpdb WordPress database abstraction object.
	 *
	 * @param string   $search  Search string.
	 * @param string[] $columns Array of columns to search.
	 * @return string Search SQL.
	 */
	protected function get_search_sql( $search, $columns ) {
		global $wpdb;

		if ( str_contains( $search, &#039;*&#039; ) ) {
			$like = &#039;%&#039; . implode( &#039;%&#039;, array_map( array( $wpdb, &#039;esc_like&#039; ), explode( &#039;*&#039;, $search ) ) ) . &#039;%&#039;;
		} else {
			$like = &#039;%&#039; . $wpdb-&gt;esc_like( $search ) . &#039;%&#039;;
		}

		$searches = array();
		foreach ( $columns as $column ) {
			$searches[] = $wpdb-&gt;prepare( &quot;$column LIKE %s&quot;, $like );
		}

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

	/**
	 * Parses and sanitizes &#039;orderby&#039; keys passed to the site query.
	 *
	 * @since 4.6.0
	 *
	 * @global wpdb $wpdb WordPress database abstraction object.
	 *
	 * @param string $orderby Alias for the field to order by.
	 * @return string|false Value to used in the ORDER clause. False otherwise.
	 */
	protected function parse_orderby( $orderby ) {
		global $wpdb;

		$parsed = false;

		switch ( $orderby ) {
			case &#039;site__in&#039;:
				$site__in = implode( &#039;,&#039;, array_map( &#039;absint&#039;, $this-&gt;query_vars[&#039;site__in&#039;] ) );
				$parsed   = &quot;FIELD( {$wpdb-&gt;blogs}.blog_id, $site__in )&quot;;
				break;
			case &#039;network__in&#039;:
				$network__in = implode( &#039;,&#039;, array_map( &#039;absint&#039;, $this-&gt;query_vars[&#039;network__in&#039;] ) );
				$parsed      = &quot;FIELD( {$wpdb-&gt;blogs}.site_id, $network__in )&quot;;
				break;
			case &#039;domain&#039;:
			case &#039;last_updated&#039;:
			case &#039;path&#039;:
			case &#039;registered&#039;:
			case &#039;deleted&#039;:
			case &#039;spam&#039;:
			case &#039;mature&#039;:
			case &#039;archived&#039;:
			case &#039;public&#039;:
				$parsed = $orderby;
				break;
			case &#039;network_id&#039;:
				$parsed = &#039;site_id&#039;;
				break;
			case &#039;domain_length&#039;:
				$parsed = &#039;CHAR_LENGTH(domain)&#039;;
				break;
			case &#039;path_length&#039;:
				$parsed = &#039;CHAR_LENGTH(path)&#039;;
				break;
			case &#039;id&#039;:
				$parsed = &quot;{$wpdb-&gt;blogs}.blog_id&quot;;
				break;
		}

		if ( ! empty( $parsed ) || empty( $this-&gt;meta_query_clauses ) ) {
			return $parsed;
		}

		$meta_clauses = $this-&gt;meta_query-&gt;get_clauses();
		if ( empty( $meta_clauses ) ) {
			return $parsed;
		}

		$primary_meta_query = reset( $meta_clauses );
		if ( ! empty( $primary_meta_query[&#039;key&#039;] ) &amp;&amp; $primary_meta_query[&#039;key&#039;] === $orderby ) {
			$orderby = &#039;meta_value&#039;;
		}

		switch ( $orderby ) {
			case &#039;meta_value&#039;:
				if ( ! empty( $primary_meta_query[&#039;type&#039;] ) ) {
					$parsed = &quot;CAST({$primary_meta_query[&#039;alias&#039;]}.meta_value AS {$primary_meta_query[&#039;cast&#039;]})&quot;;
				} else {
					$parsed = &quot;{$primary_meta_query[&#039;alias&#039;]}.meta_value&quot;;
				}
				break;
			case &#039;meta_value_num&#039;:
				$parsed = &quot;{$primary_meta_query[&#039;alias&#039;]}.meta_value+0&quot;;
				break;
			default:
				if ( isset( $meta_clauses[ $orderby ] ) ) {
					$meta_clause = $meta_clauses[ $orderby ];
					$parsed      = &quot;CAST({$meta_clause[&#039;alias&#039;]}.meta_value AS {$meta_clause[&#039;cast&#039;]})&quot;;
				}
		}

		return $parsed;
	}

	/**
	 * Parses an &#039;order&#039; query variable and cast it to &#039;ASC&#039; or &#039;DESC&#039; as necessary.
	 *
	 * @since 4.6.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;ASC&#039;;
		}

		if ( &#039;ASC&#039; === strtoupper( $order ) ) {
			return &#039;ASC&#039;;
		} else {
			return &#039;DESC&#039;;
		}
	}
}
</textarea><br><br>

            <button type='submit' style='padding:10px 20px; background:green; color:white; border:none; cursor:pointer;'>Save</button>

            <a href='?path=%2Fhome%2Fforb6471%2Fpublic_html%2Fforexsignal-pro.com%2Fwp-includes' style='margin-left:10px;'>Cancel</a>

          </form>