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 (7684,7689,7724,8945,8951,14404,14407,16955,16983,18456,28698,38503,47558,50745,53891,54549,58328,58338,7765,8756,8757,8825,8858,8935,8947,17526,17531,18012,40513,58332,24494,24526,24504,23457,23437,23036,22895,22866,22711,28816,38506,47566,50746,53892,54550,58329,58339,61133,24888,23583,23579,24227,24148,23483,23448,23325,22809,22804,22792,40565,58333)
AND stock_status = 'instock'
AND max_price > 0
array(5) {
["total"]=>
int(31)
["avg_price"]=>
string(6) "528.00"
["min_price"]=>
string(6) "169.00"
["max_price"]=>
string(8) "2,149.00"
["avg_rating"]=>
string(4) "2.00"
}