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