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 (7673,7747,7769,7791,8765,8767,8768,8774,8775,8776,8783,8784,8785,8786,8793,8821,8912,8957,8958,8959,18798,18823,19101,51702,53452,54210,54216,54218,54220,54287,54289,54292,54294,54297,54299,54301,54392,59250,59254,59258,63241,7777,8763,8764,8766,8769,8770,8771,8772,8777,8779,8780,8781,8782,8791,8801,8810,8811,8813,8854,18704,18714,18728,18979,19093,19533,36004,23619,24919,24845,24825,24435,24429,24427,24419,24417,24415,24396,24394,24390,24388,24357,24246,23666,22481,22471,22467,22694,22684,22670,51703,53453,54215,54217,54219,54221,54288,54290,54293,54295,54298,54300,54302,54393,59251,59255,59259,63242,24843,24439,24437,24431,24425,24423,25586,22461,24413,24405,24402,24400,24398,24366,24329,23051,24307,24300,22415,22706,22702,22698,22680,22675,22592,36007)
AND stock_status = 'instock'
AND max_price > 0
Покупка товаров в категории “Вина червоне бордо бленд карменер Португізер тінто соусао” - основная информация