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=1185) WHERE (`e`.`entity_id` IN('17068', '22105', '22106', '22108', '22112', '22117', '22118', '22121', '22122', '22124', '22125', '22128', '22130', '22131', '22132', '22134', '22135', '22136', '22137', '22138', '22144', '22145', '22147', '22149', '22150', '24422', '24528', '24561', '24599', '24656', '24694', '25039', '38928', '38929', '38930', '38931', '38932', '38933', '38934', '38936', '38938', '38939', '38940', '38941', '38942', '38943', '38944', '38945', '38946', '38947', '38948', '38950', '38951', '38953', '38954', '38958', '38959', '38960', '38961', '38962', '38963', '38964', '38965', '38966', '38967', '38968', '38969', '38970', '38971', '38972', '38973', '38974', '38975', '38976', '38977', '38978', '38979', '38981', '38985', '38986', '38987', '38988', '38989', '38991', '38993', '38994', '38995')) ORDER BY `at_position`.`position` DESC LIMIT 24
