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 (7709,7719,7747,7748,7791,7836,7837,8878,8879,8881,8883,8898,13257,18297,18327,41037,44379,50480,63241,63512,7704,7712,7714,8742,8743,16950,18153,19632,19640,49998,24533,24560,24919,24938,24825,24740,24737,24065,24062,23770,24053,23911,23048,22754,22737,41040,44380,50481,63242,63513,24531,24551,24534,24479,24476,22900,22763,22551,22546,49999)
AND stock_status = 'instock'
AND max_price > 0
array(5) {
["total"]=>
int(30)
["avg_price"]=>
string(8) "1,127.00"
["min_price"]=>
string(6) "214.00"
["max_price"]=>
string(8) "8,100.00"
["avg_rating"]=>
string(4) "2.00"
}