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 (7672,7687,7737,7740,8773,8820,8836,8861,8874,8901,16919,16983,31004,31009,54397,54549,58321,58328,58338,7790,8778,8834,8858,10128,15881,17009,19473,19477,24631,24633,58332,23621,24490,24921,24916,24421,24249,24205,24130,24086,23901,22929,22866,31008,31012,54398,54550,58322,58329,58339,59700,24827,24408,24211,24148,23378,22998,22853,22626,22623,25446,25445,58333)
AND stock_status = 'instock'
AND max_price > 0
array(5) {
["total"]=>
int(31)
["avg_price"]=>
string(6) "623.31"
["min_price"]=>
string(6) "199.00"
["max_price"]=>
string(8) "2,499.00"
["avg_rating"]=>
string(4) "1.69"
}