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,7750,7807,7809,7814,8773,8820,8822,8826,8874,8899,10167,17457,19531,26499,31009,34442,35806,36001,40740,49422,50019,50050,51846,53456,54397,58321,59604,7699,7706,7838,8778,8796,8802,8834,8852,8908,8909,19473,19619,19648,19798,24633,33240,35549,35567,35996,40411,41033,44393,61826,23621,24941,24788,24785,24778,24421,24249,24240,24224,24086,23906,23359,22818,22597,26509,31012,34444,35809,36002,40742,49423,50020,50051,51848,53457,54398,58322,59605,24558,24537,24735,24408,24346,24327,24211,22444,23715,23710,22626,22561,22540,22477,25445,33243,35550,35568,36000,40596,41034,44396,61827)
AND stock_status = 'instock'
AND max_price > 0
array(5) {
["total"]=>
int(51)
["avg_price"]=>
string(6) "807.48"
["min_price"]=>
string(6) "194.00"
["max_price"]=>
string(8) "3,290.00"
["avg_rating"]=>
string(4) "2.33"
}