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 (
381712, 339825, 430703, 430845, 431042,
431200, 430885, 381711, 430865, 430976,
431316, 430887, 430904, 430936, 430992,
431238, 431251, 431393, 339855, 430661,
430753, 430756, 430836, 431003, 431046,
431061, 430801, 430810, 430866, 430939,
431011, 431029, 431072, 431171, 431193,
431333, 430932, 430788, 430809, 430999,
431052, 431192, 431205, 430905, 430910,
430927, 430749, 430862, 431062, 431463,
339726, 430634, 430794, 430870, 431039,
431091, 431314, 431024, 431315, 431327,
430677, 430704, 430714, 430853, 430888,
430923, 431098, 431242, 430687, 431028,
430641, 430675, 430707, 430713, 430851,
430895, 431112, 431326, 431339, 430694,
430708, 430738, 430782, 430811, 430827,
430861, 430874, 430937, 431077, 431308,
431365, 339838, 431245, 339841, 430855,
431054, 430800, 430852, 430863, 431129
)
AND cscart_product_review_prepared_data.storefront_id = 0