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=2207) WHERE (`e`.`entity_id` IN('8751', '22290', '26732', '26733', '26734', '26736', '26738', '26741', '26742', '26743', '26744', '26747', '26749', '26750', '26751', '26752', '26753', '26754', '26755', '26756', '26757', '26758', '26759', '26761', '26762', '26763', '26764', '26767', '26768', '26769', '26770', '26771', '26772', '26773', '26774', '26775', '26776', '26778', '26779', '34027', '34028', '35303', '35304', '35305', '35310', '35315', '35317', '35422', '35428', '35429', '35430', '35431', '35432', '35433', '35434', '35435', '35436', '35463', '35464', '35465', '35466', '35474', '35480', '35485', '35484', '35483', '35482', '35481', '43986', '43999', '44029', '44030', '44128', '44129', '44130', '44132', '44133', '44134', '44135', '44136', '44137', '44196', '44198', '44200', '44228', '44281', '44282', '44394', '44406', '44733', '44852', '44882', '44970', '44971', '44972', '44973', '45095', '45117', '45592', '45641', '45642', '45643', '45644', '45694', '45747', '45768', '45769', '45770', '54386', '54387')) ORDER BY `at_position`.`position` DESC LIMIT 24
