woocommerce_report_most_stocked_query_from
Usage
add_filter( 'woocommerce_report_most_stocked_query_from', 'wp_kama_woocommerce_report_most_stocked_query_from_filter' ); /** * Function for `woocommerce_report_most_stocked_query_from` filter-hook. * * @param $prepare * * @return */ function wp_kama_woocommerce_report_most_stocked_query_from_filter( $prepare ){ // filter... return $prepare; }
- $prepare
- -
Where the hook is called
woocommerce_report_most_stocked_query_from
woocommerce/includes/admin/reports/class-wc-report-most-stocked.php 33-46
$query_from = apply_filters( 'woocommerce_report_most_stocked_query_from', $wpdb->prepare( " FROM {$wpdb->posts} as posts INNER JOIN {$wpdb->wc_product_meta_lookup} AS lookup ON posts.ID = lookup.product_id WHERE 1=1 AND posts.post_type IN ( 'product', 'product_variation' ) AND posts.post_status = 'publish' AND lookup.stock_quantity > %d ", $stock ) );