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 (
8175, 8389, 8390, 8391, 8886, 8553, 8451,
8176, 8961, 8962, 8151, 8152, 14469,
7980, 8154, 8313, 7979, 8256, 14468,
14467, 7685, 7680, 8403, 8143
)
AND cscart_product_review_prepared_data.storefront_id = 0