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 (8951,14404,14407,16983,19531,19683,28698,40740,49422,50745,51650,53891,54195,54549,58328,58338,7765,8729,8825,8852,8858,8868,8892,8893,8894,8895,8896,10128,17526,17531,18012,19690,19798,40513,42351,58332,23437,23036,22866,22597,22526,28816,40742,49423,50746,51651,53892,54196,54550,58329,58339,61133,24888,23599,24227,22444,24148,24101,23939,23938,23937,23931,23926,23378,23325,22809,22804,22792,22521,22477,40565,42352,58333)
AND stock_status = 'instock'
AND max_price > 0
Покупка товаров в категории “Вина біле бленд макабео марсан нозіола савайон” - основная информация