SELECT
AVG(max_price) as avg_price,
MIN(max_price) as min_price,
MAX(max_price) as max_price,
AVG(average_rating) as avg_rating
FROM wp_wc_product_meta_lookup
WHERE product_id IN (7798,7846,8938,8939,12812,12829,12841,16947,16959,18125,42755,44637,48096,48109,50770,50783,54349,54378,54389,61824,7755,7839,7845,8741,8752,8753,8855,8919,8937,42504,24966,24951,23477,23475,23081,23078,23075,22905,22891,22768,42758,44639,48099,48112,50771,50784,54350,54379,54390,61825,24960,24733,24973,24482,23589,23587,24166,23543,23479,42510)
AND stock_status = 'instock'
AND max_price > 0
array(5) {
["total"]=>
int(30)
["avg_price"]=>
string(8) "2,110.10"
["min_price"]=>
string(6) "249.00"
["max_price"]=>
string(9) "19,900.00"
["avg_rating"]=>
string(4) "1.15"
}