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=105) WHERE (`e`.`entity_id` IN('1594', '1597', '1598', '7107', '8267', '8561', '8610', '8724', '8731', '8740', '8806', '8851', '8862', '13835', '14086', '14095', '14631', '14632', '14633', '14721', '14724', '15287', '15330', '15643', '15649', '15673', '18484', '19443', '23892', '23893', '23894', '23901', '24045', '24054', '26696', '28270', '28274', '28277', '28272', '30952', '28269', '28271', '28273', '28275', '28276', '31557', '35879', '39303', '39304', '39305', '39306', '39307', '39308', '39309', '39310', '39312', '39313', '39314', '39315', '39318', '39320', '39322', '39323', '39324', '39328', '39329', '39330', '39331', '39332', '39333', '39335', '39336', '39337', '39339', '39340', '39341', '39344', '39345', '39346', '39347', '39348', '39352', '39353', '39354', '39355')) ORDER BY `at_position`.`position` DESC LIMIT 24
