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 (40246,40255,49205,53445,53447,53452,54099,54103,8845,8846,8847,8848,8851,40574,40576,49206,53446,53448,53453,54100,54104,24183,24181,24179,24177,23551)
AND stock_status = 'instock'
AND max_price > 0
AND min_price > 0
array(1) {
["total"]=>
int(38)
}