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 (
339707, 392169, 339656, 430908, 339769,
339807, 431115, 431133, 339829, 339758,
339677, 339809, 431050, 339729, 381702,
431150, 430747, 431026, 339648, 431158,
430681, 339851, 431195, 339479, 430748,
339847, 381696, 431122, 339654, 339712,
339746, 430907, 431102, 430924, 430998,
387047, 339704, 339735, 430648, 339664,
430696, 431201, 430771, 339760, 430916,
339485, 339817, 430824, 430915, 339720,
430636, 430638, 430823, 431139, 339812,
430743, 430857, 430646, 430813, 430935,
430803, 431120, 430821, 339714, 339835,
430831, 431145, 431151, 430665, 339668,
381698, 339715, 339761, 430649, 430751,
387049, 339671, 339820, 381699, 430647,
430848, 431127, 431109, 430766, 339694,
339650, 430903, 339593, 431114, 430660,
430817, 431097, 431163, 431194, 339849,
431103, 430902, 430912, 339755, 430807
)
AND cscart_product_review_prepared_data.storefront_id = 0