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 (
391789, 265231, 81619, 285940, 81632,
271489, 81662, 339530, 265039, 265034,
285937, 271497, 387095, 81615, 392212,
285942, 339446, 271493, 81639, 271504,
265258, 81706, 265031, 339514, 264987,
265041, 265261, 265263, 339551, 271500,
339521, 286476, 81649, 264988, 285945,
271506, 265244, 265256, 271496, 271492,
339501, 151897, 339499, 285939, 339495,
339721, 366887, 392150, 81622, 392214,
392215, 265038, 81652, 271498, 81697,
339494, 265242, 339503, 339531, 224456,
81693, 339516, 285938, 81660, 271510,
359818, 285943, 271503, 339539, 285941,
339447, 339509, 81669, 271494, 264989,
285946, 264990, 271502, 265232, 265254,
339636, 285966, 285970, 114755, 339637,
339492, 285968, 339538, 369244, 271490,
339506, 265250, 265001, 265237, 271505,
339724, 392179, 339635, 81628, 339502
)
AND cscart_product_review_prepared_data.storefront_id = 0