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=731) WHERE (`e`.`entity_id` IN('17017', '20418', '20419', '20420', '20421', '20422', '20423', '20424', '20426', '20427', '20428', '20431', '20432', '20433', '20434', '20435', '20436', '20437', '20438', '20439', '20440', '20441', '20442', '20443', '20444', '20445', '20446', '20447', '20448', '20449', '20450', '20451', '20452', '20454', '20455', '20456', '20457', '20459', '20460', '20468', '20469', '20473', '20474', '20478', '20480', '20481', '20483', '20484', '20485', '20487', '20488', '20490', '20491', '20494', '20497', '20499', '20500', '20501', '20502', '20503', '20504', '20505', '20506', '20507', '20508', '20509', '20510', '20517', '20529', '20530', '20531', '20897', '24464', '24480', '24690', '24743', '24880', '24926', '24962', '25004', '25013', '25159', '25223', '25244', '25249', '25589', '25603', '37381', '37383', '37384', '37385', '37386', '37387', '37388', '37389', '37390', '37391', '37392', '37393', '37394', '37396', '37397', '37398', '37399', '37400', '37404', '37405', '37406', '37407', '37408', '37409', '37410', '37411', '37412', '37413', '37414', '37415', '37416', '37417', '37418', '37419', '37420', '37421', '37422', '37424', '37425', '37431', '37433', '37434', '37435', '37436', '37438', '37439', '37441', '37442', '37443', '37444', '37445', '37446', '37447', '37448', '37449', '37450', '37451', '37452', '37453', '37454', '37455', '37456', '37458', '37459', '37460', '37461', '37462', '37463', '37465', '37466')) ORDER BY `at_position`.`position` DESC LIMIT 24
