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=246) WHERE (`e`.`entity_id` IN('10102', '10106', '10109', '10110', '10111', '10112', '10113', '10121', '10122', '10129', '11983', '11984', '12058', '12081', '12127', '12128', '12129', '12134', '12202', '12208', '12272', '12285', '12338', '12551', '12613', '12672', '12729', '12735', '12736', '12738', '12739', '12746', '12786', '12907', '14240', '14255', '14291', '14292', '17205', '17319', '17444', '17534', '17538', '17555', '17567', '17571', '17598', '17599', '17631', '17638', '17750', '17795', '17796', '17909', '17910', '17914', '17929', '17930', '18107', '18346', '18870', '29729', '29732', '29734', '29737', '29741', '29742', '29747', '29749', '29751', '29752', '29753', '29754', '29761', '34326', '34428', '34429', '34480', '34644', '34645', '34646', '34647', '43747', '43748', '43749', '43750', '43751', '43752', '43753', '43754', '43755', '43756', '43757', '43758', '43759', '43760')) ORDER BY `at_position`.`position` DESC LIMIT 24
