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=2242) WHERE (`e`.`entity_id` IN('22403', '22405', '29239', '29240', '29242', '29243', '29244', '29247', '29248', '29249', '29251', '29253', '29254', '29255', '29256', '29260', '29263', '29264', '29265', '29266', '29267', '29269', '29271', '29272', '29273', '29274', '29275', '29276', '29277', '29279', '29282', '29284', '41539', '41540', '41541', '41542', '41543', '41544', '41546', '41548', '41549', '41550', '41551', '41552', '41553', '41554', '41555', '41556', '41557', '41558', '41559', '41560', '41561', '41562', '41563', '41564', '41565', '41566', '41567', '41568', '41569', '41570', '41571', '41572', '41573', '41574', '41575', '41576', '41577', '41578', '41580', '41581', '41582', '41583', '41584', '41585', '41586', '41587', '41588', '41590', '41592', '41593', '41595', '41596', '41597', '41598', '41599', '41600', '41601', '41602', '41603', '41604', '41605', '41606', '41607', '41608', '41609', '41610', '41611', '41612', '41613', '41614', '41615', '41616', '41617')) ORDER BY `at_position`.`position` DESC LIMIT 24
