SELECT
ROUND(AVG(max_price)) as avg_price,
ROUND(MIN(max_price)) as min_price,
ROUND(MAX(max_price)) as max_price,
ROUND(AVG(average_rating)) as avg_rating
FROM wp_wc_product_meta_lookup
WHERE product_id IN (7759,7763,7764,8815,8816,20324,51618,7760,8814,24969,24945,24964,24294,24290,22409,51619,24954,24297)
AND stock_status = 'instock'
AND max_price > 0
array(5) {
["total"]=>
int(9)
["avg_price"]=>
string(8) "2,174.00"
["min_price"]=>
string(6) "529.00"
["max_price"]=>
string(8) "6,900.00"
["avg_rating"]=>
string(4) "3.00"
}