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 (
430732, 430942, 431453, 430833, 430985,
431076, 431466, 431480, 339768, 431219,
431330, 430750, 431210, 431353, 431438,
431452, 431481, 430719, 431222, 431239,
431380, 430724, 430987, 431181, 431241,
431285, 431377, 431387, 431447, 381709,
430632, 430693, 430727, 431229, 431384,
431412, 431440, 431208, 431292, 431385,
431502, 430733, 431236, 431188, 431281,
430682, 430721, 431259, 431224, 431361,
431335, 431421, 430699, 431249, 431253,
431332, 430701, 430955, 431040, 431458,
430951, 431081, 431172, 431402, 430731,
430757, 430945, 431009, 431263, 431431,
430970, 431143, 431170, 431215, 431298,
431468, 431472, 381715, 430736, 431414,
431442, 431455, 431478, 381706, 431364,
431401, 431454, 430941, 431180, 431369,
381708, 430725, 430954, 431233, 431378,
431446, 431014, 431212, 431213, 431225
)
AND cscart_product_review_prepared_data.storefront_id = 0