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 (
18220, 18205, 18198, 18197, 18216, 18210,
18219, 18222, 18212, 18196, 18217,
18202, 18206, 18224, 18208, 18201,
18203, 18213, 18200, 18221, 18194,
18207, 18199, 18209, 18223, 18218,
18195, 18211, 18215, 18204
)
AND cscart_product_review_prepared_data.storefront_id = 0