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 (
426897, 415377, 388453, 389558, 390161,
390193, 390198, 389507, 388957, 415496,
389263, 390209, 390316, 388958, 390273,
389359, 388544, 388479, 389452, 390257,
388513, 389873, 390129, 389532, 390192,
389827, 388454, 390243, 390164, 389428
)
AND cscart_product_review_prepared_data.storefront_id = 0