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=2473) WHERE (`e`.`entity_id` IN('33861', '33862', '33863', '33864', '33865', '33866', '33867', '33868', '33869', '33870', '33871', '33872', '33873', '33875', '33876', '33878', '33879', '33880', '33881', '33882', '33883', '33884', '33885', '43038', '43039', '43041', '43042', '43043', '43044', '43045', '43046', '43048', '43049', '43050', '43051', '43052', '43053', '43055', '43056', '43057', '43058', '43059', '43060', '43061', '43062', '43063', '43064', '43065', '43066', '43067', '43068', '43069', '43071', '43072', '43073', '43074', '43075', '43076', '43077', '43078', '43079', '43080', '43081', '43082', '43083', '43084', '43085', '43086', '43087', '43088', '43089', '43090', '43091', '43092', '43093', '43094', '43095', '43096', '43097', '43098', '43099', '43100', '43101', '43102', '43103', '43104', '43105', '43106')) ORDER BY `at_position`.`position` DESC LIMIT 24
