SELECT
AVG(price) as avg_price,
MIN(price) as min_price,
MAX(price) as max_price,
AVG(average_rating) as avg_rating
FROM wp_wc_product_meta_lookup
WHERE product_id IN (7709,7747,7748,7791,8898,10170,10174,26491,26493,26497,26503,41037,54399,63241,63512,7704,7712,7714,19632,19640,24533,24919,24938,24825,23911,23355,23353,26506,26512,26510,26507,41040,54400,63242,63513,24531,24551,24534,22551,22546)
AND stock_status = 'instock'
AND price > 0
array(1) {
["total"]=>
int(20)
}