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 (7703,8833,8862,8890,8891,10089,15877,19482,21139,21141,48109,50178,50181,8736,8835,10131,11473,15885,21152,21155,21157,21801,49869,60938,24529,24214,24124,24035,24028,23391,23003,22618,22395,22388,48112,50179,50182,24488,24207,23376,23153,22994,22359,22354,22349,22312,49870,60942)
AND stock_status = 'instock'
AND max_price > 0
array(5) {
["total"]=>
int(24)
["avg_price"]=>
string(6) "597.69"
["min_price"]=>
string(6) "249.00"
["max_price"]=>
string(8) "1,064.00"
["avg_rating"]=>
string(4) "3.50"
}