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 (7852,8942,8955,8790,18415,19711,28800,28802,33228,51614,64094,24976,23465,23420,24370,22724,22497,28879,28878,33231,51615,64095)
AND stock_status = 'instock'
AND max_price > 0
array(5) {
["total"]=>
int(11)
["avg_price"]=>
string(8) "1,111.29"
["min_price"]=>
string(6) "299.00"
["max_price"]=>
string(8) "5,400.00"
["avg_rating"]=>
string(4) "3.06"
}