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 (7688,7690,7759,7763,7764,7794,7797,8815,8816,8843,20314,20324,21150,51618,59718,63565,7741,7760,8788,8814,11324,19494,26662,24519,24527,24969,24945,24964,24812,24805,24294,24290,24188,22426,22409,22364,51619,59719,63566,24913,24954,24380,24297,23335,22611,26664)
AND stock_status = 'instock'
AND max_price > 0
Покупка товаров в категории “Вина червоне дольчетто корвіна матаро монастрель руфете тінто” - основная информация