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 (8826,21139,28603,49706,50050,50181,55142,63253,7678,7699,8759,21799,28583,28593,22395,28634,50051,50182,55143,63254,24558,22321,28632,28633)
AND stock_status = 'instock'
AND max_price > 0
array(5) {
["total"]=>
int(10)
["avg_price"]=>
string(6) "899.00"
["min_price"]=>
string(6) "159.00"
["max_price"]=>
string(8) "3,749.00"
["avg_rating"]=>
string(4) "1.79"
}