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 (
40617, 40645, 40646, 54711, 40650, 40647,
40675, 40684, 40668, 40614, 40676,
40644, 40659, 40618, 40683, 40685,
40664, 40642, 40655, 40678, 40605,
40686, 40649, 40677, 40660, 40609,
40656, 40670, 40682, 40710, 40711,
55943, 40657, 40648, 40663, 40613,
70304
)
AND cscart_product_review_prepared_data.storefront_id = 0