WP_Meta_Query::find_compatible_table_alias( array $clause, array $parent_query ): string|false

Source

protected function find_compatible_table_alias( $clause, $parent_query ) {
	$alias = false;

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

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

		$compatible_compares = array();

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

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

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

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

View all references View on Trac View on GitHub