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=1777) WHERE (`e`.`entity_id` IN('17006', '17023', '23442', '23443', '23444', '23445', '24818', '24953', '25034', '25569', '26515', '26542', '29324', '29325', '29328', '32777', '41782', '41783', '41784', '41785', '41786', '41787', '41788', '41789', '41791', '41792', '41793', '41794', '41795', '41796', '41797', '41798', '41799', '41800', '41801', '41802', '41803', '41804', '41805', '41806', '41807', '41808', '41810', '41811', '41812', '41815', '41816', '41818', '41820', '41821', '41822', '41824', '41825', '41826', '41827', '41828', '41829', '41831', '41832', '41833', '41834', '41835', '41836', '41838', '41839', '41840', '41842', '41843', '41844', '41848', '41849', '41851', '41852', '41853', '41854', '41855', '41856', '41857', '41858', '41859', '41860', '41862', '41865', '41866', '41867', '41868', '41870', '41871', '41872', '41873', '41874', '41875', '41876', '41877', '41878', '41879', '41880', '41881', '41882', '41883', '41885', '41886', '41887', '41888', '41889', '41890', '41891', '41892', '41893', '41895', '41896', '41897', '41898', '41899', '41900', '41901', '41902', '41903', '41904', '41905', '41907', '41908', '41909', '41910', '41911', '41912', '41914', '41915', '41916', '41917')) ORDER BY `at_position`.`position` DESC LIMIT 24
