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 (
19958, 19959, 20134, 19906, 20031, 20032,
20183, 19939, 20197, 20196, 20198,
20193, 20194, 20195, 20199, 20200,
19930, 19985, 19931, 19932, 19895,
19933, 20146, 20143
)
AND cscart_product_review_prepared_data.storefront_id = 0