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 (
20482, 20543, 20496, 20495, 20492, 20489,
20498, 20497, 20540, 20541, 20542,
20491, 20422, 20493, 20480, 20483,
20467, 20477, 20511, 20494, 20499,
20234, 20272, 20479
)
AND cscart_product_review_prepared_data.storefront_id = 0