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, 7747, 8600, 7990, 7940, 9200, 7864, 3150, 7820, 7767, 7759, 3120, 3155, 12839, 12654, 12872, 12860, 12834, 12542, 12530, 10728, 12672, 12622, 12866, 12854, 12829, 12824, 12735, 12723, 12698, 12693, 12658, 12650, 12642, 12626, 12618, 12550, 12546, 12526, 10724, 12703, 12688, 12662, 12638, 12634, 12630, 12534, 12522, 12518, 8532, 8514, 8510, 8506, 8502, 12896, 12718, 12646, 12614, 10765, 8592, 12876, 12708, 10754, 8596, 12901, 12891, 12886, 12881, 12731, 8522, 10769, 10747, 12673, 10770, 10740, 12848, 9196, 12842, 10736, 11807, 10732, 7791, 7789, 9191, 12677, 8585, 8578, 8139, 7835, 11848, 11841, 11829, 11823, 11817, 8128, 7790, 7788, 12181, 7839, 12930)) ORDER BY FIELD(e.entity_id,8150,7747,8600,7990,7940,9200,7864,3150,7820,7767,7759,3120,3155,12839,12654,12872,12860,12834,12542,12530,10728,12672,12622,12866,12854,12829,12824,12735,12723,12698,12693,12658,12650,12642,12626,12618,12550,12546,12526,10724,12703,12688,12662,12638,12634,12630,12534,12522,12518,8532,8514,8510,8506,8502,12896,12718,12646,12614,10765,8592,12876,12708,10754,8596,12901,12891,12886,12881,12731,8522,10769,10747,12673,10770,10740,12848,9196,12842,10736,11807,10732,7791,7789,9191,12677,8585,8578,8139,7835,11848,11841,11829,11823,11817,8128,7790,7788,12181,7839,12930)