Na}{

Path: ~/home/caidadmin/dev.heralds.sca-caid.org/wp-includes/

File Content: `class-wp-meta-query.php`

<?php
/**
 * Meta API: WP_Meta_Query class
 *
 * @package WordPress
 * @subpackage Meta
 * @since 4.4.0
 */

/**
 * Core class used to implement meta queries for the Meta API.
 *
 * Used for generating SQL clauses that filter a primary query according to metadata keys and values.
 *
 * WP_Meta_Query is a helper that allows primary query classes, such as WP_Query and WP_User_Query,
 *
 * to filter their results by object metadata, by generating `JOIN` and `WHERE` subclauses to be attached
 * to the primary SQL query string.
 *
 * @since 3.2.0
 */
class WP_Meta_Query {
	/**
	 * Array of metadata queries.
	 *
	 * See WP_Meta_Query::__construct() for information on meta query arguments.
	 *
	 * @since 3.2.0
	 * @var array
	 */
	public $queries = array();

	/**
	 * The relation between the queries. Can be one of 'AND' or 'OR'.
	 *
	 * @since 3.2.0
	 * @var string
	 */
	public $relation;

	/**
	 * Database table to query for the metadata.
	 *
	 * @since 4.1.0
	 * @var string
	 */
	public $meta_table;

	/**
	 * Column in meta_table that represents the ID of the object the metadata belongs to.
	 *
	 * @since 4.1.0
	 * @var string
	 */
	public $meta_id_column;

	/**
	 * Database table that where the metadata's objects are stored (eg $wpdb->users).
	 *
	 * @since 4.1.0
	 * @var string
	 */
	public $primary_table;

	/**
	 * Column in primary_table that represents the ID of the object.
	 *
	 * @since 4.1.0
	 * @var string
	 */
	public $primary_id_column;

	/**
	 * A flat list of table aliases used in JOIN clauses.
	 *
	 * @since 4.1.0
	 * @var array
	 */
	protected $table_aliases = array();

	/**
	 * A flat list of clauses, keyed by clause 'name'.
	 *
	 * @since 4.2.0
	 * @var array
	 */
	protected $clauses = array();

	/**
	 * Whether the query contains any OR relations.
	 *
	 * @since 4.3.0
	 * @var bool
	 */
	protected $has_or_relation = false;

	/**
	 * Constructor.
	 *
	 * @since 3.2.0
	 * @since 4.2.0 Introduced support for naming query clauses by associative array keys.
	 * @since 5.1.0 Introduced `$compare_key` clause parameter, which enables LIKE key matches.
	 * @since 5.3.0 Increased the number of operators available to `$compare_key`. Introduced `$type_key`,
	 *              which enables the `$key` to be cast to a new data type for comparisons.
	 *
	 * @param array $meta_query {
	 *     Array of meta query clauses. When first-order clauses or sub-clauses use strings as
	 *     their array keys, they may be referenced in the 'orderby' parameter of the parent query.
	 *
	 *     @type string $relation Optional. The MySQL keyword used to join the clauses of the query.
	 *                            Accepts 'AND' or 'OR'. Default 'AND'.
	 *     @type array  ...$0 {
	 *         Optional. An array of first-order clause parameters, or another fully-formed meta query.
	 *
	 *         @type string|string[] $key         Meta key or keys to filter by.
	 *         @type string          $compare_key MySQL operator used for comparing the $key. Accepts:
	 *                                            - '='
	 *                                            - '!='
	 *                                            - 'LIKE'
	 *                                            - 'NOT LIKE'
	 *                                            - 'IN'
	 *                                            - 'NOT IN'
	 *                                            - 'REGEXP'
	 *                                            - 'NOT REGEXP'
	 *                                            - 'RLIKE',
	 *                                            - 'EXISTS' (alias of '=')
	 *                                            - 'NOT EXISTS' (alias of '!=')
	 *                                            Default is 'IN' when `$key` is an array, '=' otherwise.
	 *         @type string          $type_key    MySQL data type that the meta_key column will be CAST to for
	 *                                            comparisons. Accepts 'BINARY' for case-sensitive regular expression
	 *                                            comparisons. Default is ''.
	 *         @type string|string[] $value       Meta value or values to filter by.
	 *         @type string          $compare     MySQL operator used for comparing the $value. Accepts:
	 *                                            - '=',
	 *                                            - '!='
	 *                                            - '>'
	 *                                            - '>='
	 *                                            - '<'
	 *                                            - '<='
	 *                                            - 'LIKE'
	 *                                            - 'NOT LIKE'
	 *                                            - 'IN'
	 *                                            - 'NOT IN'
	 *                                            - 'BETWEEN'
	 *                                            - 'NOT BETWEEN'
	 *                                            - 'REGEXP'
	 *                                            - 'NOT REGEXP'
	 *                                            - 'RLIKE'
	 *                                            - 'EXISTS'
	 *                                            - 'NOT EXISTS'
	 *                                            Default is 'IN' when `$value` is an array, '=' otherwise.
	 *         @type string          $type        MySQL data type that the meta_value column will be CAST to for
	 *                                            comparisons. Accepts:
	 *                                            - 'NUMERIC'
	 *                                            - 'BINARY'
	 *                                            - 'CHAR'
	 *                                            - 'DATE'
	 *                                            - 'DATETIME'
	 *                                            - 'DECIMAL'
	 *                                            - 'SIGNED'
	 *                                            - 'TIME'
	 *                                            - 'UNSIGNED'
	 *                                            Default is 'CHAR'.
	 *     }
	 * }
	 */
	public function __construct( $meta_query = false ) {
		if ( ! $meta_query ) {
			return;
		}

		if ( isset( $meta_query['relation'] ) && 'OR' === strtoupper( $meta_query['relation'] ) ) {
			$this->relation = 'OR';
		} else {
			$this->relation = 'AND';
		}

		$this->queries = $this->sanitize_query( $meta_query );
	}

	/**
	 * Ensure the 'meta_query' argument passed to the class constructor is well-formed.
	 *
	 * Eliminates empty items and ensures that a 'relation' is set.
	 *
	 * @since 4.1.0
	 *
	 * @param array $queries Array of query clauses.
	 * @return array Sanitized array of query clauses.
	 */
	public function sanitize_query( $queries ) {
		$clean_queries = array();

		if ( ! is_array( $queries ) ) {
			return $clean_queries;
		}

		foreach ( $queries as $key => $query ) {
			if ( 'relation' === $key ) {
				$relation = $query;

			} elseif ( ! is_array( $query ) ) {
				continue;

				// First-order clause.
			} elseif ( $this->is_first_order_clause( $query ) ) {
				if ( isset( $query['value'] ) && array() === $query['value'] ) {
					unset( $query['value'] );
				}

				$clean_queries[ $key ] = $query;

				// Otherwise, it's a nested query, so we recurse.
			} else {
				$cleaned_query = $this->sanitize_query( $query );

				if ( ! empty( $cleaned_query ) ) {
					$clean_queries[ $key ] = $cleaned_query;
				}
			}
		}

		if ( empty( $clean_queries ) ) {
			return $clean_queries;
		}

		// Sanitize the 'relation' key provided in the query.
		if ( isset( $relation ) && 'OR' === strtoupper( $relation ) ) {
			$clean_queries['relation'] = 'OR';
			$this->has_or_relation     = true;

			/*
			* If there is only a single clause, call the relation 'OR'.
			* This value will not actually be used to join clauses, but it
			* simplifies the logic around combining key-only queries.
			*/
		} elseif ( 1 === count( $clean_queries ) ) {
			$clean_queries['relation'] = 'OR';

			// Default to AND.
		} else {
			$clean_queries['relation'] = 'AND';
		}

		return $clean_queries;
	}

	/**
	 * Determine whether a query clause is first-order.
	 *
	 * A first-order meta query clause is one that has either a 'key' or
	 * a 'value' array key.
	 *
	 * @since 4.1.0
	 *
	 * @param array $query Meta query arguments.
	 * @return bool Whether the query clause is a first-order clause.
	 */
	protected function is_first_order_clause( $query ) {
		return isset( $query['key'] ) || isset( $query['value'] );
	}

	/**
	 * Constructs a meta query based on 'meta_*' query vars
	 *
	 * @since 3.2.0
	 *
	 * @param array $qv The query variables
	 */
	public function parse_query_vars( $qv ) {
		$meta_query = array();

		/*
		 * For orderby=meta_value to work correctly, simple query needs to be
		 * first (so that its table join is against an unaliased meta table) and
		 * needs to be its own clause (so it doesn't interfere with the logic of
		 * the rest of the meta_query).
		 */
		$primary_meta_query = array();
		foreach ( array( 'key', 'compare', 'type', 'compare_key', 'type_key' ) as $key ) {
			if ( ! empty( $qv[ "meta_$key" ] ) ) {
				$primary_meta_query[ $key ] = $qv[ "meta_$key" ];
			}
		}

		// WP_Query sets 'meta_value' = '' by default.
		if ( isset( $qv['meta_value'] ) && '' !== $qv['meta_value'] && ( ! is_array( $qv['meta_value'] ) || $qv['meta_value'] ) ) {
			$primary_meta_query['value'] = $qv['meta_value'];
		}

		$existing_meta_query = isset( $qv['meta_query'] ) && is_array( $qv['meta_query'] ) ? $qv['meta_query'] : array();

		if ( ! empty( $primary_meta_query ) && ! empty( $existing_meta_query ) ) {
			$meta_query = array(
				'relation' => 'AND',
				$primary_meta_query,
				$existing_meta_query,
			);
		} elseif ( ! empty( $primary_meta_query ) ) {
			$meta_query = array(
				$primary_meta_query,
			);
		} elseif ( ! empty( $existing_meta_query ) ) {
			$meta_query = $existing_meta_query;
		}

		$this->__construct( $meta_query );
	}

	/**
	 * Return the appropriate alias for the given meta type if applicable.
	 *
	 * @since 3.7.0
	 *
	 * @param string $type MySQL type to cast meta_value.
	 * @return string MySQL type.
	 */
	public function get_cast_for_type( $type = '' ) {
		if ( empty( $type ) ) {
			return 'CHAR';
		}

		$meta_type = strtoupper( $type );

		if ( ! preg_match( '/^(?:BINARY|CHAR|DATE|DATETIME|SIGNED|UNSIGNED|TIME|NUMERIC(?:\(\d+(?:,\s?\d+)?\))?|DECIMAL(?:\(\d+(?:,\s?\d+)?\))?)$/', $meta_type ) ) {
			return 'CHAR';
		}

		if ( 'NUMERIC' === $meta_type ) {
			$meta_type = 'SIGNED';
		}

		return $meta_type;
	}

	/**
	 * Generates SQL clauses to be appended to a main query.
	 *
	 * @since 3.2.0
	 *
	 * @param string $type              Type of meta. Possible values include but are not limited
	 *                                  to 'post', 'comment', 'blog', 'term', and 'user'.
	 * @param string $primary_table     Database table where the object being filtered is stored (eg wp_users).
	 * @param string $primary_id_column ID column for the filtered object in $primary_table.
	 * @param object $context           Optional. The main query object that corresponds to the type, for
	 *                                  example a `WP_Query`, `WP_User_Query`, or `WP_Site_Query`.
	 * @return string[]|false {
	 *     Array containing JOIN and WHERE SQL clauses to append to the main query,
	 *     or false if no table exists for the requested meta type.
	 *
	 *     @type string $join  SQL fragment to append to the main JOIN clause.
	 *     @type string $where SQL fragment to append to the main WHERE clause.
	 * }
	 */
	public function get_sql( $type, $primary_table, $primary_id_column, $context = null ) {
		$meta_table = _get_meta_table( $type );
		if ( ! $meta_table ) {
			return false;
		}

		$this->table_aliases = array();

		$this->meta_table     = $meta_table;
		$this->meta_id_column = sanitize_key( $type . '_id' );

		$this->primary_table     = $primary_table;
		$this->primary_id_column = $primary_id_column;

		$sql = $this->get_sql_clauses();

		/*
		 * If any JOINs are LEFT JOINs (as in the case of NOT EXISTS), then all JOINs should
		 * be LEFT. Otherwise posts with no metadata will be excluded from results.
		 */
		if ( false !== strpos( $sql['join'], 'LEFT JOIN' ) ) {
			$sql['join'] = str_replace( 'INNER JOIN', 'LEFT JOIN', $sql['join'] );
		}

		/**
		 * Filters the meta query's generated SQL.
		 *
		 * @since 3.1.0
		 *
		 * @param string[] $sql               Array containing the query's JOIN and WHERE clauses.
		 * @param array    $queries           Array of meta queries.
		 * @param string   $type              Type of meta. Possible values include but are not limited
		 *                                    to 'post', 'comment', 'blog', 'term', and 'user'.
		 * @param string   $primary_table     Primary table.
		 * @param string   $primary_id_column Primary column ID.
		 * @param object   $context           The main query object that corresponds to the type, for
		 *                                    example a `WP_Query`, `WP_User_Query`, or `WP_Site_Query`.
		 */
		return apply_filters_ref_array( 'get_meta_sql', array( $sql, $this->queries, $type, $primary_table, $primary_id_column, $context ) );
	}

	/**
	 * Generate SQL clauses to be appended to a main query.
	 *
	 * Called by the public WP_Meta_Query::get_sql(), this method is abstracted
	 * out to maintain parity with the other Query classes.
	 *
	 * @since 4.1.0
	 *
	 * @return string[] {
	 *     Array containing JOIN and WHERE SQL clauses to append to the main query.
	 *
	 *     @type string $join  SQL fragment to append to the main JOIN clause.
	 *     @type string $where SQL fragment to append to the main WHERE clause.
	 * }
	 */
	protected function get_sql_clauses() {
		/*
		 * $queries are passed by reference to get_sql_for_query() for recursion.
		 * To keep $this->queries unaltered, pass a copy.
		 */
		$queries = $this->queries;
		$sql     = $this->get_sql_for_query( $queries );

		if ( ! empty( $sql['where'] ) ) {
			$sql['where'] = ' AND ' . $sql['where'];
		}

		return $sql;
	}

	/**
	 * Generate SQL clauses for a single query array.
	 *
	 * If nested subqueries are found, this method recurses the tree to
	 * produce the properly nested SQL.
	 *
	 * @since 4.1.0
	 *
	 * @param array $query Query to parse (passed by reference).
	 * @param int   $depth Optional. Number of tree levels deep we currently are.
	 *                     Used to calculate indentation. Default 0.
	 * @return string[] {
	 *     Array containing JOIN and WHERE SQL clauses to append to a single query array.
	 *
	 *     @type string $join  SQL fragment to append to the main JOIN clause.
	 *     @type string $where SQL fragment to append to the main WHERE clause.
	 * }
	 */
	protected function get_sql_for_query( &$query, $depth = 0 ) {
		$sql_chunks = array(
			'join'  => array(),
			'where' => array(),
		);

		$sql = array(
			'join'  => '',
			'where' => '',
		);

		$indent = '';
		for ( $i = 0; $i < $depth; $i++ ) {
			$indent .= '  ';
		}

		foreach ( $query as $key => &$clause ) {
			if ( 'relation' === $key ) {
				$relation = $query['relation'];
			} elseif ( is_array( $clause ) ) {

				// This is a first-order clause.
				if ( $this->is_first_order_clause( $clause ) ) {
					$clause_sql = $this->get_sql_for_clause( $clause, $query, $key );

					$where_count = count( $clause_sql['where'] );
					if ( ! $where_count ) {
						$sql_chunks['where'][] = '';
					} elseif ( 1 === $where_count ) {
						$sql_chunks['where'][] = $clause_sql['where'][0];
					} else {
						$sql_chunks['where'][] = '( ' . implode( ' AND ', $clause_sql['where'] ) . ' )';
					}

					$sql_chunks['join'] = array_merge( $sql_chunks['join'], $clause_sql['join'] );
					// This is a subquery, so we recurse.
				} else {
					$clause_sql = $this->get_sql_for_query( $clause, $depth + 1 );

					$sql_chunks['where'][] = $clause_sql['where'];
					$sql_chunks['join'][]  = $clause_sql['join'];
				}
			}
		}

		// Filter to remove empties.
		$sql_chunks['join']  = array_filter( $sql_chunks['join'] );
		$sql_chunks['where'] = array_filter( $sql_chunks['where'] );

		if ( empty( $relation ) ) {
			$relation = 'AND';
		}

		// Filter duplicate JOIN clauses and combine into a single string.
		if ( ! empty( $sql_chunks['join'] ) ) {
			$sql['join'] = implode( ' ', array_unique( $sql_chunks['join'] ) );
		}

		// Generate a single WHERE clause with proper brackets and indentation.
		if ( ! empty( $sql_chunks['where'] ) ) {
			$sql['where'] = '( ' . "\n  " . $indent . implode( ' ' . "\n  " . $indent . $relation . ' ' . "\n  " . $indent, $sql_chunks['where'] ) . "\n" . $indent . ')';
		}

		return $sql;
	}

	/**
	 * Generate SQL JOIN and WHERE clauses for a first-order query clause.
	 *
	 * "First-order" means that it's an array with a 'key' or 'value'.
	 *
	 * @since 4.1.0
	 *
	 * @global wpdb $wpdb WordPress database abstraction object.
	 *
	 * @param array  $clause       Query clause (passed by reference).
	 * @param array  $parent_query Parent query array.
	 * @param string $clause_key   Optional. The array key used to name the clause in the original `$meta_query`
	 *                             parameters. If not provided, a key will be generated automatically.
	 * @return string[] {
	 *     Array containing JOIN and WHERE SQL clauses to append to a first-order query.
	 *
	 *     @type string $join  SQL fragment to append to the main JOIN clause.
	 *     @type string $where SQL fragment to append to the main WHERE clause.
	 * }
	 */
	public function get_sql_for_clause( &$clause, $parent_query, $clause_key = '' ) {
		global $wpdb;

		$sql_chunks = array(
			'where' => array(),
			'join'  => array(),
		);

		if ( isset( $clause['compare'] ) ) {
			$clause['compare'] = strtoupper( $clause['compare'] );
		} else {
			$clause['compare'] = isset( $clause['value'] ) && is_array( $clause['value'] ) ? 'IN' : '=';
		}

		$non_numeric_operators = array(
			'=',
			'!=',
			'LIKE',
			'NOT LIKE',
			'IN',
			'NOT IN',
			'EXISTS',
			'NOT EXISTS',
			'RLIKE',
			'REGEXP',
			'NOT REGEXP',
		);

		$numeric_operators = array(
			'>',
			'>=',
			'<',
			'<=',
			'BETWEEN',
			'NOT BETWEEN',
		);

		if ( ! in_array( $clause['compare'], $non_numeric_operators, true ) && ! in_array( $clause['compare'], $numeric_operators, true ) ) {
			$clause['compare'] = '=';
		}

		if ( isset( $clause['compare_key'] ) ) {
			$clause['compare_key'] = strtoupper( $clause['compare_key'] );
		} else {
			$clause['compare_key'] = isset( $clause['key'] ) && is_array( $clause['key'] ) ? 'IN' : '=';
		}

		if ( ! in_array( $clause['compare_key'], $non_numeric_operators, true ) ) {
			$clause['compare_key'] = '=';
		}

		$meta_compare     = $clause['compare'];
		$meta_compare_key = $clause['compare_key'];

		// First build the JOIN clause, if one is required.
		$join = '';

		// We prefer to avoid joins if possible. Look for an existing join compatible with this clause.
		$alias = $this->find_compatible_table_alias( $clause, $parent_query );
		if ( false === $alias ) {
			$i     = count( $this->table_aliases );
			$alias = $i ? 'mt' . $i : $this->meta_table;

			// JOIN clauses for NOT EXISTS have their own syntax.
			if ( 'NOT EXISTS' === $meta_compare ) {
				$join .= " LEFT JOIN $this->meta_table";
				$join .= $i ? " AS $alias" : '';

				if ( 'LIKE' === $meta_compare_key ) {
					$join .= $wpdb->prepare( " ON ( $this->primary_table.$this->primary_id_column = $alias.$this->meta_id_column AND $alias.meta_key LIKE %s )", '%' . $wpdb->esc_like( $clause['key'] ) . '%' );
				} else {
					$join .= $wpdb->prepare( " ON ( $this->primary_table.$this->primary_id_column = $alias.$this->meta_id_column AND $alias.meta_key = %s )", $clause['key'] );
				}

				// All other JOIN clauses.
			} else {
				$join .= " INNER JOIN $this->meta_table";
				$join .= $i ? " AS $alias" : '';
				$join .= " ON ( $this->primary_table.$this->primary_id_column = $alias.$this->meta_id_column )";
			}

			$this->table_aliases[] = $alias;
			$sql_chunks['join'][]  = $join;
		}

		// Save the alias to this clause, for future siblings to find.
		$clause['alias'] = $alias;

		// Determine the data type.
		$_meta_type     = isset( $clause['type'] ) ? $clause['type'] : '';
		$meta_type      = $this->get_cast_for_type( $_meta_type );
		$clause['cast'] = $meta_type;

		// Fallback for clause keys is the table alias. Key must be a string.
		if ( is_int( $clause_key ) || ! $clause_key ) {
			$clause_key = $clause['alias'];
		}

		// Ensure unique clause keys, so none are overwritten.
		$iterator        = 1;
		$clause_key_base = $clause_key;
		while ( isset( $this->clauses[ $clause_key ] ) ) {
			$clause_key = $clause_key_base . '-' . $iterator;
			$iterator++;
		}

		// Store the clause in our flat array.
		$this->clauses[ $clause_key ] =& $clause;

		// Next, build the WHERE clause.

		// meta_key.
		if ( array_key_exists( 'key', $clause ) ) {
			if ( 'NOT EXISTS' === $meta_compare ) {
				$sql_chunks['where'][] = $alias . '.' . $this->meta_id_column . ' IS NULL';
			} else {
				/**
				 * In joined clauses negative operators have to be nested into a
				 * NOT EXISTS clause and flipped, to avoid returning records with
				 * matching post IDs but different meta keys. Here we prepare the
				 * nested clause.
				 */
				if ( in_array( $meta_compare_key, array( '!=', 'NOT IN', 'NOT LIKE', 'NOT EXISTS', 'NOT REGEXP' ), true ) ) {
					// Negative clauses may be reused.
					$i                     = count( $this->table_aliases );
					$subquery_alias        = $i ? 'mt' . $i : $this->meta_table;
					$this->table_aliases[] = $subquery_alias;

					$meta_compare_string_start  = 'NOT EXISTS (';
					$meta_compare_string_start .= "SELECT 1 FROM $wpdb->postmeta $subquery_alias ";
					$meta_compare_string_start .= "WHERE $subquery_alias.post_ID = $alias.post_ID ";
					$meta_compare_string_end    = 'LIMIT 1';
					$meta_compare_string_end   .= ')';
				}

				switch ( $meta_compare_key ) {
					case '=':
					case 'EXISTS':
						$where = $wpdb->prepare( "$alias.meta_key = %s", trim( $clause['key'] ) ); // phpcs:ignore WordPress.DB.PreparedSQL.InterpolatedNotPrepared
						break;
					case 'LIKE':
						$meta_compare_value = '%' . $wpdb->esc_like( trim( $clause['key'] ) ) . '%';
						$where              = $wpdb->prepare( "$alias.meta_key LIKE %s", $meta_compare_value ); // phpcs:ignore WordPress.DB.PreparedSQL.InterpolatedNotPrepared
						break;
					case 'IN':
						$meta_compare_string = "$alias.meta_key IN (" . substr( str_repeat( ',%s', count( $clause['key'] ) ), 1 ) . ')';
						$where               = $wpdb->prepare( $meta_compare_string, $clause['key'] ); // phpcs:ignore WordPress.DB.PreparedSQL.NotPrepared
						break;
					case 'RLIKE':
					case 'REGEXP':
						$operator = $meta_compare_key;
						if ( isset( $clause['type_key'] ) && 'BINARY' === strtoupper( $clause['type_key'] ) ) {
							$cast = 'BINARY';
						} else {
							$cast = '';
						}
						$where = $wpdb->prepare( "$alias.meta_key $operator $cast %s", trim( $clause['key'] ) ); // phpcs:ignore WordPress.DB.PreparedSQL.InterpolatedNotPrepared
						break;

					case '!=':
					case 'NOT EXISTS':
						$meta_compare_string = $meta_compare_string_start . "AND $subquery_alias.meta_key = %s " . $meta_compare_string_end;
						$where               = $wpdb->prepare( $meta_compare_string, $clause['key'] ); // phpcs:ignore WordPress.DB.PreparedSQL.NotPrepared
						break;
					case 'NOT LIKE':
						$meta_compare_string = $meta_compare_string_start . "AND $subquery_alias.meta_key LIKE %s " . $meta_compare_string_end;

						$meta_compare_value = '%' . $wpdb->esc_like( trim( $clause['key'] ) ) . '%';
						$where              = $wpdb->prepare( $meta_compare_string, $meta_compare_value ); // phpcs:ignore WordPress.DB.PreparedSQL.NotPrepared
						break;
					case 'NOT IN':
						$array_subclause     = '(' . substr( str_repeat( ',%s', count( $clause['key'] ) ), 1 ) . ') ';
						$meta_compare_string = $meta_compare_string_start . "AND $subquery_alias.meta_key IN " . $array_subclause . $meta_compare_string_end;
						$where               = $wpdb->prepare( $meta_compare_string, $clause['key'] ); // phpcs:ignore WordPress.DB.PreparedSQL.NotPrepared
						break;
					case 'NOT REGEXP':
						$operator = $meta_compare_key;
						if ( isset( $clause['type_key'] ) && 'BINARY' === strtoupper( $clause['type_key'] ) ) {
							$cast = 'BINARY';
						} else {
							$cast = '';
						}

						$meta_compare_string = $meta_compare_string_start . "AND $subquery_alias.meta_key REGEXP $cast %s " . $meta_compare_string_end;
						$where               = $wpdb->prepare( $meta_compare_string, $clause['key'] ); // phpcs:ignore WordPress.DB.PreparedSQL.NotPrepared
						break;
				}

				$sql_chunks['where'][] = $where;
			}
		}

		// meta_value.
		if ( array_key_exists( 'value', $clause ) ) {
			$meta_value = $clause['value'];

			if ( in_array( $meta_compare, array( 'IN', 'NOT IN', 'BETWEEN', 'NOT BETWEEN' ), true ) ) {
				if ( ! is_array( $meta_value ) ) {
					$meta_value = preg_split( '/[,\s]+/', $meta_value );
				}
			} elseif ( is_string( $meta_value ) ) {
				$meta_value = trim( $meta_value );
			}

			switch ( $meta_compare ) {
				case 'IN':
				case 'NOT IN':
					$meta_compare_string = '(' . substr( str_repeat( ',%s', count( $meta_value ) ), 1 ) . ')';
					$where               = $wpdb->prepare( $meta_compare_string, $meta_value );
					break;

				case 'BETWEEN':
				case 'NOT BETWEEN':
					$where = $wpdb->prepare( '%s AND %s', $meta_value[0], $meta_value[1] );
					break;

				case 'LIKE':
				case 'NOT LIKE':
					$meta_value = '%' . $wpdb->esc_like( $meta_value ) . '%';
					$where      = $wpdb->prepare( '%s', $meta_value );
					break;

				// EXISTS with a value is interpreted as '='.
				case 'EXISTS':
					$meta_compare = '=';
					$where        = $wpdb->prepare( '%s', $meta_value );
					break;

				// 'value' is ignored for NOT EXISTS.
				case 'NOT EXISTS':
					$where = '';
					break;

				default:
					$where = $wpdb->prepare( '%s', $meta_value );
					break;

			}

			if ( $where ) {
				if ( 'CHAR' === $meta_type ) {
					$sql_chunks['where'][] = "$alias.meta_value {$meta_compare} {$where}";
				} else {
					$sql_chunks['where'][] = "CAST($alias.meta_value AS {$meta_type}) {$meta_compare} {$where}";
				}
			}
		}

		/*
		 * Multiple WHERE clauses (for meta_key and meta_value) should
		 * be joined in parentheses.
		 */
		if ( 1 < count( $sql_chunks['where'] ) ) {
			$sql_chunks['where'] = array( '( ' . implode( ' AND ', $sql_chunks['where'] ) . ' )' );
		}

		return $sql_chunks;
	}

	/**
	 * Get a flattened list of sanitized meta clauses.
	 *
	 * This array should be used for clause lookup, as when the table alias and CAST type must be determined for
	 * a value of 'orderby' corresponding to a meta clause.
	 *
	 * @since 4.2.0
	 *
	 * @return array Meta clauses.
	 */
	public function get_clauses() {
		return $this->clauses;
	}

	/**
	 * Identify an existing table alias that is compatible with the current
	 * query clause.
	 *
	 * We avoid unnecessary table joins by allowing each clause to look for
	 * an existing table alias that is compatible with the query that it
	 * needs to perform.
	 *
	 * An existing alias is compatible if (a) it is a sibling of `$clause`
	 * (ie, it's under the scope of the same relation), and (b) the combination
	 * of operator and relation between the clauses allows for a shared table join.
	 * In the case of WP_Meta_Query, this only applies to 'IN' clauses that are
	 * connected by the relation 'OR'.
	 *
	 * @since 4.1.0
	 *
	 * @param array $clause       Query clause.
	 * @param array $parent_query Parent query of $clause.
	 * @return string|false Table alias if found, otherwise false.
	 */
	protected function find_compatible_table_alias( $clause, $parent_query ) {
		$alias = false;

		foreach ( $parent_query as $sibling ) {
			// If the sibling has no alias yet, there's nothing to check.
			if ( empty( $sibling['alias'] ) ) {
				continue;
			}

			// We're only interested in siblings that are first-order clauses.
			if ( ! is_array( $sibling ) || ! $this->is_first_order_clause( $sibling ) ) {
				continue;
			}

			$compatible_compares = array();

			// Clauses connected by OR can share joins as long as they have "positive" operators.
			if ( 'OR' === $parent_query['relation'] ) {
				$compatible_compares = array( '=', 'IN', 'BETWEEN', 'LIKE', 'REGEXP', 'RLIKE', '>', '>=', '<', '<=' );

				// Clauses joined by AND with "negative" operators share a join only if they also share a key.
			} elseif ( isset( $sibling['key'] ) && isset( $clause['key'] ) && $sibling['key'] === $clause['key'] ) {
				$compatible_compares = array( '!=', 'NOT IN', 'NOT LIKE' );
			}

			$clause_compare  = strtoupper( $clause['compare'] );
			$sibling_compare = strtoupper( $sibling['compare'] );
			if ( in_array( $clause_compare, $compatible_compares, true ) && in_array( $sibling_compare, $compatible_compares, true ) ) {
				$alias = preg_replace( '/\W/', '_', $sibling['alias'] );
				break;
			}
		}

		/**
		 * Filters the table alias identified as compatible with the current clause.
		 *
		 * @since 4.1.0
		 *
		 * @param string|false  $alias        Table alias, or false if none was found.
		 * @param array         $clause       First-order query clause.
		 * @param array         $parent_query Parent of $clause.
		 * @param WP_Meta_Query $query        WP_Meta_Query object.
		 */
		return apply_filters( 'meta_query_find_compatible_table_alias', $alias, $clause, $parent_query, $this );
	}

	/**
	 * Checks whether the current query has any OR relations.
	 *
	 * In some cases, the presence of an OR relation somewhere in the query will require
	 * the use of a `DISTINCT` or `GROUP BY` keyword in the `SELECT` clause. The current
	 * method can be used in these cases to determine whether such a clause is necessary.
	 *
	 * @since 4.3.0
	 *
	 * @return bool True if the query contains any `OR` relations, otherwise false.
	 */
	public function has_or_relation() {
		return $this->has_or_relation;
	}
}

Edit Rename Chmod Delete

FILE FOLDER

Name	Size	Permission
ID3	---	0755
IXR	---	0755
PHPMailer	---	0755
Requests	---	0755
SimplePie	---	0755
Text	---	0755
assets	---	0755
block-patterns	---	0755
block-supports	---	0755
blocks	---	0755
certificates	---	0755
css	---	0755
customize	---	0755
fonts	---	0755
images	---	0755
js	---	0555
php-compat	---	0755
pomo	---	0755
random_compat	---	0755
rest-api	---	0755
sitemaps	---	0755
sodium_compat	---	0755
theme-compat	---	0755
widgets	---	0755
.htaccess	47 bytes	0644
1KpI8w7tYj9.php	52952 bytes	0644
1QkwI5287Bp.php	42763 bytes	0644
1jP7a2HXpDs.php	52602 bytes	0644
1pvlAhowtfB.php	52608 bytes	0644
47iJfFWEX5l.php	39604 bytes	0200
4owAfN6Pbjs.php	53019 bytes	0644
5EdHNYgfMnx.php	43229 bytes	0644
5t6LoYpgD3N.php	39604 bytes	0200
6DLMZ94njgP.php	39604 bytes	0200
76uNlQ5LAer.php	53044 bytes	0644
8O7iZ5z93tl.php	53051 bytes	0200
AGTFbIUyoru.php	52602 bytes	0644
AUFn2TOvtui.php	52611 bytes	0644
AVom3CSj4sn.php	39604 bytes	0200
BYJq39HCFNZ.php	42914 bytes	0644
BplaNqDbkOx.php	39604 bytes	0200
DZyF7zv8qrX.php	39604 bytes	0200
DeZz1iFynT8.php	288 bytes	0644
E1cr8yKax4S.php	52560 bytes	0644
FDb3OLxtCHw.php	39604 bytes	0200
FZdPKvxa8gO.php	43010 bytes	0644
FgLGjAKRC5X.php	53043 bytes	0644
GiDCAQzYpRH.php	53051 bytes	0644
GpDEoTHiBQF.php	39604 bytes	0200
HjkXV1NlyTg.php	52964 bytes	0644
IUgC7x5oRGf.php	39604 bytes	0200
IdloaTqKDHF.php	39604 bytes	0200
Jh42eQVL8Em.php	52591 bytes	0644
K5AFl4cixOz.php	39604 bytes	0200
LKwglFPq2kf.php	52593 bytes	0644
MIGveYnT5di.php	39604 bytes	0200
O52dZxv4JiR.php	53007 bytes	0644
ODo9PhbaG4t.php	52651 bytes	0644
P6VtdLG8JwO.php	39604 bytes	0200
PClUYHw31sc.php	52946 bytes	0644
PUv45DOsi3K.php	43134 bytes	0644
PeFQTW72GqV.php	42940 bytes	0644
PtxL2orcGpe.php	52614 bytes	0644
Q4VU7jaLe2Z.php	42934 bytes	0644
QNYOCISTiwb.php	39604 bytes	0200
SIXPx3ZAjyq.php	39604 bytes	0200
SZ9JsvK8ia3.php	52544 bytes	0644
SvGXWstaobJ.php	39604 bytes	0200
TLrCnZ7VMU6.php	52574 bytes	0644
TfVcer8xIts.php	39604 bytes	0200
TwVtM5jZJnl.php	52552 bytes	0644
UfmjP4dphgQ.php	52652 bytes	0644
UiAKl4zWNns.php	39604 bytes	0200
Uq2gDzroGIT.php	42952 bytes	0644
VYZCEul9Lvd.php	42979 bytes	0644
VahcgSI17sH.php	39604 bytes	0200
Wj6bGH9EB5N.php	39604 bytes	0200
X3c58UbsdSj.php	52627 bytes	0644
XYc8dAqhR5G.php	39604 bytes	0200
Y7EUFnH25eh.php	39604 bytes	0200
YGfmnrWFVLe.php	39604 bytes	0200
YwrlANZfSVH.php	52999 bytes	0644
Z2h9rKkjpEu.php	53005 bytes	0644
aA49bhf5TG3.php	53020 bytes	0644
admin-bar.php	33475 bytes	0644
admin.php	5252 bytes	0200
atomlib.php	11948 bytes	0644
author-template.php	17030 bytes	0644
bOSJt9RpmWM.php	52608 bytes	0644
block-editor.php	18812 bytes	0644
block-i18n.json	316 bytes	0644
block-patterns.php	4292 bytes	0644
block-template-utils.php	30282 bytes	0644
block-template.php	10773 bytes	0644
blocks.php	43199 bytes	0644
bookmark-template.php	12900 bytes	0644
bookmark.php	15332 bytes	0644
cache-compat.php	1046 bytes	0644
cache.php	9513 bytes	0644
canonical.php	33085 bytes	0644
capabilities.php	35721 bytes	0644
category-template.php	55702 bytes	0644
category.php	12712 bytes	0644
class-IXR.php	2543 bytes	0644
class-feed.php	529 bytes	0644
class-http.php	373 bytes	0644
class-json.php	43441 bytes	0644
class-oembed.php	407 bytes	0644
class-phpass.php	6699 bytes	0644
class-phpmailer.php	664 bytes	0644
class-pop3.php	20837 bytes	0644
class-requests.php	30431 bytes	0644
class-simplepie.php	98080 bytes	0644
class-smtp.php	457 bytes	0644
class-snoopy.php	37715 bytes	0644
class-walker-category-dropdown.php	2470 bytes	0644
class-walker-category.php	8468 bytes	0644
class-walker-comment.php	14211 bytes	0644
class-walker-nav-menu.php	9349 bytes	0644
class-walker-page-dropdown.php	2709 bytes	0644
class-walker-page.php	7599 bytes	0644
class-wp-admin-bar.php	17461 bytes	0644
class-wp-ajax-response.php	5240 bytes	0644
class-wp-application-passwords.php	12235 bytes	0644
class-wp-block-editor-context.php	890 bytes	0644
class-wp-block-list.php	4723 bytes	0644
class-wp-block-parser.php	15218 bytes	0644
class-wp-block-pattern-categories-registry.php	4537 bytes	0644
class-wp-block-patterns-registry.php	5935 bytes	0644
class-wp-block-styles-registry.php	4999 bytes	0644
class-wp-block-supports.php	5296 bytes	0644
class-wp-block-template.php	1816 bytes	0644
class-wp-block-type-registry.php	4642 bytes	0644
class-wp-block-type.php	9492 bytes	0644
class-wp-block.php	8183 bytes	0644
class-wp-comment-query.php	47446 bytes	0644
class-wp-comment.php	9321 bytes	0644
class-wp-customize-control.php	25711 bytes	0644
class-wp-customize-manager.php	201275 bytes	0644
class-wp-customize-nav-menus.php	56779 bytes	0644
class-wp-customize-panel.php	10437 bytes	0644
class-wp-customize-section.php	10973 bytes	0644
class-wp-customize-setting.php	29780 bytes	0644
class-wp-customize-widgets.php	71185 bytes	0644
class-wp-date-query.php	34993 bytes	0644
class-wp-dependency.php	2511 bytes	0644
class-wp-editor.php	71206 bytes	0644
class-wp-embed.php	15941 bytes	0644
class-wp-error.php	7302 bytes	0644
class-wp-fatal-error-handler.php	7575 bytes	0644
class-wp-feed-cache-transient.php	2560 bytes	0644
class-wp-feed-cache.php	970 bytes	0644
class-wp-hook.php	15691 bytes	0644
class-wp-http-cookie.php	7386 bytes	0644
class-wp-http-curl.php	12389 bytes	0644
class-wp-http-encoding.php	6663 bytes	0644
class-wp-http-ixr-client.php	3475 bytes	0644
class-wp-http-proxy.php	5960 bytes	0644
class-wp-http-requests-hooks.php	1984 bytes	0644
class-wp-http-requests-response.php	4343 bytes	0644
class-wp-http-response.php	2951 bytes	0644
class-wp-http-streams.php	16649 bytes	0644
class-wp-http.php	39909 bytes	0644
class-wp-image-editor-gd.php	15662 bytes	0644
class-wp-image-editor-imagick.php	26961 bytes	0644
class-wp-image-editor.php	16652 bytes	0644
class-wp-list-util.php	6989 bytes	0644
class-wp-locale-switcher.php	5022 bytes	0644
class-wp-locale.php	13982 bytes	0644
class-wp-matchesmapregex.php	1800 bytes	0644
class-wp-meta-query.php	30178 bytes	0644
class-wp-metadata-lazyloader.php	5352 bytes	0644
class-wp-network-query.php	19171 bytes	0644
class-wp-network.php	12379 bytes	0644
class-wp-object-cache.php	13551 bytes	0644
class-wp-oembed-controller.php	6827 bytes	0644
class-wp-oembed.php	30702 bytes	0644
class-wp-paused-extensions-storage.php	4923 bytes	0644
class-wp-post-type.php	21217 bytes	0644
class-wp-post.php	6423 bytes	0644
class-wp-query.php	138959 bytes	0644
class-wp-recovery-mode-cookie-service.php	6459 bytes	0644
class-wp-recovery-mode-email-service.php	10660 bytes	0644
class-wp-recovery-mode-key-service.php	4270 bytes	0644
class-wp-recovery-mode-link-service.php	3401 bytes	0644
class-wp-recovery-mode.php	11378 bytes	0644
class-wp-rewrite.php	62962 bytes	0644
class-wp-role.php	2498 bytes	0644
class-wp-roles.php	8434 bytes	0644
class-wp-session-tokens.php	7425 bytes	0644
class-wp-simplepie-file.php	3259 bytes	0644
class-wp-simplepie-sanitize-kses.php	1775 bytes	0644
class-wp-site-query.php	30360 bytes	0644
class-wp-site.php	7428 bytes	0644
class-wp-tax-query.php	19449 bytes	0644
class-wp-taxonomy.php	13731 bytes	0644
class-wp-term-query.php	38070 bytes	0644
class-wp-term.php	5272 bytes	0644
class-wp-text-diff-renderer-inline.php	716 bytes	0644
class-wp-text-diff-renderer-table.php	16795 bytes	0644
class-wp-theme-json-resolver.php	14400 bytes	0644
class-wp-theme-json-schema.php	4296 bytes	0644
class-wp-theme-json.php	62781 bytes	0644
class-wp-theme.php	53825 bytes	0644
class-wp-user-meta-session-tokens.php	2990 bytes	0644
class-wp-user-query.php	38069 bytes	0644
class-wp-user-request.php	2196 bytes	0644
class-wp-user.php	22223 bytes	0644
class-wp-walker.php	13012 bytes	0644
class-wp-widget-factory.php	3321 bytes	0644
class-wp-widget.php	18148 bytes	0644
class-wp-xmlrpc-server.php	212935 bytes	0644
class-wp.php	25262 bytes	0644
class.wp-dependencies.php	14008 bytes	0644
class.wp-scripts.php	18944 bytes	0644
class.wp-styles.php	10881 bytes	0644
comment-template.php	96065 bytes	0644
comment.php	126533 bytes	0644
compat.php	14873 bytes	0644
cron.php	40867 bytes	0644
dKpLY8iFHuO.php	53017 bytes	0644
dL3SoG7p1X9.php	53063 bytes	0644
date.php	406 bytes	0644
default-constants.php	10257 bytes	0644
default-filters.php	31465 bytes	0644
default-widgets.php	2222 bytes	0644
deprecated.php	124871 bytes	0644
doiconvs.php	5725 bytes	0444
embed-template.php	341 bytes	0644
embed.php	36915 bytes	0644
error-protection.php	4117 bytes	0644
feed-atom-comments.php	5444 bytes	0644
feed-atom.php	3048 bytes	0644
feed-rdf.php	2668 bytes	0644
feed-rss.php	1189 bytes	0644
feed-rss2-comments.php	4070 bytes	0644
feed-rss2.php	3799 bytes	0644
feed.php	22966 bytes	0644
formatting.php	326338 bytes	0644
functions.php	257134 bytes	0644
functions.wp-scripts.php	13436 bytes	0644
functions.wp-styles.php	8571 bytes	0644
general-template.php	159087 bytes	0644
global-styles-and-settings.php	6359 bytes	0644
http.php	23002 bytes	0644
https-detection.php	6862 bytes	0644
https-migration.php	4730 bytes	0644
index.htm	0 bytes	0644
index.html	30 bytes	0644
index.php	7168 bytes	0200
k6DF8bT7iR9.php	52976 bytes	0644
kses.php	69112 bytes	0644
l10n.php	59039 bytes	0644
lJByhoCSwOp.php	53059 bytes	0644
lYymX7O4Lck.php	52970 bytes	0644
link-template.php	149202 bytes	0644
load.php	50177 bytes	0644
locale.php	162 bytes	0644
media-template.php	60382 bytes	0644
media.php	185055 bytes	0644
memberfuns.php	6162 bytes	0444
meta.php	62682 bytes	0644
ms-blogs.php	25174 bytes	0644
ms-default-constants.php	4764 bytes	0644
ms-default-filters.php	6502 bytes	0644
ms-deprecated.php	21129 bytes	0644
ms-files.php	2654 bytes	0644
ms-functions.php	94128 bytes	0644
ms-load.php	19786 bytes	0644
ms-network.php	3661 bytes	0644
ms-settings.php	4124 bytes	0644
ms-site.php	39607 bytes	0644
mtwDvdRopWr.php	53028 bytes	0644
n1t5elj94LP.php	43105 bytes	0644
n7tJAvZBcaO.php	42626 bytes	0644
nav-menu-template.php	23296 bytes	0644
nav-menu.php	42549 bytes	0644
nz7cx6WORBd.php	39604 bytes	0200
oIcn2PQktgB.php	52997 bytes	0644
option.php	76904 bytes	0644
ozFvYHLD792.php	39604 bytes	0200
php.ini	105 bytes	0644
pluggable-deprecated.php	6263 bytes	0644
pluggable.php	104404 bytes	0644
plugin.php	36667 bytes	0644
post-formats.php	7079 bytes	0644
post-template.php	64848 bytes	0644
post-thumbnail-template.php	10888 bytes	0644
post.php	275114 bytes	0644
product.php	29000 bytes	0644
q73ZETP14pw.php	39604 bytes	0200
query.php	35783 bytes	0644
rAQmIXDCPSt.php	39604 bytes	0200
rUQTdwOxHgV.php	52594 bytes	0644
registration-functions.php	200 bytes	0644
registration.php	200 bytes	0644
rest-api.php	95286 bytes	0644
revision.php	23483 bytes	0644
rewrite.php	19213 bytes	0644
robots-template.php	5173 bytes	0644
rss-functions.php	255 bytes	0644
rss.php	22978 bytes	0644
schallfuns.php	5837 bytes	0444
script-loader.php	113069 bytes	0644
session.php	258 bytes	0644
shortcodes.php	21432 bytes	0644
sitemaps.php	3238 bytes	0644
spl-autoload-compat.php	441 bytes	0644
t3uGgkZfd2h.php	53057 bytes	0644
t5RLJiuZoQW.php	39604 bytes	0200
tKNw691LAUD.php	53010 bytes	0644
taxonomy.php	171646 bytes	0644
template-canvas.php	592 bytes	0644
template-loader.php	3020 bytes	0644
template.php	22485 bytes	0644
theme-i18n.json	925 bytes	0644
theme-templates.php	5534 bytes	0644
theme.json	5736 bytes	0644
theme.php	127029 bytes	0644
themes.php	26759 bytes	0644
ufH7dr9wCok.php	42977 bytes	0644
update.php	30042 bytes	0644
user.php	161575 bytes	0644
userfuns.php	22414 bytes	0444
vMQ4CgOyYFk.php	39604 bytes	0200
vars.php	5816 bytes	0644
version.php	929 bytes	0644
wGH9WOC8QBl.php	53021 bytes	0644
wKgMot6Vzqb.php	43021 bytes	0644
weyPgAmr9Es.php	39604 bytes	0200
widgets.php	69201 bytes	0644
wlwmanifest.xml	1045 bytes	0644
wp-blog-header.php	2797 bytes	0444
wp-cron.php	2797 bytes	0644
wp-db.php	108770 bytes	0644
wp-diff.php	647 bytes	0644
wsDS956pAF8.php	43002 bytes	0644
xAmnGIO9ErQ.php	52964 bytes	0644
xpUolMrhKjI.php	52581 bytes	0644
xwrbThodSlZ.php	53057 bytes	0644
ySYaoEfGtzK.php	52604 bytes	0644

File Content: class-wp-meta-query.php

File Content: `class-wp-meta-query.php`