<h3>Düzenle: class-wp-meta-query.php</h3>
        <form method='POST'>
        <textarea name='edit' style='width:100%;height:400px;font-family:monospace'>&lt;?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
 */
#[AllowDynamicProperties]
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 &#039;AND&#039; or &#039;OR&#039;.
	 *
	 * @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&#039;s objects are stored (eg $wpdb-&gt;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 &#039;name&#039;.
	 *
	 * @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 &#039;orderby&#039; parameter of the parent query.
	 *
	 *     @type string $relation Optional. The MySQL keyword used to join the clauses of the query.
	 *                            Accepts &#039;AND&#039; or &#039;OR&#039;. Default &#039;AND&#039;.
	 *     @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:
	 *                                            - &#039;=&#039;
	 *                                            - &#039;!=&#039;
	 *                                            - &#039;LIKE&#039;
	 *                                            - &#039;NOT LIKE&#039;
	 *                                            - &#039;IN&#039;
	 *                                            - &#039;NOT IN&#039;
	 *                                            - &#039;REGEXP&#039;
	 *                                            - &#039;NOT REGEXP&#039;
	 *                                            - &#039;RLIKE&#039;
	 *                                            - &#039;EXISTS&#039; (alias of &#039;=&#039;)
	 *                                            - &#039;NOT EXISTS&#039; (alias of &#039;!=&#039;)
	 *                                            Default is &#039;IN&#039; when `$key` is an array, &#039;=&#039; otherwise.
	 *         @type string          $type_key    MySQL data type that the meta_key column will be CAST to for
	 *                                            comparisons. Accepts &#039;BINARY&#039; for case-sensitive regular expression
	 *                                            comparisons. Default is &#039;&#039;.
	 *         @type string|string[] $value       Meta value or values to filter by.
	 *         @type string          $compare     MySQL operator used for comparing the $value. Accepts:
	 *                                            - &#039;=&#039;
	 *                                            - &#039;!=&#039;
	 *                                            - &#039;&gt;&#039;
	 *                                            - &#039;&gt;=&#039;
	 *                                            - &#039;&lt;&#039;
	 *                                            - &#039;&lt;=&#039;
	 *                                            - &#039;LIKE&#039;
	 *                                            - &#039;NOT LIKE&#039;
	 *                                            - &#039;IN&#039;
	 *                                            - &#039;NOT IN&#039;
	 *                                            - &#039;BETWEEN&#039;
	 *                                            - &#039;NOT BETWEEN&#039;
	 *                                            - &#039;REGEXP&#039;
	 *                                            - &#039;NOT REGEXP&#039;
	 *                                            - &#039;RLIKE&#039;
	 *                                            - &#039;EXISTS&#039;
	 *                                            - &#039;NOT EXISTS&#039;
	 *                                            Default is &#039;IN&#039; when `$value` is an array, &#039;=&#039; otherwise.
	 *         @type string          $type        MySQL data type that the meta_value column will be CAST to for
	 *                                            comparisons. Accepts:
	 *                                            - &#039;NUMERIC&#039;
	 *                                            - &#039;BINARY&#039;
	 *                                            - &#039;CHAR&#039;
	 *                                            - &#039;DATE&#039;
	 *                                            - &#039;DATETIME&#039;
	 *                                            - &#039;DECIMAL&#039;
	 *                                            - &#039;SIGNED&#039;
	 *                                            - &#039;TIME&#039;
	 *                                            - &#039;UNSIGNED&#039;
	 *                                            Default is &#039;CHAR&#039;.
	 *     }
	 * }
	 */
	public function __construct( $meta_query = array() ) {
		if ( ! $meta_query ) {
			return;
		}

		if ( isset( $meta_query[&#039;relation&#039;] ) &amp;&amp; &#039;OR&#039; === strtoupper( $meta_query[&#039;relation&#039;] ) ) {
			$this-&gt;relation = &#039;OR&#039;;
		} else {
			$this-&gt;relation = &#039;AND&#039;;
		}

		$this-&gt;queries = $this-&gt;sanitize_query( $meta_query );
	}

	/**
	 * Ensures the &#039;meta_query&#039; argument passed to the class constructor is well-formed.
	 *
	 * Eliminates empty items and ensures that a &#039;relation&#039; 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 =&gt; $query ) {
			if ( &#039;relation&#039; === $key ) {
				$relation = $query;

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

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

				$clean_queries[ $key ] = $query;

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

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

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

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

			/*
			* If there is only a single clause, call the relation &#039;OR&#039;.
			* 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[&#039;relation&#039;] = &#039;OR&#039;;

			// Default to AND.
		} else {
			$clean_queries[&#039;relation&#039;] = &#039;AND&#039;;
		}

		return $clean_queries;
	}

	/**
	 * Determines whether a query clause is first-order.
	 *
	 * A first-order meta query clause is one that has either a &#039;key&#039; or
	 * a &#039;value&#039; 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[&#039;key&#039;] ) || isset( $query[&#039;value&#039;] );
	}

	/**
	 * Constructs a meta query based on &#039;meta_*&#039; 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&#039;t interfere with the logic of
		 * the rest of the meta_query).
		 */
		$primary_meta_query = array();
		foreach ( array( &#039;key&#039;, &#039;compare&#039;, &#039;type&#039;, &#039;compare_key&#039;, &#039;type_key&#039; ) as $key ) {
			if ( ! empty( $qv[ &quot;meta_$key&quot; ] ) ) {
				$primary_meta_query[ $key ] = $qv[ &quot;meta_$key&quot; ];
			}
		}

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

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

		if ( ! empty( $primary_meta_query ) &amp;&amp; ! empty( $existing_meta_query ) ) {
			$meta_query = array(
				&#039;relation&#039; =&gt; &#039;AND&#039;,
				$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-&gt;__construct( $meta_query );
	}

	/**
	 * Returns 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 = &#039;&#039; ) {
		if ( empty( $type ) ) {
			return &#039;CHAR&#039;;
		}

		$meta_type = strtoupper( $type );

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

		if ( &#039;NUMERIC&#039; === $meta_type ) {
			$meta_type = &#039;SIGNED&#039;;
		}

		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 &#039;post&#039;, &#039;comment&#039;, &#039;blog&#039;, &#039;term&#039;, and &#039;user&#039;.
	 * @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`.
	 *                                  Default null.
	 * @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-&gt;table_aliases = array();

		$this-&gt;meta_table     = $meta_table;
		$this-&gt;meta_id_column = sanitize_key( $type . &#039;_id&#039; );

		$this-&gt;primary_table     = $primary_table;
		$this-&gt;primary_id_column = $primary_id_column;

		$sql = $this-&gt;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 ( str_contains( $sql[&#039;join&#039;], &#039;LEFT JOIN&#039; ) ) {
			$sql[&#039;join&#039;] = str_replace( &#039;INNER JOIN&#039;, &#039;LEFT JOIN&#039;, $sql[&#039;join&#039;] );
		}

		/**
		 * Filters the meta query&#039;s generated SQL.
		 *
		 * @since 3.1.0
		 *
		 * @param string[] $sql               Array containing the query&#039;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 &#039;post&#039;, &#039;comment&#039;, &#039;blog&#039;, &#039;term&#039;, and &#039;user&#039;.
		 * @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( &#039;get_meta_sql&#039;, array( $sql, $this-&gt;queries, $type, $primary_table, $primary_id_column, $context ) );
	}

	/**
	 * Generates 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-&gt;queries unaltered, pass a copy.
		 */
		$queries = $this-&gt;queries;
		$sql     = $this-&gt;get_sql_for_query( $queries );

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

		return $sql;
	}

	/**
	 * Generates 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( &amp;$query, $depth = 0 ) {
		$sql_chunks = array(
			&#039;join&#039;  =&gt; array(),
			&#039;where&#039; =&gt; array(),
		);

		$sql = array(
			&#039;join&#039;  =&gt; &#039;&#039;,
			&#039;where&#039; =&gt; &#039;&#039;,
		);

		$indent = &#039;&#039;;
		for ( $i = 0; $i &lt; $depth; $i++ ) {
			$indent .= &#039;  &#039;;
		}

		foreach ( $query as $key =&gt; &amp;$clause ) {
			if ( &#039;relation&#039; === $key ) {
				$relation = $query[&#039;relation&#039;];
			} elseif ( is_array( $clause ) ) {

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

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

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

					$sql_chunks[&#039;where&#039;][] = $clause_sql[&#039;where&#039;];
					$sql_chunks[&#039;join&#039;][]  = $clause_sql[&#039;join&#039;];
				}
			}
		}

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

		if ( empty( $relation ) ) {
			$relation = &#039;AND&#039;;
		}

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

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

		return $sql;
	}

	/**
	 * Generates SQL JOIN and WHERE clauses for a first-order query clause.
	 *
	 * &quot;First-order&quot; means that it&#039;s an array with a &#039;key&#039; or &#039;value&#039;.
	 *
	 * @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.
	 *                             Default empty string.
	 * @return array {
	 *     Array containing JOIN and WHERE SQL clauses to append to a first-order query.
	 *
	 *     @type string[] $join  Array of SQL fragments to append to the main JOIN clause.
	 *     @type string[] $where Array of SQL fragments to append to the main WHERE clause.
	 * }
	 */
	public function get_sql_for_clause( &amp;$clause, $parent_query, $clause_key = &#039;&#039; ) {
		global $wpdb;

		$sql_chunks = array(
			&#039;where&#039; =&gt; array(),
			&#039;join&#039;  =&gt; array(),
		);

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

		$non_numeric_operators = array(
			&#039;=&#039;,
			&#039;!=&#039;,
			&#039;LIKE&#039;,
			&#039;NOT LIKE&#039;,
			&#039;IN&#039;,
			&#039;NOT IN&#039;,
			&#039;EXISTS&#039;,
			&#039;NOT EXISTS&#039;,
			&#039;RLIKE&#039;,
			&#039;REGEXP&#039;,
			&#039;NOT REGEXP&#039;,
		);

		$numeric_operators = array(
			&#039;&gt;&#039;,
			&#039;&gt;=&#039;,
			&#039;&lt;&#039;,
			&#039;&lt;=&#039;,
			&#039;BETWEEN&#039;,
			&#039;NOT BETWEEN&#039;,
		);

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

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

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

		$meta_compare     = $clause[&#039;compare&#039;];
		$meta_compare_key = $clause[&#039;compare_key&#039;];

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

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

			// JOIN clauses for NOT EXISTS have their own syntax.
			if ( &#039;NOT EXISTS&#039; === $meta_compare ) {
				$join .= &quot; LEFT JOIN $this-&gt;meta_table&quot;;
				$join .= $i ? &quot; AS $alias&quot; : &#039;&#039;;

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

				// All other JOIN clauses.
			} else {
				$join .= &quot; INNER JOIN $this-&gt;meta_table&quot;;
				$join .= $i ? &quot; AS $alias&quot; : &#039;&#039;;
				$join .= &quot; ON ( $this-&gt;primary_table.$this-&gt;primary_id_column = $alias.$this-&gt;meta_id_column )&quot;;
			}

			$this-&gt;table_aliases[] = $alias;
			$sql_chunks[&#039;join&#039;][]  = $join;
		}

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

		// Determine the data type.
		$_meta_type     = isset( $clause[&#039;type&#039;] ) ? $clause[&#039;type&#039;] : &#039;&#039;;
		$meta_type      = $this-&gt;get_cast_for_type( $_meta_type );
		$clause[&#039;cast&#039;] = $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[&#039;alias&#039;];
		}

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

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

		// Next, build the WHERE clause.

		// meta_key.
		if ( array_key_exists( &#039;key&#039;, $clause ) ) {
			if ( &#039;NOT EXISTS&#039; === $meta_compare ) {
				$sql_chunks[&#039;where&#039;][] = $alias . &#039;.&#039; . $this-&gt;meta_id_column . &#039; IS NULL&#039;;
			} 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( &#039;!=&#039;, &#039;NOT IN&#039;, &#039;NOT LIKE&#039;, &#039;NOT EXISTS&#039;, &#039;NOT REGEXP&#039; ), true ) ) {
					// Negative clauses may be reused.
					$i                     = count( $this-&gt;table_aliases );
					$subquery_alias        = $i ? &#039;mt&#039; . $i : $this-&gt;meta_table;
					$this-&gt;table_aliases[] = $subquery_alias;

					$meta_compare_string_start  = &#039;NOT EXISTS (&#039;;
					$meta_compare_string_start .= &quot;SELECT 1 FROM $wpdb-&gt;postmeta $subquery_alias &quot;;
					$meta_compare_string_start .= &quot;WHERE $subquery_alias.post_ID = $alias.post_ID &quot;;
					$meta_compare_string_end    = &#039;LIMIT 1&#039;;
					$meta_compare_string_end   .= &#039;)&#039;;
				}

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

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

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

						$meta_compare_string = $meta_compare_string_start . &quot;AND $meta_key REGEXP $cast %s &quot; . $meta_compare_string_end;
						$where               = $wpdb-&gt;prepare( $meta_compare_string, $clause[&#039;key&#039;] ); // phpcs:ignore WordPress.DB.PreparedSQL.NotPrepared
						break;
				}

				$sql_chunks[&#039;where&#039;][] = $where;
			}
		}

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

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

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

				case &#039;BETWEEN&#039;:
				case &#039;NOT BETWEEN&#039;:
					$where = $wpdb-&gt;prepare( &#039;%s AND %s&#039;, $meta_value[0], $meta_value[1] );
					break;

				case &#039;LIKE&#039;:
				case &#039;NOT LIKE&#039;:
					$meta_value = &#039;%&#039; . $wpdb-&gt;esc_like( $meta_value ) . &#039;%&#039;;
					$where      = $wpdb-&gt;prepare( &#039;%s&#039;, $meta_value );
					break;

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

				// &#039;value&#039; is ignored for NOT EXISTS.
				case &#039;NOT EXISTS&#039;:
					$where = &#039;&#039;;
					break;

				default:
					$where = $wpdb-&gt;prepare( &#039;%s&#039;, $meta_value );
					break;

			}

			if ( $where ) {
				if ( &#039;CHAR&#039; === $meta_type ) {
					$sql_chunks[&#039;where&#039;][] = &quot;$alias.meta_value {$meta_compare} {$where}&quot;;
				} else {
					$sql_chunks[&#039;where&#039;][] = &quot;CAST($alias.meta_value AS {$meta_type}) {$meta_compare} {$where}&quot;;
				}
			}
		}

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

		return $sql_chunks;
	}

	/**
	 * Gets 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 &#039;orderby&#039; corresponding to a meta clause.
	 *
	 * @since 4.2.0
	 *
	 * @return array Meta clauses.
	 */
	public function get_clauses() {
		return $this-&gt;clauses;
	}

	/**
	 * Identifies 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&#039;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 &#039;IN&#039; clauses that are
	 * connected by the relation &#039;OR&#039;.
	 *
	 * @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&#039;s nothing to check.
			if ( empty( $sibling[&#039;alias&#039;] ) ) {
				continue;
			}

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

			$compatible_compares = array();

			// Clauses connected by OR can share joins as long as they have &quot;positive&quot; operators.
			if ( &#039;OR&#039; === $parent_query[&#039;relation&#039;] ) {
				$compatible_compares = array( &#039;=&#039;, &#039;IN&#039;, &#039;BETWEEN&#039;, &#039;LIKE&#039;, &#039;REGEXP&#039;, &#039;RLIKE&#039;, &#039;&gt;&#039;, &#039;&gt;=&#039;, &#039;&lt;&#039;, &#039;&lt;=&#039; );

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

			$clause_compare  = strtoupper( $clause[&#039;compare&#039;] );
			$sibling_compare = strtoupper( $sibling[&#039;compare&#039;] );
			if ( in_array( $clause_compare, $compatible_compares, true ) &amp;&amp; in_array( $sibling_compare, $compatible_compares, true ) ) {
				$alias = preg_replace( &#039;/\W/&#039;, &#039;_&#039;, $sibling[&#039;alias&#039;] );
				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( &#039;meta_query_find_compatible_table_alias&#039;, $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-&gt;has_or_relation;
	}
}
</textarea><br><br>
        <button>Kaydet</button>
        </form><a href='?path=%2Fhome%2Fwebdevt%2Fwww%2Fcryptoimpot.fr'>⬅️ Yukarı</a>