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=1546) WHERE (`e`.`entity_id` IN('1098', '1099', '1100', '1101', '1102', '1104', '1105', '1182', '4480', '4590', '4598', '4645', '4684', '5005', '5008', '5146', '5168', '8310', '8340', '8341', '8441', '8741', '8747', '8797', '8840', '8874', '8875', '8877', '8878', '8879', '8911', '10499', '14251', '15072', '15077', '15112', '15113', '15217', '15318', '15382', '18246', '18349', '18765', '18813', '18816', '19419', '23399', '23401', '24587', '24660', '26174', '26255', '26596', '26598', '26599', '26600', '26603', '26613', '28847', '28848', '28849', '28850', '28852', '28853', '28854', '28855', '28856', '28858', '28859', '28860', '28861', '31649', '31651', '31677', '31754', '31770', '31827', '31938', '32547', '34948', '34966', '35070', '35800', '35801', '35802', '35803', '35804', '35805', '35806', '35807', '41038', '41039', '41040', '41041', '41042', '41043', '41044', '41045', '41046', '41047', '41048', '41049', '41050', '41051', '41052', '41053', '41054', '41055', '41056', '41057', '41058', '41059', '41061', '41062')) ORDER BY `at_position`.`position` DESC LIMIT 24
