SELECT
ROUND(AVG(max_price)) as avg_price,
ROUND(MIN(max_price)) as min_price,
ROUND(MAX(max_price)) as max_price,
ROUND(SUM(average_rating * rating_count) / SUM(rating_count),2) as avg_rating,
ROUND(SUM(rating_count)) as rating_count
FROM wp_wc_product_meta_lookup
WHERE product_id IN (7748,7804,8755,8765,8792,8817,8833,8900,8939,10095,13257,16926,18327,18823,19101,19507,24635,26491,26503,35607,35755,35758,35774,35800,35802,35818,44362,44368,44634,44637,48073,50783,50794,53304,54089,61824,63241,63512,63565,7704,7712,7786,7839,8737,8740,8746,8748,8752,8753,8764,8771,8772,8779,8788,8801,8803,8807,8853,8866,8936,10125,14431,15885,15890,16979,17171,17173,18728,19093,19533,19640,24637,35487,35490,35492,35810,35816,36004,24938,24797,22464,24435,24361,24276,24214,23903,23475,23386,23048,22925,22737,22684,22670,22605,25444,26506,26507,35609,35757,35761,35776,35801,35805,35820,44367,44371,44636,44639,48074,50784,50795,53305,54090,61825,63242,63513,63566,24531,24551,24838,24733,24486,24484,23312,23307,23589,23587,24437,25586,22461,24405,24380,24329,24324,23057,22431,24109,23481,23380,23019,22994,22989,22870,22834,22829,22698,22675,22592,22546,25443,35489,35491,35493,35811,35817,36007)
AND stock_status = 'instock'
AND max_price > 0
Покупка товаров в категории “Вина каберне совіньйон корвіна нозіола рабігату санджовезе” - основная информация