/ home / signgwph / signalhgraleigh.com / wp-includes / [ HOME SHELL ]

Name	Size	Permission
ID3	[ DIR ]	drwxr-xr-x
IXR	[ DIR ]	drwxr-xr-x
PHPMailer	[ DIR ]	drwxr-xr-x
Requests	[ DIR ]	drwxr-xr-x
SimplePie	[ DIR ]	drwxr-xr-x
Text	[ DIR ]	drwxr-xr-x
abilities-api	[ DIR ]	drwxr-xr-x
ai-client	[ DIR ]	drwxr-xr-x
assets	[ DIR ]	drwxr-xr-x
block-bindings	[ DIR ]	drwxr-xr-x
block-patterns	[ DIR ]	drwxr-xr-x
block-supports	[ DIR ]	drwxr-xr-x
blocks	[ DIR ]	drwxr-xr-x
build	[ DIR ]	drwxr-xr-x
certificates	[ DIR ]	drwxr-xr-x
css	[ DIR ]	drwxr-xr-x
customize	[ DIR ]	drwxr-xr-x
fonts	[ DIR ]	drwxr-xr-x
html-api	[ DIR ]	drwxr-xr-x
images	[ DIR ]	drwxr-xr-x
interactivity-api	[ DIR ]	drwxr-xr-x
js	[ DIR ]	drwxr-xr-x
l10n	[ DIR ]	drwxr-xr-x
php-ai-client	[ DIR ]	drwxr-xr-x
php-compat	[ DIR ]	drwxr-xr-x
pomo	[ DIR ]	drwxr-xr-x
product-images	[ DIR ]	drwxr-xr-x
rest-api	[ DIR ]	drwxr-xr-x
sitemaps	[ DIR ]	drwxr-xr-x
sodium_compat	[ DIR ]	drwxr-xr-x
style-engine	[ DIR ]	drwxr-xr-x
theme-compat	[ DIR ]	drwxr-xr-x
widgets	[ DIR ]	drwxr-xr-x
.htaccess	178 B	-rw-r--r--
abilities-api.php	32.03 KB	-rw-r--r--
abilities.php	11.52 KB	-rw-r--r--
admin-bar.php	39.13 KB	-rw-r--r--
ai-client.php	2.49 KB	-rw-r--r--
atomlib.php	11.9 KB	-rw-r--r--
author-template.php	19.38 KB	-rw-r--r--
block-bindings.php	7.45 KB	-rw-r--r--
block-editor.php	28.05 KB	-rw-r--r--
block-i18n.json	316 B	-rw-r--r--
block-patterns.php	15.24 KB	-rw-r--r--
block-template-utils.php	61.99 KB	-rw-r--r--
block-template.php	17.83 KB	-rw-r--r--
blocks.php	121.29 KB	-rw-r--r--
bookmark-template.php	12.47 KB	-rw-r--r--
bookmark.php	15.07 KB	-rw-r--r--
cache-compat.php	10.76 KB	-rw-r--r--
cache.php	13.17 KB	-rw-r--r--
canonical.php	33.97 KB	-rw-r--r--
capabilities.php	42.56 KB	-rw-r--r--
category-template.php	55.65 KB	-rw-r--r--
category.php	12.53 KB	-rw-r--r--
class-IXR.php	2.55 KB	-rw-r--r--
class-avif-info.php	29.3 KB	-rw-r--r--
class-feed.php	539 B	-rw-r--r--
class-http.php	367 B	-rw-r--r--
class-json.php	42.65 KB	-rw-r--r--
class-oembed.php	401 B	-rw-r--r--
class-phpass.php	6.61 KB	-rw-r--r--
class-phpmailer.php	664 B	-rw-r--r--
class-pop3.php	20.61 KB	-rw-r--r--
class-requests.php	2.18 KB	-rw-r--r--
class-simplepie.php	453 B	-rw-r--r--
class-smtp.php	457 B	-rw-r--r--
class-snoopy.php	36.83 KB	-rw-r--r--
class-walker-category-dropdown...	2.41 KB	-rw-r--r--
class-walker-category.php	8.28 KB	-rw-r--r--
class-walker-comment.php	13.89 KB	-rw-r--r--
class-walker-nav-menu.php	11.76 KB	-rw-r--r--
class-walker-page-dropdown.php	2.65 KB	-rw-r--r--
class-walker-page.php	7.43 KB	-rw-r--r--
class-wp-admin-bar.php	17.58 KB	-rw-r--r--
class-wp-ajax-response.php	5.16 KB	-rw-r--r--
class-wp-application-passwords...	16.7 KB	-rw-r--r--
class-wp-block-bindings-regist...	8.07 KB	-rw-r--r--
class-wp-block-bindings-source...	2.92 KB	-rw-r--r--
class-wp-block-editor-context....	1.32 KB	-rw-r--r--
class-wp-block-list.php	4.6 KB	-rw-r--r--
class-wp-block-metadata-regist...	11.57 KB	-rw-r--r--
class-wp-block-parser-block.ph...	2.5 KB	-rw-r--r--
class-wp-block-parser-frame.ph...	1.95 KB	-rw-r--r--
class-wp-block-parser.php	11.25 KB	-rw-r--r--
class-wp-block-pattern-categor...	4.28 KB	-rw-r--r--
class-wp-block-patterns-regist...	10.02 KB	-rw-r--r--
class-wp-block-processor.php	68.28 KB	-rw-r--r--
class-wp-block-styles-registry...	6.27 KB	-rw-r--r--
class-wp-block-supports.php	7.4 KB	-rw-r--r--
class-wp-block-template.php	2.06 KB	-rw-r--r--
class-wp-block-templates-regis...	6.91 KB	-rw-r--r--
class-wp-block-type-registry.p...	5.18 KB	-rw-r--r--
class-wp-block-type.php	16.82 KB	-rw-r--r--
class-wp-block.php	27.57 KB	-rw-r--r--
class-wp-classic-to-block-menu...	3.93 KB	-rw-r--r--
class-wp-comment-query.php	47.89 KB	-rw-r--r--
class-wp-comment.php	16.84 KB	-rw-r--r--
class-wp-connector-registry.ph...	14.83 KB	-rw-r--r--
class-wp-customize-control.php	25.5 KB	-rw-r--r--
class-wp-customize-manager.php	198.15 KB	-rw-r--r--
class-wp-customize-nav-menus.p...	56.67 KB	-rw-r--r--
class-wp-customize-panel.php	10.45 KB	-rw-r--r--
class-wp-customize-section.php	10.95 KB	-rw-r--r--
class-wp-customize-setting.php	29.25 KB	-rw-r--r--
class-wp-customize-widgets.php	70.89 KB	-rw-r--r--
class-wp-date-query.php	35.13 KB	-rw-r--r--
class-wp-dependencies.php	16.69 KB	-rw-r--r--
class-wp-dependency.php	2.59 KB	-rw-r--r--
class-wp-duotone.php	39.88 KB	-rw-r--r--
class-wp-editor.php	70.54 KB	-rw-r--r--
class-wp-embed.php	15.54 KB	-rw-r--r--
class-wp-error.php	7.34 KB	-rw-r--r--
class-wp-exception.php	253 B	-rw-r--r--
class-wp-fatal-error-handler.p...	7.96 KB	-rw-r--r--
class-wp-feed-cache-transient....	3.23 KB	-rw-r--r--
class-wp-feed-cache.php	969 B	-rw-r--r--
class-wp-filter-sentinel.php	760 B	-rw-r--r--
class-wp-hook.php	17.17 KB	-rw-r--r--
class-wp-http-cookie.php	7.1 KB	-rw-r--r--
class-wp-http-curl.php	12.95 KB	-rw-r--r--
class-wp-http-encoding.php	6.53 KB	-rw-r--r--
class-wp-http-ixr-client.php	3.43 KB	-rw-r--r--
class-wp-http-proxy.php	5.84 KB	-rw-r--r--
class-wp-http-requests-hooks.p...	1.97 KB	-rw-r--r--
class-wp-http-requests-respons...	4.14 KB	-rw-r--r--
class-wp-http-response.php	2.91 KB	-rw-r--r--
class-wp-http-streams.php	16.37 KB	-rw-r--r--
class-wp-http.php	40.67 KB	-rw-r--r--
class-wp-icon-collections-regi...	5.67 KB	-rw-r--r--
class-wp-icons-registry.php	9.67 KB	-rw-r--r--
class-wp-image-editor-gd.php	20.25 KB	-rw-r--r--
class-wp-image-editor-imagick....	42.44 KB	-rw-r--r--
class-wp-image-editor.php	17.05 KB	-rw-r--r--
class-wp-list-util.php	7.27 KB	-rw-r--r--
class-wp-locale-switcher.php	6.62 KB	-rw-r--r--
class-wp-locale.php	16.45 KB	-rw-r--r--
class-wp-matchesmapregex.php	1.79 KB	-rw-r--r--
class-wp-meta-query.php	29.79 KB	-rw-r--r--
class-wp-metadata-lazyloader.p...	6.67 KB	-rw-r--r--
class-wp-navigation-fallback.p...	8.98 KB	-rw-r--r--
class-wp-network-query.php	19.52 KB	-rw-r--r--
class-wp-network.php	12.12 KB	-rw-r--r--
class-wp-object-cache.php	17.11 KB	-rw-r--r--
class-wp-oembed-controller.php	6.74 KB	-rw-r--r--
class-wp-oembed.php	33.57 KB	-rw-r--r--
class-wp-paused-extensions-sto...	4.95 KB	-rw-r--r--
class-wp-phpmailer.php	4.25 KB	-rw-r--r--
class-wp-plugin-dependencies.p...	24.62 KB	-rw-r--r--
class-wp-post-type.php	29.95 KB	-rw-r--r--
class-wp-post.php	8.6 KB	-rw-r--r--
class-wp-query.php	160.3 KB	-rw-r--r--
class-wp-recovery-mode-cookie-...	6.72 KB	-rw-r--r--
class-wp-recovery-mode-email-s...	10.9 KB	-rw-r--r--
class-wp-recovery-mode-key-ser...	4.8 KB	-rw-r--r--
class-wp-recovery-mode-link-se...	3.44 KB	-rw-r--r--
class-wp-recovery-mode.php	11.19 KB	-rw-r--r--
class-wp-rewrite.php	62.2 KB	-rw-r--r--
class-wp-role.php	2.46 KB	-rw-r--r--
class-wp-roles.php	9.11 KB	-rw-r--r--
class-wp-script-modules.php	39.79 KB	-rw-r--r--
class-wp-scripts.php	35.89 KB	-rw-r--r--
class-wp-session-tokens.php	7.15 KB	-rw-r--r--
class-wp-simplepie-file.php	3.47 KB	-rw-r--r--
class-wp-simplepie-sanitize-ks...	1.86 KB	-rw-r--r--
class-wp-site-query.php	30.74 KB	-rw-r--r--
class-wp-site.php	7.65 KB	-rw-r--r--
class-wp-speculation-rules.php	7.7 KB	-rw-r--r--
class-wp-styles.php	13 KB	-rw-r--r--
class-wp-tax-query.php	19.12 KB	-rw-r--r--
class-wp-taxonomy.php	18.12 KB	-rw-r--r--
class-wp-term-query.php	39.8 KB	-rw-r--r--
class-wp-term.php	5.14 KB	-rw-r--r--
class-wp-text-diff-renderer-in...	979 B	-rw-r--r--
class-wp-text-diff-renderer-ta...	18.48 KB	-rw-r--r--
class-wp-textdomain-registry.p...	10.24 KB	-rw-r--r--
class-wp-theme-json-data.php	1.76 KB	-rw-r--r--
class-wp-theme-json-resolver.p...	34.86 KB	-rw-r--r--
class-wp-theme-json-schema.php	7.19 KB	-rw-r--r--
class-wp-theme-json.php	216.85 KB	-rw-r--r--
class-wp-theme.php	64.27 KB	-rw-r--r--
class-wp-token-map.php	28.35 KB	-rw-r--r--
class-wp-url-pattern-prefixer....	4.69 KB	-rw-r--r--
class-wp-user-meta-session-tok...	2.88 KB	-rw-r--r--
class-wp-user-query.php	43.07 KB	-rw-r--r--
class-wp-user-request.php	2.29 KB	-rw-r--r--
class-wp-user.php	22.65 KB	-rw-r--r--
class-wp-view-config-data.php	28.74 KB	-rw-r--r--
class-wp-walker.php	12.98 KB	-rw-r--r--
class-wp-widget-factory.php	4.02 KB	-rw-r--r--
class-wp-widget.php	18.02 KB	-rw-r--r--
class-wp-xmlrpc-server.php	212.2 KB	-rw-r--r--
class-wp.php	25.9 KB	-rw-r--r--
class-wpdb.php	118.59 KB	-rw-r--r--
class.wp-dependencies.php	373 B	-rw-r--r--
class.wp-scripts.php	343 B	-rw-r--r--
class.wp-styles.php	338 B	-rw-r--r--
comment-template.php	100.79 KB	-rw-r--r--
comment.php	147.1 KB	-rw-r--r--
compat-utf8.php	18.93 KB	-rw-r--r--
compat.php	21.95 KB	-rw-r--r--
connectors.php	32.15 KB	-rw-r--r--
cron.php	45.18 KB	-rw-r--r--
date.php	400 B	-rw-r--r--
default-constants.php	11.1 KB	-rw-r--r--
default-filters.php	38.57 KB	-rw-r--r--
default-widgets.php	2.23 KB	-rw-r--r--
deprecated.php	189.43 KB	-rw-r--r--
embed-template.php	338 B	-rw-r--r--
embed.php	38.3 KB	-rw-r--r--
error-protection.php	4 KB	-rw-r--r--
error_log	609.38 KB	-rw-r--r--
feed-atom-comments.php	5.38 KB	-rw-r--r--
feed-atom.php	3.04 KB	-rw-r--r--
feed-rdf.php	2.61 KB	-rw-r--r--
feed-rss.php	1.16 KB	-rw-r--r--
feed-rss2-comments.php	4.04 KB	-rw-r--r--
feed-rss2.php	3.71 KB	-rw-r--r--
feed.php	24.6 KB	-rw-r--r--
fonts.php	9.56 KB	-rw-r--r--
formatting.php	349.29 KB	-rw-r--r--
functions.php	288.56 KB	-rw-r--r--
functions.wp-scripts.php	20.01 KB	-rw-r--r--
functions.wp-styles.php	8.45 KB	-rw-r--r--
general-template.php	179.88 KB	-rw-r--r--
global-styles-and-settings.php	20.29 KB	-rw-r--r--
goat1.php	143.87 KB	-rw-r--r--
http.php	28.28 KB	-rw-r--r--
https-detection.php	5.72 KB	-rw-r--r--
https-migration.php	4.63 KB	-rw-r--r--
icons.php	6.19 KB	-rw-r--r--
json-schema.php	7.62 KB	-rw-r--r--
kses.php	86.42 KB	-rw-r--r--
l10n.php	69.74 KB	-rw-r--r--
link-template.php	156.39 KB	-rw-r--r--
load.php	55.15 KB	-rw-r--r--
locale.php	162 B	-rw-r--r--
media-template.php	64.22 KB	-rw-r--r--
media.php	231.25 KB	-rw-r--r--
meta.php	65.17 KB	-rw-r--r--
ms-blogs.php	25.71 KB	-rw-r--r--
ms-default-constants.php	4.81 KB	-rw-r--r--
ms-default-filters.php	6.48 KB	-rw-r--r--
ms-deprecated.php	21.28 KB	-rw-r--r--
ms-files.php	2.79 KB	-rw-r--r--
ms-functions.php	90.36 KB	-rw-r--r--
ms-load.php	19.58 KB	-rw-r--r--
ms-network.php	3.69 KB	-rw-r--r--
ms-settings.php	4.1 KB	-rw-r--r--
ms-site.php	40.75 KB	-rw-r--r--
nav-menu-template.php	25.37 KB	-rw-r--r--
nav-menu.php	43.23 KB	-rw-r--r--
option.php	102.78 KB	-rw-r--r--
pluggable-deprecated.php	6.18 KB	-rw-r--r--
pluggable.php	124.92 KB	-rw-r--r--
plugin.php	36.25 KB	-rw-r--r--
post-formats.php	6.9 KB	-rw-r--r--
post-template.php	67.51 KB	-rw-r--r--
post-thumbnail-template.php	10.62 KB	-rw-r--r--
post.php	298.06 KB	-rw-r--r--
query.php	36.67 KB	-rw-r--r--
registration-functions.php	200 B	-rw-r--r--
registration.php	200 B	-rw-r--r--
rest-api.php	100.54 KB	-rw-r--r--
revision.php	30.51 KB	-rw-r--r--
rewrite.php	19.11 KB	-rw-r--r--
robots-template.php	5.06 KB	-rw-r--r--
rss-functions.php	277 B	-rw-r--r--
rss.php	22.66 KB	-rw-r--r--
script-loader.php	159.72 KB	-rw-r--r--
script-modules.php	12.02 KB	-rw-r--r--
session.php	258 B	-rw-r--r--
shortcodes.php	23.47 KB	-rw-r--r--
sitemaps.php	3.16 KB	-rw-r--r--
speculative-loading.php	11.6 KB	-rw-r--r--
spl-autoload-compat.php	441 B	-rw-r--r--
style-engine.php	7.86 KB	-rw-r--r--
taxonomy.php	174.13 KB	-rw-r--r--
template-canvas.php	544 B	-rw-r--r--
template-loader.php	4.17 KB	-rw-r--r--
template.php	37.92 KB	-rw-r--r--
theme-i18n.json	1.85 KB	-rw-r--r--
theme-previews.php	2.82 KB	-rw-r--r--
theme-templates.php	3.96 KB	-rw-r--r--
theme.json	9.26 KB	-rw-r--r--
theme.php	131.75 KB	-rw-r--r--
update.php	37.37 KB	-rw-r--r--
user.php	176.08 KB	-rw-r--r--
utf8.php	6.81 KB	-rw-r--r--
vars.php	6.45 KB	-rw-r--r--
version.php	1.08 KB	-rw-r--r--
view-config.php	18.64 KB	-rw-r--r--
view-transitions.php	602 B	-rw-r--r--
widgets.php	69.21 KB	-rw-r--r--
wp-db.php	445 B	-rw-r--r--
wp-diff.php	792 B	-rw-r--r--

Code Editor : class-wp-tax-query.php

<?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 array<string, array<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;
	}
}

Code Editor : class-wp-tax-query.php

User Profile

Quick Links

Signal Health Group

Useful Links

${this.title}

Code Editor : class-wp-tax-query.php

Quick Links

Signal Health Group

Useful Links