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 (
430644, 430664, 430988, 431073, 430730,
431043, 431083, 431135, 430628, 431089,
431167, 431459, 339831, 430829, 430842,
431063, 431183, 430662, 430844, 431066,
431313, 430651, 430869, 430928, 339762,
430769, 430880, 430898, 430899, 430884,
431035, 339781, 430653, 430684, 430712,
430847, 431140, 431142, 430631, 430891,
430962, 430626, 431185, 381713, 430893,
431093, 430881, 430909, 431031, 339733,
339691, 431123, 430797, 430896, 430900,
430980, 431197, 431250, 430633, 430806,
430873, 430883, 431226, 339600, 430837,
431088, 430645, 430685, 430787, 430876,
430930, 431023, 431064, 430913, 339488,
430768, 430841, 431008, 431078, 431131,
339804, 339594, 430676, 430772, 430802,
430981, 431119, 430758, 431032, 431121,
430760, 430796, 430846, 431113, 431159,
430698, 431198, 431356, 381712, 431178
)
AND cscart_product_review_prepared_data.storefront_id = 0