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 (
34120, 34399, 34410, 34409, 34302, 34148,
34334, 34339, 34559, 34347, 34575,
34603, 34370, 34456, 34525, 34594,
34262, 34510, 34097, 34171, 34090,
34137, 34326, 34508, 34567, 34454,
34288, 34610, 34281, 34431, 34312,
34381, 34415, 34266, 34130, 34168,
34321, 34451, 34485, 34601, 34318,
34152, 34342, 34373, 34374, 34098,
34478, 34275, 34590, 34295, 34386,
34497, 34577, 34540, 34165, 34198
)
AND cscart_product_review_prepared_data.storefront_id = 0