Farmalastic

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=1031) WHERE (`e`.`entity_id` IN('5107', '5108', '10466', '10467', '12172', '12174', '12198', '12265', '12266', '12267', '12355', '12356', '12357', '12358', '12531', '12612', '12631', '12645', '12740', '12751', '12752', '12781', '12810', '12811', '12812', '13597', '13844', '13848', '14172', '14173', '14176', '14177', '14304', '14305', '14353', '14357', '14358', '14359', '14582', '14623', '14643', '14673', '14677', '14684', '14693', '14782', '14828', '14829', '14920', '14921', '14922', '14923', '14924', '14925', '14926', '14955', '14956', '14957', '14983', '14997', '17201', '17207', '17215', '17240', '17256', '17281', '17301', '17322', '17371', '17396', '17772', '17933', '17951', '18019', '18020', '18064', '18065', '18207', '18208', '18209', '18339', '18615', '18623', '18624', '18625', '18647', '27810', '27811', '27816', '27817', '27818', '27820', '27821', '27822', '27823', '27824', '27825', '27826', '27827', '27828', '27829', '27830', '27831', '27832', '27833', '27834', '27835', '27836', '27839', '27840', '27841', '27842', '27843', '27844', '27845', '27846', '27847', '27849', '27850', '27854', '27855', '27856', '27857', '27858', '27859', '27860', '27861', '27862', '27863', '27864', '27865', '27867', '27868', '27870', '27872', '27873', '27877', '27878', '27879', '27880', '27881', '27882', '27883', '27884', '27885', '27886', '27887', '27888', '27889', '27890', '27891', '27892', '27893', '27894', '27895', '27896', '27897', '27898', '27899', '27900', '32543', '32544', '32545', '32707', '32708', '32709', '32840', '33004', '33077', '33078', '33079', '33080', '33280', '33281', '33282', '33283', '33284', '33285', '33286', '34402', '34747', '35651', '35652', '35656', '35657', '35658', '43546', '43547', '43548', '43550', '43551', '43555', '43556', '43557', '43558', '43559', '43560', '43561', '43562', '43563', '43564', '43565', '43566', '43567', '43568', '43569', '44818')) ORDER BY `at_position`.`position` DESC LIMIT 24