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=107) WHERE (`e`.`entity_id` IN('7106', '8268', '8669', '8717', '8719', '8720', '8722', '8729', '8754', '8757', '8763', '8766', '8787', '8802', '8890', '8906', '8963', '8969', '8971', '8985', '8996', '8997', '9018', '9033', '9046', '10923', '10961', '15305', '15306', '15308', '15310', '15314', '15315', '15316', '15317', '15319', '15321', '15323', '15342', '15343', '15345', '15352', '15353', '15354', '15356', '15368', '15369', '15370', '15371', '15377', '15385', '15388', '15390', '15395', '15397', '15398', '15401', '15408', '15432', '15505', '15506', '15508', '15528', '15532', '15536', '15549', '15555', '15563', '15570', '15573', '15617', '15621', '15625', '15626', '15627', '15630', '15631', '15632', '15634', '15636', '15637', '15638', '15640', '15647', '15651', '15652', '15654', '15661', '15666', '15668', '15670', '15675', '15696', '15698', '15703', '15704', '15705', '15706', '15707', '15708', '15709', '15710', '15722', '15723', '15725', '15726', '15729', '15737', '15738', '23969', '31593', '31594', '31597', '31605', '31612', '31615', '31835', '31861', '31862', '31863', '31864', '31865', '31866', '31867', '32002', '32048', '32092', '32143', '39356', '39357', '39358', '39359', '44810', '44910', '45098', '45085')) ORDER BY `at_position`.`position` DESC LIMIT 24
