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 (
19390, 19391, 16954, 8125, 8126, 7969,
8357, 8299, 8879, 8358, 7451, 8671,
8242, 8124, 8239, 8376, 8814, 8377,
8241, 12403, 8238, 8159, 8240, 8375
)
AND cscart_product_review_prepared_data.storefront_id = 0