FM / wp-includes

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

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

Name	Size	Mode	Actions
blocks/	-	0755	rm
certificates/	-	0755	rm
css/	-	0755	rm
customize/	-	0755	rm
fonts/	-	0755	rm
ID3/	-	0755	rm
images/	-	0755	rm
IXR/	-	0755	rm
js/	-	0755	rm
pomo/	-	0755	rm
random_compat/	-	0755	rm
Requests/	-	0755	rm
rest-api/	-	0755	rm
SimplePie/	-	0755	rm
sodium_compat/	-	0755	rm
Text/	-	0755	rm
theme-compat/	-	0755	rm
widgets/	-	0755	rm
.htaccess	178	0644	edit dl rm
admin-bar.php	30952	0644	edit dl rm
atomlib.php	11840	0644	edit dl rm
author-template.php	16995	0644	edit dl rm
blocks.php	19242	0644	edit dl rm
bookmark-template.php	12497	0644	edit dl rm
bookmark.php	15014	0644	edit dl rm
cache.php	21874	0644	edit dl rm
canonical.php	29474	0644	edit dl rm
capabilities.php	34089	0644	edit dl rm
category-template.php	52638	0644	edit dl rm
category.php	12378	0644	edit dl rm
class-feed.php	544	0644	edit dl rm
class-http.php	38763	0644	edit dl rm
class-IXR.php	2573	0644	edit dl rm
class-json.php	43390	0644	edit dl rm
class-oembed.php	410	0644	edit dl rm
class-phpass.php	7317	0644	edit dl rm
class-phpmailer.php	148592	0644	edit dl rm
class-pop3.php	20919	0644	edit dl rm
class-requests.php	29798	0644	edit dl rm
class-simplepie.php	89264	0644	edit dl rm
class-smtp.php	40919	0644	edit dl rm
class-snoopy.php	37785	0644	edit dl rm
class-walker-category-dropdown.php	2127	0644	edit dl rm
class-walker-category.php	7874	0644	edit dl rm
class-walker-comment.php	13685	0644	edit dl rm
class-walker-nav-menu.php	8669	0644	edit dl rm
class-walker-page-dropdown.php	2299	0644	edit dl rm
class-walker-page.php	7033	0644	edit dl rm
class-wp-admin-bar.php	16951	0644	edit dl rm
class-wp-ajax-response.php	5235	0644	edit dl rm
class-wp-block-parser.php	15215	0644	edit dl rm
class-wp-block-styles-registry.php	4663	0644	edit dl rm
class-wp-block-type-registry.php	5091	0644	edit dl rm
class-wp-block-type.php	4815	0644	edit dl rm
class-wp-comment-query.php	44514	0644	edit dl rm
class-wp-comment.php	8961	0644	edit dl rm
class-wp-customize-control.php	25054	0644	edit dl rm
class-wp-customize-manager.php	203252	0644	edit dl rm
class-wp-customize-nav-menus.php	54963	0644	edit dl rm
class-wp-customize-panel.php	9596	0644	edit dl rm
class-wp-customize-section.php	10168	0644	edit dl rm
class-wp-customize-setting.php	28191	0644	edit dl rm
class-wp-customize-widgets.php	66978	0644	edit dl rm
class-wp-date-query.php	35276	0644	edit dl rm
class-wp-dependency.php	2501	0644	edit dl rm
class-wp-editor.php	68219	0644	edit dl rm
class-wp-embed.php	14746	0644	edit dl rm
class-wp-error.php	4923	0644	edit dl rm
class-wp-fatal-error-handler.php	7429	0644	edit dl rm
class-wp-feed-cache-transient.php	2560	0644	edit dl rm
class-wp-feed-cache.php	749	0644	edit dl rm
class-wp-hook.php	14294	0644	edit dl rm
class-wp-http-cookie.php	7146	0644	edit dl rm
class-wp-http-curl.php	12327	0644	edit dl rm
class-wp-http-encoding.php	6542	0644	edit dl rm
class-wp-http-ixr-client.php	3331	0644	edit dl rm
class-wp-http-proxy.php	6077	0644	edit dl rm
class-wp-http-requests-hooks.php	1949	0644	edit dl rm
class-wp-http-requests-response.php	4343	0644	edit dl rm
class-wp-http-response.php	2951	0644	edit dl rm
class-wp-http-streams.php	16070	0644	edit dl rm
class-wp-image-editor-gd.php	13886	0644	edit dl rm
class-wp-image-editor-imagick.php	28828	0644	edit dl rm
class-wp-image-editor.php	13911	0644	edit dl rm
class-wp-list-util.php	6407	0644	edit dl rm
class-wp-locale-switcher.php	5022	0644	edit dl rm
class-wp-locale.php	13893	0644	edit dl rm
class-wp-matchesmapregex.php	1804	0644	edit dl rm
class-wp-meta-query.php	27847	0644	edit dl rm
class-wp-metadata-lazyloader.php	5384	0644	edit dl rm
class-wp-network-query.php	18368	0644	edit dl rm
class-wp-network.php	12284	0644	edit dl rm
class-wp-oembed-controller.php	6027	0644	edit dl rm
class-wp-oembed.php	30174	0644	edit dl rm
class-wp-paused-extensions-storage.php	4933	0644	edit dl rm
class-wp-post-type.php	19527	0644	edit dl rm
class-wp-post.php	6441	0644	edit dl rm
class-wp-query.php	131083	0644	edit dl rm
class-wp-recovery-mode-cookie-service.php	6459	0644	edit dl rm
class-wp-recovery-mode-email-service.php	10122	0644	edit dl rm
class-wp-recovery-mode-key-service.php	4284	0644	edit dl rm
class-wp-recovery-mode-link-service.php	3370	0644	edit dl rm
class-wp-recovery-mode.php	11358	0644	edit dl rm
class-wp-rewrite.php	59893	0644	edit dl rm
class-wp-role.php	2661	0644	edit dl rm
class-wp-roles.php	8300	0644	edit dl rm
class-wp-session-tokens.php	7430	0644	edit dl rm
class-wp-simplepie-file.php	2326	0644	edit dl rm
class-wp-simplepie-sanitize-kses.php	1775	0644	edit dl rm
class-wp-site-query.php	28531	0644	edit dl rm
class-wp-site.php	7367	0644	edit dl rm
class-wp-tax-query.php	19440	0644	edit dl rm
class-wp-taxonomy.php	10688	0644	edit dl rm
class-wp-term-query.php	35423	0644	edit dl rm
class-wp-term.php	5265	0644	edit dl rm
class-wp-text-diff-renderer-inline.php	716	0644	edit dl rm
class-wp-text-diff-renderer-table.php	16796	0644	edit dl rm
class-wp-theme.php	50973	0644	edit dl rm
class-wp-user-meta-session-tokens.php	2990	0644	edit dl rm
class-wp-user-query.php	31298	0644	edit dl rm
class-wp-user-request.php	1996	0644	edit dl rm
class-wp-user.php	21766	0644	edit dl rm
class-wp-walker.php	12718	0644	edit dl rm
class-wp-widget-factory.php	2853	0644	edit dl rm
class-wp-widget.php	17842	0644	edit dl rm
class-wp-xmlrpc-server.php	210072	0644	edit dl rm
class-wp.php	24551	0644	edit dl rm
class.wp-dependencies.php	11524	0644	edit dl rm
class.wp-scripts.php	17756	0644	edit dl rm
class.wp-styles.php	10532	0644	edit dl rm
comment-template.php	91640	0644	edit dl rm
comment.php	117233	0644	edit dl rm
compat.php	12982	0644	edit dl rm
cron.php	32451	0644	edit dl rm
date.php	409	0644	edit dl rm
default-constants.php	10122	0644	edit dl rm
default-filters.php	25894	0644	edit dl rm
default-widgets.php	2180	0644	edit dl rm
deprecated.php	114644	0644	edit dl rm
embed-template.php	344	0644	edit dl rm
embed.php	47367	0644	edit dl rm
error-protection.php	3387	0644	edit dl rm
error_log	1764	0644	edit dl rm
feed-atom-comments.php	5405	0644	edit dl rm
feed-atom.php	3081	0644	edit dl rm
feed-rdf.php	2660	0644	edit dl rm
feed-rss.php	1190	0644	edit dl rm
feed-rss2-comments.php	4150	0644	edit dl rm
feed-rss2.php	3782	0644	edit dl rm
feed.php	22022	0644	edit dl rm
formatting.php	298428	0644	edit dl rm
functions.php	228155	0644	edit dl rm
functions.wp-scripts.php	12824	0644	edit dl rm
functions.wp-styles.php	8219	0644	edit dl rm
general-template.php	152465	0644	edit dl rm
http.php	24324	0644	edit dl rm
kses.php	58723	0644	edit dl rm
l10n.php	53102	0644	edit dl rm
link-template.php	143524	0644	edit dl rm
load.php	43291	0644	edit dl rm
locale.php	162	0644	edit dl rm
media-template.php	57710	0644	edit dl rm
media.php	149717	0644	edit dl rm
meta.php	47749	0644	edit dl rm
ms-blogs.php	24413	0644	edit dl rm
ms-default-constants.php	4785	0644	edit dl rm
ms-default-filters.php	6414	0644	edit dl rm
ms-deprecated.php	21344	0644	edit dl rm
ms-files.php	2649	0644	edit dl rm
ms-functions.php	87638	0644	edit dl rm
ms-load.php	19624	0644	edit dl rm
ms-network.php	3658	0644	edit dl rm
ms-settings.php	4134	0644	edit dl rm
ms-site.php	43073	0644	edit dl rm
nav-menu-template.php	22053	0644	edit dl rm
nav-menu.php	41317	0644	edit dl rm
option.php	70145	0644	edit dl rm
pluggable-deprecated.php	6262	0644	edit dl rm
pluggable.php	99833	0644	edit dl rm
plugin.php	32317	0644	edit dl rm
post-formats.php	7053	0644	edit dl rm
post-template.php	62915	0644	edit dl rm
post-thumbnail-template.php	8988	0644	edit dl rm
post.php	244611	0644	edit dl rm
query.php	32929	0644	edit dl rm
registration-functions.php	202	0644	edit dl rm
registration.php	202	0644	edit dl rm
rest-api.php	46630	0644	edit dl rm
revision.php	21686	0644	edit dl rm
rewrite.php	18030	0644	edit dl rm
rss-functions.php	214	0644	edit dl rm
rss.php	23208	0644	edit dl rm
script-loader.php	113551	0644	edit dl rm
session.php	264	0644	edit dl rm
shortcodes.php	21704	0644	edit dl rm
spl-autoload-compat.php	443	0644	edit dl rm
taxonomy.php	157961	0644	edit dl rm
template-loader.php	3190	0644	edit dl rm
template.php	21046	0644	edit dl rm
theme.php	104876	0644	edit dl rm
update.php	25573	0644	edit dl rm
user.php	124532	0644	edit dl rm
vars.php	5815	0644	edit dl rm
version.php	762	0644	edit dl rm
widgets.php	58750	0644	edit dl rm
wlwmanifest.xml	1045	0644	edit dl rm
wp-db.php	103829	0644	edit dl rm
wp-diff.php	662	0644	edit dl rm

Edit: /home/altere25/berryglowbeauty.com/wp-includes/class-wp-tax-query.php (19440B)

<?php
/**
 * Taxonomy API: WP_Tax_Query class
 *
 * @package WordPress
 * @subpackage Taxonomy
 * @since 4.4.0
 */

/**
 * Core class used to implement taxonomy queries for the Taxonomy API.
 *
 * Used for generating SQL clauses that filter a primary query according to object
 * taxonomy terms.
 *
 * WP_Tax_Query is a helper that allows primary query classes, such as WP_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.1.0
 */
class WP_Tax_Query {

/**
	 * Array of taxonomy queries.
	 *
	 * See WP_Tax_Query::__construct() for information on tax query arguments.
	 *
	 * @since 3.1.0
	 * @var array
	 */
	public $queries = array();

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

/**
	 * Standard response when the query should not return any rows.
	 *
	 * @since 3.2.0
	 * @var string
	 */
	private static $no_results = array(
		'join'  => array( '' ),
		'where' => array( '0 = 1' ),
	);

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

/**
	 * Terms and taxonomies fetched by this query.
	 *
	 * We store this data in a flat array because they are referenced in a
	 * number of places by WP_Query.
	 *
	 * @since 4.1.0
	 * @var array
	 */
	public $queried_terms = array();

/**
	 * 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;

/**
	 * Constructor.
	 *
	 * @since 3.1.0
	 * @since 4.1.0 Added support for `$operator` 'NOT EXISTS' and 'EXISTS' values.
	 *
	 * @param array $tax_query {
	 *     Array of taxonomy query clauses.
	 *
	 *     @type string $relation Optional. The MySQL keyword used to join
	 *                            the clauses of the query. Accepts 'AND', or 'OR'. Default 'AND'.
	 *     @type array {
	 *         Optional. An array of first-order clause parameters, or another fully-formed tax query.
	 *
	 *         @type string           $taxonomy         Taxonomy being queried. Optional when field=term_taxonomy_id.
	 *         @type string|int|array $terms            Term or terms to filter by.
	 *         @type string           $field            Field to match $terms against. Accepts 'term_id', 'slug',
	 *                                                 'name', or 'term_taxonomy_id'. Default: 'term_id'.
	 *         @type string           $operator         MySQL operator to be used with $terms in the WHERE clause.
	 *                                                  Accepts 'AND', 'IN', 'NOT IN', 'EXISTS', 'NOT EXISTS'.
	 *                                                  Default: 'IN'.
	 *         @type bool             $include_children Optional. Whether to include child terms.
	 *                                                  Requires a $taxonomy. Default: true.
	 *     }
	 * }
	 */
	public function __construct( $tax_query ) {
		if ( isset( $tax_query['relation'] ) ) {
			$this->relation = $this->sanitize_relation( $tax_query['relation'] );
		} else {
			$this->relation = 'AND';
		}

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

/**
	 * Ensure the 'tax_query' argument passed to the class constructor is well-formed.
	 *
	 * Ensures that each query-level clause has a 'relation' key, and that
	 * each first-order clause contains all the necessary keys from `$defaults`.
	 *
	 * @since 4.1.0
	 *
	 * @param array $queries Array of queries clauses.
	 * @return array Sanitized array of query clauses.
	 */
	public function sanitize_query( $queries ) {
		$cleaned_query = array();

$defaults = array(
			'taxonomy'         => '',
			'terms'            => array(),
			'field'            => 'term_id',
			'operator'         => 'IN',
			'include_children' => true,
		);

foreach ( $queries as $key => $query ) {
			if ( 'relation' === $key ) {
				$cleaned_query['relation'] = $this->sanitize_relation( $query );

// First-order clause.
			} elseif ( self::is_first_order_clause( $query ) ) {

$cleaned_clause          = array_merge( $defaults, $query );
				$cleaned_clause['terms'] = (array) $cleaned_clause['terms'];
				$cleaned_query[]         = $cleaned_clause;

/*
				 * Keep a copy of the clause in the flate
				 * $queried_terms array, for use in WP_Query.
				 */
				if ( ! empty( $cleaned_clause['taxonomy'] ) && 'NOT IN' !== $cleaned_clause['operator'] ) {
					$taxonomy = $cleaned_clause['taxonomy'];
					if ( ! isset( $this->queried_terms[ $taxonomy ] ) ) {
						$this->queried_terms[ $taxonomy ] = array();
					}

/*
					 * Backward compatibility: Only store the first
					 * 'terms' and 'field' found for a given taxonomy.
					 */
					if ( ! empty( $cleaned_clause['terms'] ) && ! isset( $this->queried_terms[ $taxonomy ]['terms'] ) ) {
						$this->queried_terms[ $taxonomy ]['terms'] = $cleaned_clause['terms'];
					}

if ( ! empty( $cleaned_clause['field'] ) && ! isset( $this->queried_terms[ $taxonomy ]['field'] ) ) {
						$this->queried_terms[ $taxonomy ]['field'] = $cleaned_clause['field'];
					}
				}

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

if ( ! empty( $cleaned_subquery ) ) {
					// All queries with children must have a relation.
					if ( ! isset( $cleaned_subquery['relation'] ) ) {
						$cleaned_subquery['relation'] = 'AND';
					}

$cleaned_query[] = $cleaned_subquery;
				}
			}
		}

return $cleaned_query;
	}

/**
	 * Sanitize a 'relation' operator.
	 *
	 * @since 4.1.0
	 *
	 * @param string $relation Raw relation key from the query argument.
	 * @return string Sanitized relation ('AND' or 'OR').
	 */
	public function sanitize_relation( $relation ) {
		if ( 'OR' === strtoupper( $relation ) ) {
			return 'OR';
		} else {
			return 'AND';
		}
	}

/**
	 * Determine whether a clause is first-order.
	 *
	 * A "first-order" clause is one that contains any of the first-order
	 * clause keys ('terms', 'taxonomy', 'include_children', 'field',
	 * 'operator'). An empty clause also counts as a first-order clause,
	 * for backward compatibility. Any clause that doesn't meet this is
	 * determined, by process of elimination, to be a higher-order query.
	 *
	 * @since 4.1.0
	 *
	 * @param array $query Tax query arguments.
	 * @return bool Whether the query clause is a first-order clause.
	 */
	protected static function is_first_order_clause( $query ) {
		return is_array( $query ) && ( empty( $query ) || array_key_exists( 'terms', $query ) || array_key_exists( 'taxonomy', $query ) || array_key_exists( 'include_children', $query ) || array_key_exists( 'field', $query ) || array_key_exists( 'operator', $query ) );
	}

/**
	 * Generates SQL clauses to be appended to a main query.
	 *
	 * @since 3.1.0
	 *
	 * @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.
	 * @return array {
	 *     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.
	 * }
	 */
	public function get_sql( $primary_table, $primary_id_column ) {
		$this->primary_table     = $primary_table;
		$this->primary_id_column = $primary_id_column;

return $this->get_sql_clauses();
	}

/**
	 * Generate SQL clauses to be appended to a main query.
	 *
	 * Called by the public WP_Tax_Query::get_sql(), this method
	 * is abstracted out to maintain parity with the other Query classes.
	 *
	 * @since 4.1.0
	 *
	 * @return array {
	 *     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 array {
	 *     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 );

$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.
	 *
	 * @since 4.1.0
	 *
	 * @global wpdb $wpdb The WordPress database abstraction object.
	 *
	 * @param array $clause       Query clause (passed by reference).
	 * @param array $parent_query Parent query array.
	 * @return array {
	 *     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 ) {
		global $wpdb;

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

$join  = '';
		$where = '';

$this->clean_query( $clause );

if ( is_wp_error( $clause ) ) {
			return self::$no_results;
		}

$terms    = $clause['terms'];
		$operator = strtoupper( $clause['operator'] );

if ( 'IN' == $operator ) {

if ( empty( $terms ) ) {
				return self::$no_results;
			}

$terms = implode( ',', $terms );

/*
			 * Before creating another table join, see if this clause has a
			 * sibling with an existing join that can be shared.
			 */
			$alias = $this->find_compatible_table_alias( $clause, $parent_query );
			if ( false === $alias ) {
				$i     = count( $this->table_aliases );
				$alias = $i ? 'tt' . $i : $wpdb->term_relationships;

// Store the alias as part of a flat array to build future iterators.
				$this->table_aliases[] = $alias;

// Store the alias with this clause, so later siblings can use it.
				$clause['alias'] = $alias;

$join .= " LEFT JOIN $wpdb->term_relationships";
				$join .= $i ? " AS $alias" : '';
				$join .= " ON ($this->primary_table.$this->primary_id_column = $alias.object_id)";
			}

$where = "$alias.term_taxonomy_id $operator ($terms)";

} elseif ( 'NOT IN' == $operator ) {

if ( empty( $terms ) ) {
				return $sql;
			}

$terms = implode( ',', $terms );

$where = "$this->primary_table.$this->primary_id_column NOT IN (
				SELECT object_id
				FROM $wpdb->term_relationships
				WHERE term_taxonomy_id IN ($terms)
			)";

} elseif ( 'AND' == $operator ) {

if ( empty( $terms ) ) {
				return $sql;
			}

$num_terms = count( $terms );

$terms = implode( ',', $terms );

$where = "(
				SELECT COUNT(1)
				FROM $wpdb->term_relationships
				WHERE term_taxonomy_id IN ($terms)
				AND object_id = $this->primary_table.$this->primary_id_column
			) = $num_terms";

} elseif ( 'NOT EXISTS' === $operator || 'EXISTS' === $operator ) {

$where = $wpdb->prepare(
				"$operator (
				SELECT 1
				FROM $wpdb->term_relationships
				INNER JOIN $wpdb->term_taxonomy
				ON $wpdb->term_taxonomy.term_taxonomy_id = $wpdb->term_relationships.term_taxonomy_id
				WHERE $wpdb->term_taxonomy.taxonomy = %s
				AND $wpdb->term_relationships.object_id = $this->primary_table.$this->primary_id_column
			)",
				$clause['taxonomy']
			);

}

$sql['join'][]  = $join;
		$sql['where'][] = $where;
		return $sql;
	}

/**
	 * 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_Tax_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;

// Sanity check. Only IN queries use the JOIN syntax .
		if ( ! isset( $clause['operator'] ) || 'IN' !== $clause['operator'] ) {
			return $alias;
		}

// Since we're only checking IN queries, we're only concerned with OR relations.
		if ( ! isset( $parent_query['relation'] ) || 'OR' !== $parent_query['relation'] ) {
			return $alias;
		}

$compatible_operators = array( 'IN' );

foreach ( $parent_query as $sibling ) {
			if ( ! is_array( $sibling ) || ! $this->is_first_order_clause( $sibling ) ) {
				continue;
			}

if ( empty( $sibling['alias'] ) || empty( $sibling['operator'] ) ) {
				continue;
			}

// The sibling must both have compatible operator to share its alias.
			if ( in_array( strtoupper( $sibling['operator'] ), $compatible_operators ) ) {
				$alias = preg_replace( '/\W/', '_', $sibling['alias'] );
				break;
			}
		}

return $alias;
	}

/**
	 * Validates a single query.
	 *
	 * @since 3.2.0
	 *
	 * @param array $query The single query. Passed by reference.
	 */
	private function clean_query( &$query ) {
		if ( empty( $query['taxonomy'] ) ) {
			if ( 'term_taxonomy_id' !== $query['field'] ) {
				$query = new WP_Error( 'invalid_taxonomy', __( 'Invalid taxonomy.' ) );
				return;
			}

// so long as there are shared terms, include_children requires that a taxonomy is set
			$query['include_children'] = false;
		} elseif ( ! taxonomy_exists( $query['taxonomy'] ) ) {
			$query = new WP_Error( 'invalid_taxonomy', __( 'Invalid taxonomy.' ) );
			return;
		}

if ( 'slug' === $query['field'] || 'name' === $query['field'] ) {
			$query['terms'] = array_unique( (array) $query['terms'] );
		} else {
			$query['terms'] = wp_parse_id_list( $query['terms'] );
		}

if ( is_taxonomy_hierarchical( $query['taxonomy'] ) && $query['include_children'] ) {
			$this->transform_query( $query, 'term_id' );

if ( is_wp_error( $query ) ) {
				return;
			}

$children = array();
			foreach ( $query['terms'] as $term ) {
				$children   = array_merge( $children, get_term_children( $term, $query['taxonomy'] ) );
				$children[] = $term;
			}
			$query['terms'] = $children;
		}

$this->transform_query( $query, 'term_taxonomy_id' );
	}

/**
	 * Transforms a single query, from one field to another.
	 *
	 * Operates on the `$query` object by reference. In the case of error,
	 * `$query` is converted to a WP_Error object.
	 *
	 * @since 3.2.0
	 *
	 * @global wpdb $wpdb The WordPress database abstraction object.
	 *
	 * @param array  $query           The single query. Passed by reference.
	 * @param string $resulting_field The resulting field. Accepts 'slug', 'name', 'term_taxonomy_id',
	 *                                or 'term_id'. Default 'term_id'.
	 */
	public function transform_query( &$query, $resulting_field ) {
		if ( empty( $query['terms'] ) ) {
			return;
		}

if ( $query['field'] == $resulting_field ) {
			return;
		}

$resulting_field = sanitize_key( $resulting_field );

// Empty 'terms' always results in a null transformation.
		$terms = array_filter( $query['terms'] );
		if ( empty( $terms ) ) {
			$query['terms'] = array();
			$query['field'] = $resulting_field;
			return;
		}

$args = array(
			'get'                    => 'all',
			'number'                 => 0,
			'taxonomy'               => $query['taxonomy'],
			'update_term_meta_cache' => false,
			'orderby'                => 'none',
		);

// Term query parameter name depends on the 'field' being searched on.
		switch ( $query['field'] ) {
			case 'slug':
				$args['slug'] = $terms;
				break;
			case 'name':
				$args['name'] = $terms;
				break;
			case 'term_taxonomy_id':
				$args['term_taxonomy_id'] = $terms;
				break;
			default:
				$args['include'] = wp_parse_id_list( $terms );
				break;
		}

$term_query = new WP_Term_Query();
		$term_list  = $term_query->query( $args );

if ( is_wp_error( $term_list ) ) {
			$query = $term_list;
			return;
		}

if ( 'AND' == $query['operator'] && count( $term_list ) < count( $query['terms'] ) ) {
			$query = new WP_Error( 'inexistent_terms', __( 'Inexistent terms.' ) );
			return;
		}

$query['terms'] = wp_list_pluck( $term_list, $resulting_field );
		$query['field'] = $resulting_field;
	}
}

cmd: