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 (
431070, 431397, 431433, 431255, 431389,
431268, 431398, 430783, 431432, 431306,
431443, 430775, 431305, 431399, 431493,
431386, 431417, 430784, 430967, 431444,
431272, 435512, 430776, 431016, 431254,
431416, 431484, 435513, 431490, 430763,
431371, 431461, 431216, 431318, 431319,
431271, 435515, 431269, 431372, 431373,
431173, 435514, 430729, 431267, 431270,
387051, 435516, 435517, 435518, 432250
)
AND cscart_product_review_prepared_data.storefront_id = 0