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 (
5136, 5042, 5025, 5355, 5356, 5368, 4995,
4392, 5229, 5429, 5430, 5428, 4519,
5050, 5230, 5250, 5431, 5231, 5367,
4864, 4865, 5232, 5432, 5433
)
AND cscart_product_review_prepared_data.storefront_id = 0