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 (
8819, 8453, 8632, 7831, 7167, 8027, 7694,
12087, 12088, 12089, 12090, 12084,
12085, 12086, 18675, 18680, 18610,
18611, 18612, 18633, 18553, 18491,
18492, 18493
)
AND cscart_product_review_prepared_data.storefront_id = 0