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 (
431129, 431338, 431423, 431439, 430656,
430947, 430993, 431051, 339782, 430722,
430723, 430778, 430816, 430856, 430984,
431074, 339718, 339675, 430688, 430702,
431005, 431165, 431247, 430627, 431007,
431027, 431184, 339604, 430720, 430742,
430805, 430839, 430878, 430933, 430994,
431022, 430991, 431177, 431357, 430917,
430990, 431019, 431108, 431264, 430826,
430889, 430918, 431275, 431297, 431426,
430690, 430791, 430840, 430872, 430940,
430652, 430790, 430835, 430897, 430977,
431342, 430674, 430804, 430828, 430886,
430979, 431220, 431358, 431501, 430958,
430960, 430968, 431138, 430871, 430931,
430952, 431006, 431345, 431428, 339597,
430780, 430786, 430969, 431288, 431467,
430715, 430770, 430894, 430953, 430972,
431336, 431451, 339846, 387050, 431037,
431262, 431395, 430666, 430692, 430726
)
AND cscart_product_review_prepared_data.storefront_id = 0