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=44) WHERE (`e`.`entity_id` IN('1051', '1052', '4505', '4506', '4688', '4793', '8328', '8329', '8366', '8739', '8758', '15351', '15379', '15477', '15478', '15503', '15596', '15667', '22228', '22229', '22230', '22231', '22232', '22233', '22234', '22235', '22236', '22237', '22238', '22239', '22241', '22242', '22243', '22244', '22245', '22246', '22247', '22248', '22249', '22250', '22251', '22252', '22253', '22254', '22255', '22256', '22257', '22258', '22259', '22261', '22262', '22263', '22265', '24158', '24159', '24206', '24220', '24229', '24230', '24250', '24257', '24270', '24272', '24276', '24277', '24295', '24302', '24318', '24340', '24341', '24347', '24360', '24384', '24395', '24401', '24594', '24611', '24700', '24776', '24781', '24824', '24885', '24906', '24910', '24942', '24984', '25010', '25020', '25051', '25056', '25080', '25106', '25108', '25109', '25112', '25114', '25122', '25162', '25217', '25240', '25650', '25665', '25760', '26550', '31690', '31713', '31850', '31965', '31979', '32028', '35963', '36025', '36099', '37536', '37537', '37540', '37541', '37542', '37543', '37544', '37545', '37546', '37547', '37548', '37549', '37550', '37551', '37552', '37553', '37555', '37556', '37557', '37558', '37559')) ORDER BY `at_position`.`position` DESC LIMIT 24
