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 (7767,7787,7788,7789,7837,8792,8800,8833,8862,16069,19101,19482,21141,26491,30788,35607,44637,49866,50764,63565,7677,8752,8753,8760,8779,8788,8801,8835,8920,10125,15934,15943,18728,19093,21152,21157,21801,35487,35490,35492,49998,50173,24873,24836,24834,24830,24737,24361,24332,24214,24124,22964,22670,22618,22388,26506,30791,35609,44639,49867,50765,63566,23617,23589,23587,23564,24405,24380,24329,24207,23539,23380,22980,22972,22698,22675,22359,22349,22312,35489,35491,35493,49999,50174)
AND stock_status = 'instock'
AND max_price > 0
array(5) {
["total"]=>
int(42)
["avg_price"]=>
string(8) "1,030.37"
["min_price"]=>
string(6) "194.00"
["max_price"]=>
string(8) "2,590.00"
["avg_rating"]=>
string(4) "2.23"
}