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 (7687,7720,7810,8903,8904,8918,11504,28710,31004,31924,7699,8913,24490,24515,24783,23886,23881,23547,23140,28815,31008,31927,24558,23661)
AND stock_status = 'instock'
AND max_price > 0
array(5) {
["total"]=>
int(12)
["avg_price"]=>
string(6) "897.40"
["min_price"]=>
string(6) "199.00"
["max_price"]=>
string(8) "3,540.00"
["avg_rating"]=>
string(4) "2.21"
}