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 (
350511, 355422, 350579, 355405, 350381,
350420, 350306, 354322, 350347, 354323,
350342, 350368, 355618, 350283, 355620,
354738, 350435, 355619, 350504, 355446,
350226, 350335, 350442, 350448, 350468,
355421, 354526, 350345, 350456, 356842,
350385, 350513, 355389, 350282, 350519,
355408, 355412, 350417, 358345, 353702,
350337, 350412, 358351, 350362, 355406,
350462, 353716, 350583, 354523, 350375,
358343, 350352, 353726, 350361, 353701,
350268, 350377, 350410, 350411, 354743,
355429, 355425, 350346, 355418, 358333,
350313, 350373, 353712, 353723, 355415,
355417, 355438, 354524, 350379, 350380,
350388, 355396, 355409, 355439, 355420,
350382, 350403, 354525, 358348, 358349,
350378, 355395, 353105, 353813, 350589,
355411, 358350, 350393, 350311, 355390,
358353, 358347, 350384, 350310, 350421
)
AND cscart_product_review_prepared_data.storefront_id = 0