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=75) WHERE (`e`.`entity_id` IN('113', '4830', '4971', '15545', '15743', '23292', '23293', '23296', '23297', '23298', '23299', '23300', '23301', '23302', '23303', '23310', '23325', '23327', '23328', '23329', '23331', '23332', '23334', '23336', '24313', '24500', '24745', '25214', '25282', '25324', '27766', '27767', '31970', '32097', '32106', '38510', '38511', '38512', '38513', '38514', '38515', '38516', '38518', '38520', '38521', '38522', '38523', '38524', '38525', '38526', '38527', '38528', '38529', '38530', '38531', '38532', '38533', '38534', '38535', '38536', '38537', '38538', '38539', '38540', '38541', '38542', '38544', '38545', '38546', '38547', '38548', '38549', '38550', '38551', '38552', '38553', '38554', '38555', '38556', '38557', '38559', '38561', '38562', '38563', '38564')) ORDER BY `at_position`.`position` DESC LIMIT 24
