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