Automattic\WooCommerce\Blocks\BlockTypes\ProductCollection
QueryBuilder::append_product_sorting_table_join()
Join wc_product_meta_lookup to posts if not already joined.
Method of the class: QueryBuilder{}
No Hooks.
Return
String
.
Usage
// protected - for code of main (parent) or child class $result = $this->append_product_sorting_table_join( $sql );
- $sql(string) (required)
- SQL join.
QueryBuilder::append_product_sorting_table_join() QueryBuilder::append product sorting table join code WC 9.6.0
protected function append_product_sorting_table_join( $sql ) { 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; }