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