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 (
10613, 10612, 10611, 15515, 15516, 18081,
18082, 18083, 10002, 7503, 10610, 10609,
10608, 10607, 11908, 18086, 18087,
10007, 10063, 10062, 10064, 9997, 10000,
9999
)
AND cscart_product_review_prepared_data.storefront_id = 0