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=973) WHERE (`e`.`entity_id` IN('13857', '17885', '17927', '18971', '18981', '21074', '21075', '21077', '21078', '21079', '21080', '21081', '21082', '21083', '21084', '21085', '21086', '21087', '21088', '21089', '21090', '21091', '21092', '21093', '21094', '21095', '21096', '21097', '21098', '21099', '21100', '21101', '21102', '21103', '21104', '21105', '21107', '21108', '21109', '21110', '21112', '21113', '21114', '21115', '21116', '21117', '21118', '21119', '21121', '21122', '26335', '26388', '26428', '26430', '26456', '26485', '26527', '26528', '26529', '26530', '26531', '26532', '26533', '26534', '26607', '26646', '26647', '26648', '26662', '26663', '26664', '26665', '26666', '26667', '26668', '26669', '26670', '26671', '26672', '26673', '26674', '26685', '26686', '26689', '26690', '26694', '26698', '26699', '27601', '27602', '27604', '27605', '27606', '27607', '27608', '27609', '27613', '27614', '27615', '27616', '27617', '27618', '27619', '27620', '27621', '35216', '35242', '35571', '44395')) ORDER BY `at_position`.`position` DESC LIMIT 24
