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 (
431037, 431056, 431262, 431012, 431186,
431392, 430793, 430799, 431034, 431334,
430683, 431289, 431301, 431354, 430877,
430879, 431166, 431244, 431344, 430920,
430926, 430946, 431000, 430659, 430706,
430997, 431020, 431218, 431291, 431406,
430741, 430864, 431021, 431248, 431309,
431322, 431368, 431487, 339481, 431349,
430761, 430792, 430858, 430882, 430949,
431038, 431101, 431252, 431280, 431469,
430830, 431230, 431376, 431420, 431429,
430740, 430919, 430975, 431295, 431303,
431360, 431464, 430642, 430671, 431410,
431424, 431470, 431047, 431055, 431350,
431474, 430643, 430739, 430867, 430957,
430982, 431060, 431279, 430679, 430814,
431211, 431237, 431341, 430735, 430948,
431149, 431246, 392168, 430798, 430667,
430734, 430764, 431234, 431287, 430934,
431010, 431273, 431324, 430718, 430754
)
AND cscart_product_review_prepared_data.storefront_id = 0