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 (
30395, 30818, 30374, 30287, 30313, 30566,
30434, 30499, 30242, 30164, 30304,
30432, 30542, 30165, 30397, 30445,
30495, 30483, 30564, 30209, 30221,
30577, 30473, 30392, 30557, 30450,
30516, 30606, 30349, 30362, 30595,
30599, 30102, 30521, 30213, 30422,
30573, 30338, 30100, 30312
)
AND cscart_product_review_prepared_data.storefront_id = 0