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=1923) WHERE (`e`.`entity_id` IN('17159', '17190', '18009', '18012', '18049', '18585', '29449', '29451', '29452', '29453', '29454', '29455', '29456', '29457', '29459', '29460', '29461', '29462', '29464', '29467', '29473', '29476', '29484', '29486', '29487', '29489', '29495', '29496', '29497', '29498', '29499', '29501', '29502', '29506', '29508', '29509', '29510', '29511', '29512', '29513', '29514', '29515', '29517', '29519', '29533', '29534', '29536', '29537', '29549', '29550', '29551', '29554', '29555', '29558', '34529', '34769', '34770')) ORDER BY `at_position`.`position` DESC LIMIT 24
