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 (
431132, 339796, 391798, 339457, 265042,
339477, 339541, 431162, 339700, 339811,
431202, 339489, 392172, 431099, 431128,
339458, 339623, 339469, 431155, 430639,
339453, 339797, 339798, 339606, 392167,
431141, 339699, 339643, 431130, 431168,
339482, 339685, 431153, 431154, 339730,
431096, 431137, 339731, 392175, 339463,
381703, 339709, 430637, 431125, 431124,
339478, 381725, 339460, 430911, 339468,
431094, 431146, 430640, 431134, 339467,
430745, 431048, 431187, 339753, 431033,
339810, 339808, 339696, 430767, 339805,
431067, 339757, 339787, 339701, 339806,
430697, 431191, 339794, 431090, 431117,
339464, 431065, 431104, 431107, 431157,
431116, 381701, 392166, 381687, 431204,
339452, 431196, 431084, 339752, 339750,
339695, 339814, 430655, 430744, 430850,
431203, 431160, 431176, 431100, 339707
)
AND cscart_product_review_prepared_data.storefront_id = 0