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 (7688,7837,7849,8792,8953,8960,14409,16993,17539,18021,18125,19101,21141,26491,28710,35607,44637,49866,50749,50764,53887,54304,54306,54376,54380,59703,61853,7732,7768,8752,8753,8779,8801,8823,8857,8920,8952,17542,18728,19093,21152,21157,21796,35487,35490,36004,49998,54342,24519,24737,24731,24361,23428,23414,22862,22799,22788,22768,22670,26506,28815,35609,44639,50750,53888,54305,54307,54377,54381,59704,61854,24930,24847,23589,23587,24405,24329,24233,24154,23539,23434,23323,22797,22698,22675,22325,35489,35491,36007,49999,54343)
AND stock_status = 'instock'
AND max_price > 0
AND min_price > 0
array(1) {
["total"]=>
int(48)
}