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 (7684,7689,7715,7724,7795,7796,19155,20316,43366,43371,48056,61839,8933,42546,24494,24526,24539,24504,24810,24807,22653,22418,43369,43373,48060,61840,23496,42547)
AND stock_status = 'instock'
AND max_price > 0
Покупка товаров в категории “Вина біле гарганега греко рабігату вердехо Італія” - основная информация