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 (
387039, 339692, 339737, 339535, 339534,
339573, 339496, 339617, 339620, 339621,
339742, 339611, 339533, 339710, 81689,
339587, 339683, 339444, 170248, 387094,
339722, 387042, 339570, 339610, 81674,
339584, 339771, 170250, 435270, 339638,
159865, 339625, 339706, 339529, 339751,
387037, 339736, 173787, 339618, 254333,
265275, 387092, 339569, 339581, 339615,
159861, 339770, 387040, 339705, 339608,
205885, 339619, 254332, 258305, 339783,
339693, 391684, 339732, 339779, 339759,
339607, 170249, 339572, 159863, 254325,
159864, 339775, 170247, 339476, 339589,
339652, 339571, 254327, 339778, 391687,
387089, 170216, 387056, 173789, 391688,
387096, 387093, 170251, 387041, 173763,
339738, 339456, 339686, 339550, 391689,
387098, 339780, 339739, 387045, 339644,
339747, 339586, 339630, 391800, 387044
)
AND cscart_product_review_prepared_data.storefront_id = 0