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=2051) WHERE (`e`.`entity_id` IN('1143', '17045', '17101', '17102', '17103', '17107', '23115', '23116', '23117', '23118', '23119', '23120', '23121', '23123', '23124', '23127', '24018', '25137', '29812', '31909', '36167', '36824', '36825', '36826', '36827', '36828', '36829', '36830', '36831', '36832', '36833', '36834', '36835', '36836', '36837', '36838', '36839', '36840', '36841', '36842', '36843', '36844', '36845', '36846', '36847', '36848', '36849', '36850', '36851', '36852', '36853', '36854', '36855', '36856', '36857', '36858', '36859', '36860', '36861', '36863', '36864', '36865', '36866', '36867', '36868', '36869', '36870', '36871', '36872', '36873', '36874', '36875', '36876', '36877', '36878', '36879', '36880', '36881', '36882', '36883', '36884', '36885', '36886', '36887', '36888', '36889', '36890', '36891', '36892', '36893', '36894', '36895', '36896', '36897', '36898', '36899', '36901', '36902', '36903', '36904', '36905', '36906', '36907', '36908', '36909', '36910', '36911', '36912', '36913', '36914', '36915', '36916', '36917', '36919', '36920')) ORDER BY `at_position`.`position` DESC LIMIT 24
