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 (
7690, 11058, 7691, 11003, 11098, 11052,
7698, 11015, 7692, 11060, 8470, 11094,
8469, 8462, 8465, 8065, 8056, 8709,
8554, 8537, 8538, 8532, 8533, 8539,
36411, 36607, 36590, 36598, 36617,
36588, 36597, 36594, 36609, 36618,
36616, 36610, 54994, 36592, 36587,
54995, 36586, 36593, 55577, 36591,
55008, 55047, 55576, 20483, 30710
)
AND cscart_product_review_prepared_data.storefront_id = 0