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=241) WHERE (`e`.`entity_id` IN('375', '376', '428', '445', '446', '447', '481', '482', '483', '485', '523', '524', '525', '575', '576', '637', '638', '639', '640', '660', '699', '833', '931', '932', '933', '934', '935', '5157', '5158', '7109', '7110', '7111', '7112', '8572', '8576', '8582', '8583', '8618', '8627', '8628', '8639', '8742', '10159', '10898', '10903', '10911', '10964', '10965', '11271', '11273', '11274', '11276', '11279', '11280', '11281', '11284', '11287', '11289', '11290', '11291', '11292', '11293', '11294', '11296', '11299', '11301', '11302', '11303', '11305', '11308', '11309', '11310', '11311', '11312', '11313', '11314', '11316', '11317', '11318', '11319', '11320', '11321', '11322', '11323', '11324', '11325', '11327', '16854', '17329', '18881', '19460', '19461', '19465', '19515', '19516', '19517', '19518', '19519', '19520', '19552', '20051', '30073', '30075', '30074', '31047', '31473', '31555', '31575', '32413', '32446', '32480', '32481', '32627', '32628', '32642', '32646', '32963', '33019', '33022', '33045', '33046', '33047', '33048', '33196', '31401', '31402', '33945', '34270', '36234', '36498', '44546', '44547', '44548', '44549', '44550', '44552', '44553', '44554', '44567', '44568', '44577', '44578', '44579', '44580', '44582', '44794', '44952', '44954', '44955', '44956', '44957', '45657', '45660', '45662')) ORDER BY `at_position`.`position` DESC LIMIT 24
