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`, `cat_index`.`position` AS `cat_index_position`, `at_position`.`position` 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.website_id = '2' AND price_index.customer_group_id = 0
INNER JOIN `catalog_category_product_index` AS `cat_index` ON cat_index.product_id=e.entity_id AND cat_index.store_id=2 AND cat_index.visibility IN(2, 4) AND cat_index.category_id = '2'
LEFT JOIN `aw_shopbybrand_brand_product` AS `at_position` ON (at_position.`product_id`=e.entity_id) AND (brand_id=245) WHERE (`e`.`entity_id` IN('641', '4652', '4744', '5167', '8778', '8792', '8864', '10676', '12999', '13002', '13008', '13009', '13011', '13012', '13013', '13014', '13015', '13016', '13018', '13019', '13020', '13024', '13025', '13027', '13029', '13030', '13032', '22704', '26405', '31735', '31765', '31771', '31787', '31821', '31906', '31919', '31950', '32046', '32086', '32155', '32171', '32174', '35980', '36022', '36065', '36105', '36176', '36220', '43375', '43376', '43377', '43379', '43380', '43381', '43382', '43383', '43384', '43385', '43387', '43388', '43389', '43390', '43391', '43392', '43393', '43394', '43395', '43396', '43397', '43398', '43399', '43400', '43401', '43402', '43403', '43404', '43405', '43406', '44851', '44856', '45834')) ORDER BY `at_position`.`position` DESC LIMIT 24
