Automattic\WooCommerce\Internal\Admin\Reports

ProductSearchQuery::add_wp_query_join │ public static │ WC 11.2.0

Adds the SKU lookup table to a product search query.

Метод класса: ProductSearchQuery{}

Хуков нет.

Возвращает

string. Join clause.

Использование

$result = ProductSearchQuery::add_wp_query_join( $join, $wp_query );

$join(строка) (обязательный)

Join clause.

$wp_query(WP_Query) (обязательный)

Query being built.

Список изменений

Код ProductSearchQuery::add_wp_query_join() ProductSearchQuery::add wp query join ^{WC 11.2.2}

public static function add_wp_query_join( $join, $wp_query ) {
	global $wpdb;

	if ( ! $wp_query->get( self::TERMS_QUERY_VAR ) || ! wc_product_sku_enabled() ) {
		return $join;
	}

	$alias = self::LOOKUP_ALIAS;

	return $join . " LEFT JOIN {$wpdb->wc_product_meta_lookup} AS {$alias} ON {$wpdb->posts}.ID = {$alias}.product_id ";
}