Automattic\WooCommerce\Internal\ProductFilters

QueryClauses::append_product_sorting_table_join │ private │ WC 1.0

Join wc_product_meta_lookup to posts if not already joined.

Method of the class: QueryClauses{}

No Hooks.

Returns

String.

Usage

// private - for code of main (parent) class only
$result = $this->append_product_sorting_table_join( $sql ): string;
$sql(string) (required)
SQL join.

QueryClauses::append_product_sorting_table_join() code WC 10.3.3

woocommerce/src/Internal/ProductFilters/QueryClauses.php 
private function append_product_sorting_table_join( string $sql ): string {
	global $wpdb;

	if ( ! strstr( $sql, 'wc_product_meta_lookup' ) ) {
		$sql .= " LEFT JOIN {$wpdb->wc_product_meta_lookup} wc_product_meta_lookup ON $wpdb->posts.ID = wc_product_meta_lookup.product_id ";
	}
	return $sql;
}