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