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