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 (
339484, 339755, 430807, 431068, 339697,
431359, 430875, 431041, 430825, 430868,
431085, 431156, 339681, 339828, 430925,
431053, 431164, 381705, 430819, 430820,
430901, 431013, 431049, 339596, 430654,
430658, 431144, 431148, 430691, 430989,
430746, 430808, 430812, 430834, 430629,
430680, 431136, 339774, 339765, 430843,
339728, 339836, 339843, 431110, 339725,
339734, 339816, 431080, 339655, 339839,
339599, 431118, 431161, 339466, 430673,
430890, 339845, 430789, 430859, 430906,
430922, 339582, 339723, 431082, 431126,
430657, 430678, 339702, 430737, 430822,
430860, 431111, 339674, 430689, 431044,
339754, 381704, 430795, 430832, 430892,
430914, 430921, 430635, 339802, 339821,
430663, 430838, 430854, 431174, 339486,
430650, 430959, 431456, 430815, 339727,
381697, 431169, 430672, 430695, 430950
)
AND cscart_product_review_prepared_data.storefront_id = 0