FM / wp-includes

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

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

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

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

<?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
 */
#[AllowDynamicProperties]
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  ...$0 {
	 *         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 );
	}

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

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

/**
	 * Determines 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 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.
	 * }
	 */
	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();
	}

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

/**
	 * 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( &$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;
	}

/**
	 * Generates 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  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( &$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;
	}

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

// Confidence 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, true ) ) {
				$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
	 *
	 * @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;
		}

if ( ! is_taxonomy_hierarchical( $query['taxonomy'] ) ) {
			$args['number'] = count( $terms );
		}

$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: