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 (
430995, 431087, 431290, 431381, 431004,
431231, 431405, 430983, 431071, 431497,
430762, 431274, 431411, 431495, 431017,
431175, 431182, 431434, 431465, 430686,
430974, 431045, 431403, 430755, 430765,
430785, 431001, 431494, 430965, 431025,
431457, 381710, 430963, 430966, 431002,
431240, 431329, 431343, 381707, 430630,
430964, 431243, 431304, 431425, 430752,
430773, 431284, 431394, 430711, 430961,
431328, 431505, 431235, 431362, 431408,
431422, 431498, 430971, 431079, 431355,
431383, 431015, 431152, 431260, 431283,
431407, 430669, 430700, 430705, 430759,
431105, 431488, 430943, 430978, 431018,
431057, 431069, 431340, 431352, 431409,
430944, 431217, 431337, 431419, 435510,
430929, 431030, 431311, 430717, 430781,
430938, 430973, 431346, 431427, 387046,
430956, 431302, 431415, 431482, 431500
)
AND cscart_product_review_prepared_data.storefront_id = 0