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=71) WHERE (`e`.`entity_id` IN('5162', '5163', '8893', '8940', '9137', '15095', '15178', '15195', '15213', '17481', '21368', '21369', '21370', '21371', '21372', '22153', '23895', '23899', '24114', '24231', '24485', '24493', '24507', '24544', '24560', '24680', '24719', '24801', '24844', '24965', '25007', '25028', '25045', '25158', '25160', '25183', '25199', '25257', '25263', '25270', '25277', '25309', '25311', '25433', '25655', '25658', '25662', '25663', '25853', '25860', '25862', '25864', '25869', '25871', '25882', '25883', '25888', '25889', '25892', '25901', '25907', '25909', '25911', '25913', '25915', '25918', '25928', '25931', '26147', '26148', '26152', '26153', '26156', '26158', '26169', '26396', '26429', '26468', '26580', '27624', '27627', '34866', '34900', '35246', '36174', '36263', '38254', '38255', '38256', '38257', '38258', '38259', '38260', '38261', '38263', '38264', '38267', '38268', '38269', '38270', '38271', '38273', '38274', '38275', '38276', '38278', '38279', '38280', '38282', '38283', '38284', '38285', '38286', '38287', '38289')) ORDER BY `at_position`.`position` DESC LIMIT 24
