Search results for: '1')'

SELECT `e`.*, `price_index`.`price`, `price_index`.`tax_class_id`, `price_index`.`final_price`, IF(price_index.tier_price IS NOT NULL, LEAST(price_index.min_price, price_index.tier_price), price_index.min_price) AS `minimal_price`, `price_index`.`min_price`, `price_index`.`max_price`, `price_index`.`tier_price`, IFNULL(review_summary.reviews_count, 0) AS `reviews_count`, IFNULL(review_summary.rating_summary, 0) AS `rating_summary`, `stock_status_index`.`stock_status` AS `is_salable` FROM `catalog_product_entity` AS `e` INNER JOIN `catalog_product_index_price` AS `price_index` ON price_index.entity_id = e.entity_id AND price_index.customer_group_id = 0 AND price_index.website_id = '1' INNER JOIN `catalog_product_website` AS `product_website` ON product_website.product_id = e.entity_id AND product_website.website_id = 1 LEFT JOIN `review_entity_summary` AS `review_summary` ON e.entity_id = review_summary.entity_pk_value AND review_summary.store_id = 1 AND review_summary.entity_type = (SELECT `review_entity`.`entity_id` FROM `review_entity` WHERE (entity_code = 'product')) INNER JOIN `cataloginventory_stock_status` AS `stock_status_index` ON e.entity_id = stock_status_index.product_id WHERE (stock_status_index.stock_status = 1) AND (e.entity_id IN (8150, 7739, 7844, 7743, 12728, 7747, 8600, 7990, 7940, 7751, 9200, 7864, 7820, 7767, 7759, 3120, 7763, 12654, 9572, 12542, 12530, 10728, 12622, 10724, 12658, 12650, 12642, 12626, 12618, 12550, 12546, 12526, 12662, 12638, 12634, 12630, 12534, 12522, 12518, 8532, 8514, 8510, 8506, 8502, 12646, 12614, 10765, 8592, 10754, 10723, 10722, 10721, 10699, 10689, 10330, 8596, 10694, 10543, 10537, 10525, 10513, 10507, 10501, 10495, 10489, 10483, 10477, 10471, 10465, 10459, 10453, 10447, 10441, 10435, 10423, 10417, 10411, 10165, 10159, 10153, 10147, 10141, 10135, 10129, 10123, 10718, 10711, 10704, 10171, 10770, 10769, 10747, 12673, 10740, 10720, 10719, 10558, 10549, 10680, 10671)) ORDER BY FIELD(e.entity_id,8150,7739,7844,7743,12728,7747,8600,7990,7940,7751,9200,7864,7820,7767,7759,3120,7763,12654,9572,12542,12530,10728,12622,10724,12658,12650,12642,12626,12618,12550,12546,12526,12662,12638,12634,12630,12534,12522,12518,8532,8514,8510,8506,8502,12646,12614,10765,8592,10754,10723,10722,10721,10699,10689,10330,8596,10694,10543,10537,10525,10513,10507,10501,10495,10489,10483,10477,10471,10465,10459,10453,10447,10441,10435,10423,10417,10411,10165,10159,10153,10147,10141,10135,10129,10123,10718,10711,10704,10171,10770,10769,10747,12673,10740,10720,10719,10558,10549,10680,10671)