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,35547,35573,35582,47554,48063,8797,8837,19625,23700,35548,35574,35583,47557,48066,24341,24202,22557)
AND stock_status = 'instock'
AND max_price > 0
array(5) {
["total"]=>
int(52)
["avg_price"]=>
string(4) "1019"
["min_price"]=>
string(3) "579"
["max_price"]=>
string(4) "2090"
["avg_rating"]=>
string(1) "4"
}