SELECT
cscart_product_review_prepared_data.product_id AS product_id,
cscart_product_review_prepared_data.average_rating AS average_rating,
cscart_product_review_prepared_data.reviews_count AS reviews_count
FROM
cscart_product_review_prepared_data
WHERE
cscart_product_review_prepared_data.product_id IN (
414502, 424699, 381632, 431672, 414375,
393012, 396068, 393013, 427473, 366897,
392222, 414480, 434596, 414400, 391702,
387084, 434591, 434595, 435213, 434592,
414498, 434594, 434593, 414414, 432460,
432542, 432589, 432449, 432642, 432668,
432523, 432652, 432688, 432694
)
AND cscart_product_review_prepared_data.storefront_id = 0