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=1459) WHERE (`e`.`entity_id` IN('15618', '22597', '22598', '22599', '22600', '22601', '22602', '32064', '40473', '40474', '40475', '40476', '40477', '40478', '40479', '40480', '40481', '40482', '40483', '40485', '40486', '40487', '40488', '40489', '40490', '40491', '40492', '40493', '40494', '40496', '40497', '40498', '40499', '40500', '40501', '40502', '40503', '40504', '40506', '40507', '40508', '40509', '40510', '40511', '40513', '40514', '40515', '40516', '40517', '40518', '40519', '40520', '40521', '40522', '40523', '40524', '40525', '40526', '40527', '40528', '40529', '40530', '40531', '40532', '40533', '40534', '40535', '40536', '40537', '40538', '40539', '40540', '40541', '40542', '40543', '40544', '40545', '40546', '40547', '40548', '40549', '40550', '40551', '40552', '40553', '40554', '40555', '40556', '40557', '40558', '40559', '40560', '40561', '40562', '40563', '40564', '40565', '40566', '40567', '40568', '40569', '40570', '40571')) ORDER BY `at_position`.`position` DESC LIMIT 24
