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=528) WHERE (`e`.`entity_id` IN('12915', '13497', '13520', '14262', '14619', '14682', '14754', '14806', '14881', '14882', '14883', '14884', '14885', '14886', '14887', '14934', '14935', '14980', '14981', '14999', '15000', '15001', '17147', '17482', '17641', '17683', '17692', '17699', '17727', '17741', '17742', '17743', '17769', '17771', '17774', '17847', '17934', '17947', '17974', '17975', '18344', '18445', '18714', '18749', '26841', '26842', '26843', '26844', '26845', '26851', '26854', '26855', '26856', '26858', '26859', '26861', '32363', '32393', '33244', '33246', '33290', '34133', '34457', '34558', '34559', '34847', '34848', '34849', '34850', '34851', '34852', '34910', '34911', '34936', '34984', '35004', '35144', '35254', '35255', '35584', '35585', '35586', '35587', '36329', '36335', '36340', '36341', '36343', '36350', '36375', '36380', '36384', '36389', '36392', '36393', '36411', '36419', '36420', '36422', '36423', '36430', '36443', '36483', '36499', '36528', '36529', '36554', '36558', '36559', '36560', '36561', '36570', '36571', '36574', '36577', '36579', '36580', '36581', '36582', '36583', '36584', '36585', '36586', '36589', '36590', '36591', '36592', '36594', '36595', '36597', '36598', '36599', '36600', '36601', '36602', '43426', '43432', '43435', '43439', '43440', '43442', '43444', '44775', '44937')) ORDER BY `at_position`.`position` DESC LIMIT 24
