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=2212) WHERE (`e`.`entity_id` IN('21267', '21268', '21269', '21270', '21271', '21273', '21274', '21275', '21278', '21279', '21280', '21282', '21283', '21284', '21285', '21286', '21287', '21288', '21289', '21294', '21295', '21296', '21299', '21300', '21301', '21302', '21303', '21304', '21305', '21306', '21307', '21308', '21310', '21312', '21313', '21314', '21316', '21317', '21319', '27395', '27396', '37600', '37601', '37602', '37603', '37604', '37605', '37606', '37607', '37608', '37609', '37610', '37611', '37612', '37613', '37614', '37615')) ORDER BY `at_position`.`position` DESC LIMIT 24
