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 (27744,27747)
AND stock_status = 'instock'
AND max_price > 0
AND min_price > 0
array(1) {
["total"]=>
int(1)
}
