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 (
220173, 339556, 254330, 339744, 339676,
339576, 339461, 391686, 339748, 392163,
387088, 339667, 339645, 151062, 339684,
151100, 254331, 339583, 387086, 339588,
339708, 387055, 339826, 339454, 339547,
339553, 339633, 387090, 339580, 339548,
339657, 339777, 339632, 339649, 339711,
339743, 339719, 339647, 339716, 339773,
339776, 387065, 339474, 339756, 339745,
339471, 387054, 265037, 339577, 339848,
339666, 339552, 339665, 339669, 339767,
339670, 387066, 339833, 339698, 339703,
220171, 339557, 339544, 339646, 339651,
339749, 339824, 339455, 339628, 339591,
387052, 339784, 339549, 339565, 339673,
339614, 339789, 339575, 339662, 265040,
339595, 339834, 339853, 339653, 339658,
339818, 339626, 339631, 339717, 339852,
339559, 339470, 339545, 339487, 339542,
339822, 339579, 339567, 271697, 339850
)
AND cscart_product_review_prepared_data.storefront_id = 0