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 (8910,18297,32820,38503,50480,8804,8908,8909,18153,18313,18332,23700,22754,32822,38506,50481,24320,23715,23710,22763,22745,22732)
AND stock_status = 'instock'
AND max_price > 0
array(5) {
["total"]=>
int(11)
["avg_price"]=>
string(6) "913.00"
["min_price"]=>
string(6) "229.00"
["max_price"]=>
string(8) "2,090.00"
["avg_rating"]=>
string(4) "3.00"
}