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=378) WHERE (`e`.`entity_id` IN('11644', '17440', '17480', '17704', '17997', '18031', '18097', '18098', '18099', '18100', '18101', '18102', '18171', '18172', '18173', '18174', '18176', '18177', '18178', '18179', '18446', '18447', '18448', '18458', '18607', '18632', '18634', '18641', '18644', '18652', '18655', '18659', '18660', '18661', '18665', '18667', '18670', '18680', '18745', '28662', '28665', '28666', '28667', '28668', '28669', '28670', '28671', '28672', '28673', '28674', '28675', '28676', '28677', '28678', '28693', '28694', '28705', '28710', '28711', '28712', '28713', '28715', '28717', '28719', '28720', '28721', '28723', '28724', '28725', '28726', '28727', '28728', '28729', '28730', '28731', '28732', '28733', '28734', '28735', '28739', '28740', '28741', '28742', '28743', '28746', '28747', '28748', '28749', '28750', '28753', '28754', '28755', '28756', '28757', '28758', '28759', '28763', '28764', '28765', '28766')) ORDER BY `at_position`.`position` DESC LIMIT 24
